This works to works to create a record and land the user in View mode.URLRoot() & "db/" & [_DBID_SKTDS] & "?act=API_AddRecord"& "&_fid_6=" & URLEncode([Supplier])& "&disprec=1";Is there any way to land the user in edit mode?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

We are currently trying to do the same thing with no success, use a Formula URL field to call API_AddRecord then redirect to Edit mode of the new record. I was hoping to use %%rid%% in the redirect URL but that errors out. The "&disprec=1" does not work either, it sends me to the XML response from the API_AddRecord instead of View mode.Has anyone been able to figure this one out in the couple weeks since this was originally posted?------------------------------Oana Toma------------------------------

I've seen some solution used by someone else where there is a helper table that calcs max RID, then if you add 1 to that it should relay to the newest record if used in a formula URL w/ a=er and RID=Maxrecord+1. Have not tested this, but don't see why it would not work.------------------------------Melissa DoranJr Solutions ConsultantQuandary Consulting Grouplinkedin.com/in/melissardoranmdoran@quandarycg.com------------------------------

what is the &disprec=1 ? Is that new?------------------------------Mike Tamoush------------------------------

What is the error you get with %%rid%%. Ive only used it once I think, but I remember having success? Perhaps I only used it in GenAddRecord.....------------------------------Mike Tamoush------------------------------

&disprec=1 is not new.It's a parameter that basically says when you get done adding the record then display the record equals true. In other words land the user on the record in View mode.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

API_AddRecord and land the user in edit mode.

OanaWhalen
Qrew Cadet
4 years ago
We are currently trying to do the same thing with no success, use a Formula URL field to call API_AddRecord then redirect to Edit mode of the new record. I was hoping to use %%rid%% in the redirect URL but that errors out. The "&disprec=1" does not work either, it sends me to the XML response from the API_AddRecord instead of View mode.

Has anyone been able to figure this one out in the couple weeks since this was originally posted?

------------------------------
Oana Toma
------------------------------
- Melissa_Doran
  Qrew Cadet
  4 years ago
  I've seen some solution used by someone else where there is a helper table that calcs max RID, then if you add 1 to that it should relay to the newest record if used in a formula URL w/ a=er and RID=Maxrecord+1.
  
  Have not tested this, but don't see why it would not work.
  
  ------------------------------
  Melissa Doran
  Jr Solutions Consultant
  Quandary Consulting Group
  
  linkedin.com/in/melissardoran
  mdoran@quandarycg.com
  ------------------------------
- MikeTamoush
  Qrew Commander
  4 years ago
  What is the error you get with %%rid%%. Ive only used it once I think, but I remember having success? Perhaps I only used it in GenAddRecord.....
  
  ------------------------------
  Mike Tamoush
  ------------------------------
MikeTamoush
Qrew Commander
4 years ago
what is the &disprec=1 ? Is that new?

------------------------------
Mike Tamoush
------------------------------
- MarkShnier__You
  Qrew Legend
  4 years ago
  &disprec=1 is not new.
  
  It's a parameter that basically says when you get done adding the record then display the record equals true. In other words land the user on the record in View mode.
  
  ------------------------------
  Mark Shnier (YQC)
  mark.shnier@gmail.com
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    3 years ago
    Just x referencing to a solution.
    
    https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=4466dd0f-403f-4f24-94d8-4ac7128081ae&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm4466dd0f-403f-4f24-94d8-4ac7128081ae
    
    Just posting some code that worked. The goal was to add a record and return the user to the added record in Edit mode.
    
    var text RID = "%%rid%%";
    
    var text AddShipment = URLRoot() & "db/" & Dbid() & "?a=nwr";
    var text EditShipment = URLRoot() & "db/" & Dbid() & "?a=er&rid=" ;
    
    var text URL =
    $AddShipment
    & "&rdr=" & URLEncode($EditShipment) & $RID;
    
    "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='"
    & $URL
    & "'>Save and Display in Edit Mode</a>"
    
    NOTE: The %%RID%% does not seem to like being URLEncoded.
    
    The use case might be to land the user on a saved record so that the Report Link fields would immediately populate.
    
    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

API_AddRecord and land the user in edit mode.