Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Add a new record but stay on the same same form

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 s...
Errors
Formulas and functions
Relationships
EstherGrandal_D's avatar
EstherGrandal_D
Qrew Cadet
8 years ago
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.
EstherGrandal_D's avatar
EstherGrandal_D
Qrew Cadet
8 years ago
This is suppose to be a "formula URL" field you select the option to display it in a button , every time you click the button you create a new record in the other table.

you can take this out ;  & "&z=" & Rurl()

(check that the field 345 is the related field. It looks like you have a lot of fields)