Skip to main content
Question

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

  • Feb 2, 2023 11:10 AM UTC
  • 0 replies
  • 51 views

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 of the target record. Is it feasible?

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

------------------------------
Neha Raghav
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------