After watching the tutorials, I have tried many times to generate a dropdown in a form that inserts data into a Supabase table using information from another table that contains a field_id and uses a rollup formula. For some reason, the list either shows up empty or, like in the screenshot, displays [object Object].
I couldn’t find any documentation or helpers on what exactly to enter in the formulas for Label, Value, and Disable under Options.
The Current Value and Expected Format under the formula are what I expect to be listed in the dropdown.
I think you want to use the select element rather then the dropdown. I think the dropdown is only for single text rather then objects. The select has those label and value fields easily accessible.
Actually, I want to show only text as options. Trying again, as you can see by the image after just change the “option” formula, the options are blank. The formula for Lable is Mapping. Label, for Value is Mapping.Value and for Disable is just false.
Your current data set you pass as “options” is an array of texts, not objects.
Inside an ordinary select element (NOT adanced) you need to have objects inside the array you pass as “options”.
There are plenty of ways you can achieve this. I think, you can just pass the whole “grades.data” array and then just pick right “laber per item” and “value per item”
With the select element (advanced) it works as is with your current array of texts. But I think it’s the wrong way to do that, because later it would be difficult to maintain the logic without clearly defined “labels” and “values”.
The new select doesn’t work yet with primitive values. This will come soon - it’s already in QA. For now, it needs to be an array of objects to ensure best results. This works with the old select.
