Is It Possible to write while or for loop in formula field?
Is It Possible to write while or for loop in formula field? If possible ple explain with example. Thanks
Forum Discussion
How do I loop to lookup the next record that exists with one lower number of the record I am currently on.
I have a key field call ID but sometimes it can skip a number since the table is being imported from a SQL server.
I want to lookup the last call ID before the current one and it should subtract 1 until it finds a record with that Call ID.
I have a key field call ID but sometimes it can skip a number since the table is being imported from a SQL server.
I want to lookup the last call ID before the current one and it should subtract 1 until it finds a record with that Call ID.
Going back to this thread. Is there a way to loop or for each in a formula column?
I'm looking to add in a Rich Text formula column, hyperlinks for each value in a multi select column or for each record in the child table.
------------------------------
QuickBase 96
------------------------------
- MarkShnier__You
Qrew Legend
No problem
just make your perfect hyperlink on the child table as a rich formula field, and then roll it up to the parent as a combined tech summary field.
then on the parent, make a formula Rich Text field which will convert the Combined Text summary to text and replace the semi colon delimiters with a <br> character to give a nice vertical list
not tested but try
SearchAndReplace(
ToText([My combined text hyperlinks]),
" ; ", "<br>")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
