Forum Discussion

NehaRaghav1's avatar
NehaRaghav1
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 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
------------------------------
Formulas and functions

1 Reply

Sort By
  • 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
    ------------------------------