Have a button to go to another table from a table

AppSheet AppSheet Q&A
1

So I’m working on an application that allows you to:

  • create a malfunction reporting form
  • note, via an audit, the arrangement of the factory. I therefore note several themes as compliant / non-compliant such as the storage of brooms, the storage of products…

I would like, on the audit page, to be able to press a button to create a new malfunction form for each of the noted themes.

Can you help me?

2

Sounds like you need to use - https://help.appsheet.com/en/articles/2357261-linktoform

Feel free to DM me if you get stuck

Simon@1minManager.com

1 Like
3

Thanks

but where can we enter the formula LINKTOFORM? Can we create a button and associate the formula to it?

4

So you’d create an Action button with a type of “Go to another view in this App” and use LinkToForm()

1 Like
5

Thanks, J’ai réussi à créer le bouton qui est en lien avec le form.
I managed to create the button which is linked to the form.
This button is automatically positioned in the edit view.

ELacroix1_0-1651581667060.png
ELacroix1_0-1651581667060.png364×640 18.3 KB

ELacroix1_1-1651581692683.png
ELacroix1_1-1651581692683.png365×636 26.3 KB

I would like the button to be positioned on another form (next to the date field for example)

ELacroix1_2-1651581744173.png
ELacroix1_2-1651581744173.png376×640 19 KB

ELacroix1_3-1651581764672.png
ELacroix1_3-1651581764672.png368×644 15.8 KB

Is it possible?

6

So you need to change it from Prominantly to Inline then select a column. You’ll need to set that column as the first column in that view. But note that the view won’t show this column, only the action button

7

Actions (buttons) cannot be placed in form views.

8

Thanks but I think it is not possible to create an action button in a form view.

Can we circumvent this impossibility?

9

Whats the use case for an action button in a form view?

10

The form I want to put an action button on is an audit form.
I answer compliant/non-compliant to several items.

When I answer “non-compliant”, I would like to link to another “anomalies” form which exists for any type of anomaly reporting (not only audits)

11

So they way you want it to work, it can’t do. As I see it you have 2 options:

  • I’ve done something similar for a fire safety guy. So what we’ve done with him is this . His parent table is the Job. The subtable is defects, which is similar to your anomalies. So he goes through a list of defects he has to check for. For each defect he either marks it off as fine or not fine. If its not fine the defect form has a big list of stuff he can enter. The issue with this way is making sure you have put an answer in for everything you’re suposed to check for
  • The other way of doing it would be to complete your audit form. Then after saving that seperately create each anomaly. Issue with this option is their is no way of forcing the user to enter an anomaly.

Hope this helps. Not a shameless plug, but if you want some help doing this, I’m an Appsheet developer and do this for a living. So if you just need someone to jump in and fix this in 30mins let me know :slightly_smiling_face:

Simon@1minManager.com

1 Like