Skip to main content
Question

Add a new record but stay on the same same form

  • April 3, 2018
  • 0 replies
  • 49 views
I have two tables.  A Quality Records and a Defect/NCR/ CAR.  When creating a new Quality record, it becomes a Defect/NCR/ CAR.  I want to be able to click the button, create the Defect/NCR/ CAR but stay on the Quality Record.  

Here is the formula:

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_345=" & URLEncode ([Record ID#])& "&z=" & Rurl()
This topic has been closed for replies.

no problem,
Just remove that last part & "&z=" & Rurl()  and you will "stick the landing", just like in gymnastics.

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_345=" & URLEncode ([Record ID#])
Try the "API_AddRecord" instead of "Api_GenAddRecordForm"

URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_AddRecord&_fid_345=" & URLEncode ([Record ID#])& "&z=" & Rurl()


Remember when you use this call, you must add values for all required fields in this other table or API_AddRecord returns an error.

I hope it helps.
Terms & ConditionsAccessibility statement