Forum Discussion

Wallace__DHS_Ye's avatar
Wallace__DHS_Ye
Qrew Trainee
4 years ago

URL Button to save and edit record

I am currently trying to build a url button that saves and edits a record simultaneously. The issue I ran into at first was the record was not completely saved so QuickBase didn't recognize it as a re...
APIs and custom code
Buttons
Wallace__DHS_Ye's avatar
Wallace__DHS_Ye
Qrew Trainee
4 years ago

Yup, so I have a default form that is set to be seen when users edit records and another form that users see when they add records. This form with this URL button is on the form used when users add record. So if the record is just saved it takes users to the wrong form - that's why I was looking to accomplish both actions with the URL button



------------------------------
Wallace (DHS)
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
I still really don't understand.  Do you want to use her to add a record and then are you saying you want to learn the user on that record and view mode on a certain form or land the user in edit mode on a certain platform. And then why are you redirecting to her page after that? I am still quite confused about the workflow you were trying to achieve.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • Wallace__DHS_Ye's avatar
    Wallace__DHS_Ye
    Qrew Trainee
    4 years ago
    So I have two forms in a table. One used to add new records and the other a default form that is used to edit records. The problem is I need QuickBase to change a checkbox to checked on the form that is used to add new records - but currently Quickbase is not letting me do both simultaneously with the button formula (add the record and edit to checked). Not sure if that clears things up a bit

    ------------------------------
    Wallace (DHS)
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      Try putting that field on the form in a field hidden by a form rule and changing the URL to this

      URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&apptoken=XX3"
      & "&dfid=10"
      & "&_fid_3=" & URLEncode ([Record ID#])
      & "&_fid_134=1"
      & "&NextURL=" &  URLEncode (XXXXX a=showpage&pageid=12")

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • QuickbasePipeli's avatar
        QuickbasePipeli
        Qrew Member
        4 years ago
        Perfecto! Thanks Mark! You da man!

        ------------------------------
        Quickbase Pipelines
        ------------------------------