Pass values to another form

Is it possible to pass values from the new button ? I know about expression LINKTOFORM . But it does not work for me.

I need to pass customer name to the products table form from this form when i click this button. After adding the product i should actually come back to this form automatically to add other details. Is there any workaround to achieve this ?

Unfortunately, there is not a way from within the dropdown Add function to be able to specify values you wish to pre-populated into the Form. It would be nice as I have had a need for that in many places as well.

One work-around is what you have already done, force the Customer to be chosen as a Required field.

Another option is to force a different processing path. Don’t allow product adds from the dropdown of the Estimate Form. Instead force users to go to the Customer record and add products from there.


Yes we can do that but the flow is missed inside the app.

-You start with a new estimate for new product.
-Select the customer name
-Add products form existing products or if its new products we use that add button.
-Since we have already selected the customer name in estimate and we go down to add products the user must select the customer name again that is really not justifiable.

The issue if i remove the add button will be going back to products table in between creating an estimate then come back here and then add estimate. Thats really breaking the flow of the app. I would be really happy if we have any kind of workaround for this. Thanks.

I don’t really know the nature of your app and it’s data and you seem insistant to keeping the current process flow.

The only other workaround I can offer, is to populate the Customer into the Product record silently upon Save of the Estimate row. In this case you would likely not even show Customer on the Product Form at all. Instead, create an action that is called by the Form Save behavior and assigns the Customer.

If this too is inflexible, i.e. you must show Customer on the New Product Form, then I have no alternative suggestion for you. As far as I know, the user would have to enter the Customer a second time.

1 Like

Yes as per nature of my app the flow is forcing me to select customer name second time when we create a product and that sometimes causes error. I tried many different approaches. That never worked for me.
Its also not a good idea to save form and use actions to update row.

Everything is good except for this New/Add Button. This is something really essential we should consider and ask AppSheet for a solution I guess.