Multi Select Field with Links?

So is this the scenario?

There is a list of fruits in a multi select field type and the User selects all their favourite fruits in edit mode.

Then in view mode they see a list of fruits, but each one is hyperlinked and will take them to a specific record assigned to that fruit.




------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

I think you'll need to switch around your approach. You'll have to build the formula so that it references the selections in the Text Multi-select field and produces a link/links from that. Use the drop-down on Add/Edit and the formula on View.

In reality, though, I might encourage you to use a different approach altogether and have a child table to both your "fruits" table and the table where the current drop-down is. Your users could just use the embedded child report in Grid Edit to select their options when building the record.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------