This should do it:"• " & SUBSTITUTE({your field here},", ","\n• ") If you expand the cell, or copy the text somewhere else you will see that it is working
Another thought - the above method is not very good if you don't want to show all of your data.A sort of way round this is to create a prefilled form to a table that references itself. If you conditionally hide input fields depending on whether the "...
By chance I have been considering the same question today, here is a possible solution:Create two forms, one for a dummy table that links to the table you are really interested in. The form just shows the linked record field.The second form is the re...
A final update for those interested…! After using for a while I have seen that this automation does randomly fail reasonably frequently. Failure seems to be correlated with situations in which there is more “going on”. Ie lots of records or moving th...
First of all thanks for everyone who took the time to consider my problem and especially to Justin for perservering.
When I created a fresh base, reproducing the essential structure and automations… it worked!
I tried cross referencing the base that ...
