what I’m doing at the moment is searching for all the records and using the values of the completed fields in the DB as selectable options in the dropdown.
for example, if I have a field called Status which can have 3 values only eg; Accepted, Pending and Rejected…
If I have a list of say 10 records with all the status as either Accepted or Pending (zero Rejected)… in the drowpdown there is no point as having ‘Rejected’ as a selectable option as there are no records with this value.
I am doing the same with the dropdown for Host, I want to only have options that actually exist, eg; those Users that are actual ‘Hosts’ available to be selected in the dropdown box, as oppose to having all users of the application.
The issue is that the Search pulls all the records correctly and I can even apply :unique elements to this…but I can not specify :unique elements to the ‘Option caption’…seems that it may be a gap here with Bubble possibly?
hope this makes sense?