Forum Discussion

Quickbase Staff

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

Qrew 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
------------------------------