Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Setting a Default button to add default values across multiple fields.

Hey Everyone, I have another question that I can't seem to figure out. Is there a way that I can add a button to my form that will auto-populate fields with default values, but the user can change ...
APIs and custom code
Buttons
AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago
Hey Ahuva,

Could you give me some tips on getting this set up? I've got the API Call set up and created an app token, changed the fid's to the desired values, but getting errors for invalid input (Code 2). Will this allow me to create a button that will add these values to the fields I select?

Thanks,

------------------------------
Alex Bennett
------------------------------
AhuvaBrown's avatar
AhuvaBrown
Qrew Cadet
5 years ago
Can you show me your code and the error messages?

------------------------------
Ahuva Brown
------------------------------
  • AlexBennett3's avatar
    AlexBennett3
    Qrew Trainee
    5 years ago
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=uw4jq7b9wmt6ybm59yqvc2dzpdj" & "&_fid_53=" & "3" & "&_fid_60=" & "3" & "&_fid_67=" & "2" & "&_fid_74=" & "2" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#])​

    ------------------------------
    Alex Bennett
    ------------------------------
    • AlexBennett3's avatar
      AlexBennett3
      Qrew Trainee
      5 years ago
      URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
      "&rid=" & [Record ID#] &
      "&apptoken=uw4jq7b9wmt6ybm59yqvc2dzpdj" &
      "&_fid_53=" & "3" &
      "&_fid_60=" & "3" &
      "&_fid_67=" & "2" &
      "&_fid_74=" & "2" &
      "&rdr=" &
      URLEncode(URLRoot() & "db/" & Dbid() &
      "?a=dr&rid=" & [Record ID#])

      Sorry for the format...
      And this is my first attempt at an actual API Call within QuickBase so I apologize!

      ------------------------------
      Alex Bennett
      ------------------------------
      • AhuvaBrown's avatar
        AhuvaBrown
        Qrew Cadet
        5 years ago
        If the fields you're trying to edit are numeric fields, it might help to write the URL this way, as the extra ampersands and quotations aren't technically necessary for numeric values.

        URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=uw4jq7b9wmt6ybm59yqvc2dzpdj" &
        "&_fid_53=3" &
        "&_fid_60=3" &
        "&_fid_67=2" &
        "&_fid_74=2" &
        "&rdr=" &
        URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=dr&rid=" & [Record ID#])

        If that doesn't help, did the error message provide you with any details other than the error code?
        I'm assuming the message looked something like this. Was there anything specified in the <errdetails> tag?

        <qdbapi>
        <action>API_EditRecord</action>
        <errcode>2</errcode>
        <errtext>Invalid input</errtext>
        <errdetail>
        details
        </errdetail>
        <rid>rid</rid>
        <num_fields_changed>0</num_fields_changed>
        <update_id/>
        </qdbapi>


        ------------------------------
        Ahuva Brown
        ------------------------------