Discussions

Expand all | Collapse all

pass field values to an add new record form

  • 1.  pass field values to an add new record form

    Posted 12-14-2017 22:18

    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?



  • 2.  RE: pass field values to an add new record form

    Top
    Contributor
    Posted 12-14-2017 22:49
    Is the Related Loan Application field a numeric field or a text field?


  • 3.  RE: pass field values to an add new record form

    Posted 12-14-2017 23:23
    Yes. It is numerical field.


  • 4.  RE: pass field values to an add new record form

    Posted 12-14-2017 23:28
    On the record that you were launching the button from, what value is in that field?


  • 5.  RE: pass field values to an add new record form

    Posted 12-15-2017 14:05
    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 different types to that field: read-only , and editable. In this case, 125 is the READ-ONLY type and 122 is EDITABLE type. Is that correct?


  • 6.  RE: pass field values to an add new record form

    Posted 12-15-2017 14:11
    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.


  • 7.  RE: pass field values to an add new record form

    Posted 12-15-2017 14:34
    OK, so in my case fid 125 is actually a Lookup field ID but fid 122 is the Reference field ID. Is that ture?


  • 8.  RE: pass field values to an add new record form

    Posted 12-15-2017 14:37
    So, yes,  you need to update fid 122 then.