Forum Discussion

GeorgeBramhall1

Qrew Member

4 years ago

Error in Formula URL ... Need help

I am getting the following error when I click my Formula URl button,Please, what am I doing wrong: <qdbapi> <action>API_EditRecord</action> <errcode>30</errcode> <errtext>No such record<...

Formulas and functions

GeorgeBramhall1

Qrew Member

4 years ago

Hi Mark,
I actually do need to save some other edits before getting redirected. Isn't their a save record before redirecting function?
Thanks
G

------------------------------
George Bramhall
------------------------------

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

4 years ago

If the user is already in add mode just have them check the checkbox manually. But no, there is not an easy way to save the record, capture the rid and execute the URL.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

GeorgeBramhall1
Qrew Member
4 years ago
Most importantly I need to redirect the user to a special page after saving. If the savebeforenavigating functionality won't work here is there any way that can just get redirected to this page after saving? Maybe I can use a form rule to accomplish the checkbox change.

------------------------------
George Bramhall
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  If you just have a button to navigate away from the record, and you have the table Advanced Properties set to save before navigating away, then it should save just with this
  
  URLRoot() & "db/" & AppID() & "?a=Showpage&pageID=18"
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - MichaelTamoush
    Qrew Captain
    4 years ago
    Mark,
    
    Correct me if I am wrong, but I believe the new class="SaveBeforeNavigating" in combination with the new %%rid%% can now grab the new record ID and use it for redirects? I'll have to go back and look for the literature on this, it was in one the past few release notes.
    
    ------------------------------
    Mike Tamoush
    ------------------------------