pass field values to an add new record form

Question

I want to pass a value from a field in one table and click a button here and it'll generate a form to add a new record. In this button, I use the following formular:
URLRoot() & "db/" & "xxxxxxxx?a=API_GenAddRecordForm&apptoken=xxxxxxxxxxxxxxxxxxx"
& "&_fid_125=" & [Related Loan Application]

It redirects me successfully to the form but a field (fid is 125) in which I anticipate the value to be passes will be pre-populated in the new form did not actually doing that. Is there anything I missed?

archiveuser · Answer

Is the Related Loan Application field a numeric field or a text field?

richardwu · Answer

Yes. It is numerical field.

quickbasecoachd · Answer

On the record that you were launching the button from, what value is in that field?

richardwu · Answer

We found that solution. The field id I was using was 125 but we found that it works with the ID of 122 because I heard that there are&nbsp;different types&nbsp;to that field: read-only , and editable. In this case, 125 is the READ-ONLY type and 122 is EDITABLE type. Is that correct?

quickbasecoachd · Answer

Perhaps you were trying to update a lookup field in in the table when in fact you needed to update the reference field for the relationship.  Ie the field at the top right side of the relationship. You cannot update fields which are formula fields or lookup fields.

Forum Discussion

pass field values to an add new record form

Related Content

Jinja Max Value of a Field

Using Grid Edit to Edit Multiple Records at Once

Pipeline to Split Record into More Records Based on Field

Carrying the old value of a field into a webhook

Record Details