Forum Discussion

frnmj's avatar
Qrew Member
3 years ago

What's the correct syntax for custom API_GenAddRecordForm?

Please bare with me as I am completely new to this.

I currently have 2 tables connected
Parent: Loan

Child: Payments

I created a custom form in the Payments table which has the id of 10.

I added an "Add Payment" field to the parent table and this is the formula of the field:
URLRoot() & "db/" & [_DBID_PAYMENTS] & "?a=API_GenAddRecordForm&dfid=10" & ([Record ID#])

The problem is it takes me to the default add form of the Payments table instead of the custom form I made. Can anyone help me with the correct URL formula and pass the data of the selected Loan record to the custom form?

Manuel Jeus Fernandez

2 Replies

  • URLRoot() & "db/" & [_DBID_PAYMENTS] & "?a=API_GenAddRecordForm&dfid=10&_fid_99=" & [Record ID#]

    Replace the 99 with the field ID if the field for Related Parent

    Mark Shnier (YQC)
  • I understand your question differently. If you are just looking to add using a custom form, it's this part '&dfid=10'. When you look at your forms, get the form ID for your custom form and replace the 10.

    Thanks to Mark on this thread for teaching me that.

    Mike Tamoush