Single record with a SubForm in AppSheet

[eladb80]

Hello Everyone,

I’m trying to build a form based on 1:1 relationship.

is there a way that the second table fileds will integerate to the form as a continuos form/subform and not in a “related redords” that need to press “add” or “view”?

Thank You

[Jose_Arteaga]

Hello @eladb80,

Thanks for reaching out! If I understand correctly, you want some fields from a second table to display in a form, is that correct?

Unfortunately, AppSheet does not have a native “spreadsheet-style” grid entry inside a form. There are however, two common ways to achieve a “continuous” feel that avoids the constant pop-up windows.

You can configure the child form (the line items) so that as soon as the user hits “Save” on one item, it immediately reopens a fresh blank item until they are done.

How to do it:

• Go to UX >> Views and find the Form view for your child table and look for “Auto-reopen” in the View Options and turn it on.

• Once the user clicks “Add” once. They fill the row, hit Save, and a new blank row instantly appears. They only hit “Cancel” or “Back” when the entire order is finished.

Let me know if this helps!

[AleksiAlkio]

It sounds you need to use LINKTOFORM() deep link that is opened automatically when the 1. form is closed. Then you can copy the ID column so it would be the same. It doesn’t need reference, it’s just another record in another table but with the same key value

[Syamsudin]

Hi @eladb80

Do you mean like this?
If you click on the image (gallery view), it will automatically fill in the form for that product type.

Create action (do this : APP go to another view with in this app) fill in the target link with the formula :

LINKTOform(“your form”,“Product Name”,[Product_name])

Then link the action to your gallery view. See behavior then select Row selected select the action, for example: new order