Forum Discussion

HerberthSolano's avatar
HerberthSolano
Qrew Trainee
2 years ago

Edit Button

Hello Quickbase Community,  I need to create a button where I can edit a record from another table [_DBID_CLIENTES] related to my current table [_DBID_AUTOS] and return to the previous site. Ex...
RyanBuschmeyer1's avatar
RyanBuschmeyer1
Qrew Trainee
2 years ago
You definitely should be able to do that.  There are several members of this community who will be able to help with specific code. Essentially, you'll create a Formula URL button that opens an API_EditRecord link.  Then you'll need to get it to redraw back to your original location.

There is an app available in the Exchange called "Magic Buttons" that is amazingly useful for this type of development on your own.
Also, the API Boot Camp application that is bundled with the API training sessions from Quickbase University.

------------------------------
Ryan Buschmeyer
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    Not tested but try this as a formula URL field.  I assume that one Client has Many Auto's

    var txt EditClient = URLRoot() & "db/ & [_DBID_CLIENTES] & "?a=er&rid=" & [Related Client];

    var text DisplayAuto=URLRoot() & "db/ & dbid() & "?a=er&rid=" & [Record ID#];

    $EditClient
    & "&NextURL=" & URLEncode( $DisplayAuto)


    // if this does not work please post your formula and the error message.


    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------