Pls help. I trying to combine two tables in one dropdown, 1st table is synced by typeform, and 2nd table is manually added.
I believe the typeform table is one giving me issue, since if I call for the 2nd table, the dropdown pops up no problem. But when I include the typeform table on the dropdown, it just lists down the names.
Is there anything I can do to include the typeform table to my dropdown?
Code:
ListCombine([View of Homeowners Insurance Survey].[Full Name], Clientz.[Full Name] )
Hi @Aiescer_Ibabao!
The issue is that for such a list, you need to set the column type not to “Relation,” but to “Select List” and specifically choose one of the options: “Status,” “Priority,” or “Size.” This allows you to use a formula in the property settings to gather lists from multiple different tables, exactly the formula you are using.
The “Relation” property type is designed to establish connections between specific tables, which is why it only returned values from the table it was linked to. On the other hand, “Select List” is more flexible and allows you to create lists by combining values from different sources.
Still broken. I have specifically used a ‘preset’ on the ‘select list’, wrote down ListCombine(Clientz.Full Name) doesnt work, I even wrote down just the table name and it should output the display column, it does output, but not dropdown style.
But If I call for another table’s name from a different page the drop down works.
I can call on the 2nd table (manually added client) alone no problem, I think its the typeform table that’s bringing me issue. But I need to combine the typeform table + manually added clients to one dropdown for the project.
You placed the formula in the wrong field. It needs to be added to the “Select List” settings. Take another look at my screenshot. Select the “Edit Column” option, and in the settings that appear, replace the default “Options” with a formula.
You placed the formula in the wrong field. It needs to be added to the “Select List” settings. Take another look at my screenshot. Select the “Edit Column” option, and in the settings that appear, replace the default “Options” with a formula.
Thank you