Forum Discussion

NehaRaghav1's avatar
NehaRaghav1
Qrew Member
2 years ago

Summary multi text field to be used as Record ID in Formula URL

Hi,  I have a multi text field having the record ID of next task on my list of tasks in a table I need to pick this record ID to be used in Formula URL in order to change the Task Status field o...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago
If you are asking just for the correct syntax it would be this, assumig that your field is populated with on value and not a string of values.

Try this


URLRoot()&"db/"&[TARGET TABLE ALIAS]"&"?a=API_EditRecord&rid="& totext([multi-text summary field]) &"&apptoken=*******************&_fid_57= In Progress"

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------