Forum Discussion

HillaryWhitney's avatar
HillaryWhitney
Qrew Cadet
7 years ago

url button add record to same table, edit new record, and table report

I can?t seem to wrap my head around this one today, but I?m pretty sure it can be done.   I need to add a URL button. This button will: Change the Billing Status field to Complete ...
APIs and custom code
Ask about Quickbase functionality
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Yes this can be done, but I would suggest refreshing the report do as to prevent the button from being pushed twice. When the report refreshed it would drop the Approved Record off the report.

The basic Syntax would be

var text URLONE = and the the code to edit the record;
var text URLTWO = and the code to add a record;
Var text URLTHREE = and the code to run the report;

$URLONE
& "&rdr=" & URLEncode($URLTWO)
& URLEncode("&rdr=" & URLEncode($URLTHREE)

Do you also need help with the code for the individual formula variables?
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    For this instance, I would recommend a growl button that will allow the user to approve multiple records without navigation. 

    I understand the recommendation to prevent the button from being pushed twice however, so I would add a condition to hide the button when the status equals Complete on the button formula, and include some indication not to press for same record in the growl message. Erroneous data can be deleted.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Well post the code you have and I will help debug it