I have a linktoform action that is linking to...

[Lindsey_Allen]

I have a linktoform action that is linking to the slice. My original table that the slice is from has a ref that is not carrying over to my slice. Can anyone help?

[RezaRaoofi]

Have you checked the Slice and the Ref column is already on the list of selected columns in slice?

Can you clarify what you mean by the Ref column not carrying over?

[Lindsey_Allen]

Yes that column is added.

I have a Table 1 with a customer number column that references to Table 2 which is an accounts table. I have 2 slices from Table 1. The fist slice is to record when an employee starts a job and the second records when the job finishes. I am trying to allow the user to start their job by choosing an account from Table 2 and having it link to my Start Job slice.

I tried to do this using a link to form action. When I click on the action button the customer number from the account I selected is not populating.

[RezaRaoofi]

You referred to 3 identities in your above comment; Accounts, Job, and Customer; I want to make sure I have understood the relationship(s) between them; do you mean Jobs table has a Ref column to Accounts table, and you want to add a new job for the selected account row?

Regardless, if you use LINKTOFORM(…) function to add a new child row to a selected parent row, it does not automatically enter a value in Ref column, unless you specify pre-fill value in the LINKTOFORM(…) function; see this document for details: https://intercom.help/appsheet/expressions/functions/linktoform

[Lindsey_Allen]

Yes. that is what i am trying to do

[RezaRaoofi]

I edited my above comment in few minutes, and added a second paragraph about LINKTOFORM() did you read that too?

I think if the LINKTOFORM(…) is triggered in a selected Account row, you could pre-fill that Ref column in Jobs table with an expression similar to this: LINKTOFORM(“JobsFormView”, “Job_AccountRef”,[_THISROW].[AccountID])

That should prefill [Job_AccountRef] column in Jobs table with the existing value of [AccountID] in selected row in Accounts table.

[eco_lbo]

Hi
Is there any example for using LINKTOFORM?
Thanks

[Lynn]

Hi @eco_lbo Did you check these docs?
https://help.appsheet.com/en/?q=LINKTOFORM

[eco_lbo]

Yes.
unfortunately, I haven’t find the right answer.
I want to make a form for an order, that will contain a list of products (relation between tables “products” + “orders”+ “customers”) so the user can see it as a list, choose quantity and add it to the “cart” (the order).
I have seen the solution in the sample app “Order Capture”, though it is very not friendly user (e.g. when the user want to choose a product he needs to open a drop down list , whereas my wish is to show him an image+other details in a list).
I wrote about it here as well - List of items in a form
Hope that I was clear
Thanks!