Forum Discussion

frnmj's avatar
frnmj
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
------------------------------
APIs and custom code
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    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)
    mark.shnier@gmail.com
    ------------------------------
  • MikeTamoush's avatar
    MikeTamoush
    Qrew Commander
    3 years ago
    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
    ------------------------------