Select specific form view when adding child record

[muketaz]

Hi everyone!

Is there a way to decide wich form view is open when trying to add a child record?

I have a few forms for that child table based on slices and I want to open a specific one from a form, is that possible?

Thanks in advance!

[Rene_Casana]

Yes it's possible

The way this works is by displaying to the user a different "Add" action depending on the View that the user is in this actions will lead you to a specific Form View within your app.

Todo that, you need to include as many "Add" actions as different forms you have. And then for each action select "Go to another view within this app" and then enter indicate the form you're directing the user to with this formula: LINKTOFORM("firstform", "Your app name") check more about the usage of this formula here: https://support.google.com/appsheet/answer/10106538?hl=en

Now that you added the actions you'll end up with duplicated "Add" actions to hide them and only show them in the view that you want you'll go to the property Display>ShowIf and code this formula IN(CONTEXT("ViewName")) this way you're indicating Appsheet that this action will only be displayed in the view you specified, read more about the usage of IN() and CONTEXT() here: https://support.google.com/appsheet/answer/10107885

Depending on how your app is structured, there's also another way in wich won't be necessary to add more actions just a single one, and everything can be coded in this single action that automatically takes the user to the form you want depending on the View that is showing, for that you should code something like this:

IF(IN(COTEXT("View1")), LINKTOFORM("FormView1"), IF( IN(CONTEXT("View2")), LINKTOFORM ("FormView2"), LINKTOFORM("FormView3")))

I hope it helps, if you're still struggling, let me know if you'd like me to explain in a zoom call or something.

[muketaz]

Translator

Hi @Rene_Casana, thank you for the answer. I understand your suggestion but I cant find the way to make the add button, that I generated, display in the form.

I was able to hide the system generated add button, but not able to show the one I want to appear. 

[muketaz]

@Rene_Casana Is it possible that only action types marked with “(not a row-level action)” can be displayed as an overlay on deck/gallery/table views?

[Steve]

CONTEXT() - AppSheet Help