Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
4 years ago

Modify Add Task Button to Checkbox on New Task/ Sub-Table

Hey Community - I'm looking to simply modify the existing/standard "Add Task" (Sub-Table) Button on my Parent table so that it can update a checkbox field for me on the new sub-record being created. I modified the URL formula code but it doesn't seem to work and just takes me back to the home screen - no error message. the checkbox field is FID194. Please let me know what's wrong with my code below.

Thank you, 



URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm"
& "_fid_192=" & URLEncode ([Record ID#])
& "&_fid_194=true"
& "&z=" & Rurl()

------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
APIs and custom code
Buttons
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    & "&_fid_192=" & URLEncode ([Record ID#])
    the line above is missing the &

    In the Quickbase the & character has two completely different meanings.  When used outside quotes it is a concatenation character exactly the same as excel. But when used inside the quotes it typically means "Heads up Quickbase! a parameter is coming next.  for example

    &rid=.. says "Hey Quickbase comes a Record ID
    &_fid_123= .. means Hey Quickbase here comes a parameter for Field ID 123 



    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      4 years ago
      that worked perfectly - I knew it was something little :)

      ------------------------------
      Jack Woods | Low Code 4 Lyfe
      ------------------------------