Populate Ref column on Add

[AI-FL]

I have an Estimate table that includes a Ref column for Job ID (key) from Jobs table. 

To add a new record to the Estimate table, I have an action button on the Job Detail page to open Estimate form.  

When I save the form, a new record is added to the Estimate table but the Job Id column is not populated.  I think I'm making a wrong assumption here...that because the action button is on a particular Job Detail, that the form it is opening is associated with that job.   How can I get the Job ID column populated?

[Marc_Dillon]

Either use LINKTOFORM for your add button, or use the built-in add button that shows up below the inline view.

https://help.appsheet.com/en/articles/2357261-linktoform

[AI-FL]

I am using the LINKTOFORM on action button that appears in Job Detail.  It correctly takes me to Estimate form.  When I save the form, a new record is added to the Estimate table, but the column Job ID is not filled in.

[Marc_Dillon]

That LINKTOFORM expression is not correct.

The first parameter of any pair in the LINKTOFORM identifies which column to fill in. As such, you just use the column name, quoted if there are spaces. The second parameter of the pair is the actual value to put into the identified column, that's where you'd use the square bracket notation to send in the value. Also read this:

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...