Auto-Reopen

[Dave_Willett]

With Auto-Reopen set to ON, when the form reopens the most important field [JobID] is blank, how can I set Auto-Reopen to retain the [JobID so it doesn’t need to be re populated manually?

Cheers

[WillowMobileSys]

Dave_Willett:

With Auto-Reopen set to ON, when the form reopens the most important field [JobID] is blank

How are you opening the initial Form? Are you using an action to navigate to it or are you using a Child inline table and tapping the Add button?

[Dave_Willett]

For a new record I use the default system Add, the user enteres the JobID as the first record. The user then uses the default Save which then the form re-opens and JobID is then blank.

[Marc_Dillon]

Instead of auto-reopen, use a LINKTOFORM Action on Form Save.

[Dave_Willett]

Hi John

I have an Action called “Add Item” with the following:

LINKTOFORM(“Ticksheet_Form”, “Ref”, [JobID],“JobID”,[JobID])

---

And on the Form:

And when I save that record:

Still not populated unless I save the record and … then … use the Action which is displayed prominently.

[WillowMobileSys]

Dave_Willett:

LINKTOFORM(“Ticksheet_Form”, “Ref”, [JobID],“JobID”,[JobID])

What is “Ref”? Try it this way instead:

LINKTOFORM(“Ticksheet_Form”, “JobID”, [_THISROW].[JobID] )

Also, I did setup a test of a Parent/Child, and set the Child Form to Auo-Reopen. It works as expected reopening Child Forms and automatically populating the Parent ID.

[Dave_Willett]

Still the same result John.
Just to add this isn’t a child form. Everything is on the same form and it is one table.

[WillowMobileSys]

Dave_Willett:

Just to add this isn’t a child form. Everything is on the same form and it is one table.

Understood. I just wanted to highlight it in case it was a possibility.

---

I have tested with a Form, table and action. Here is what I found:

1. If I simply turn on “Auto-Reopen” and then open a Form using the system Add, it will re-open the Form but will not carry the data values forward to next opening. I think this is as expected.

2. If apply @Marc_Dillon s approach - create an action with LINKTOFORM() and then attach to Form Save with Auto-Reopen off - The Form does re-open AND values are re-assigned upon opening. See images.

Action

LINKTOFORM("Category Options_Form", "Category", [Category])

NOTE: I did not need the [_THISROW] specifier.

Initial View - Note no Category K rows

Click Add button to get empty Form

Add Details

Click Save - Form relaunches with Category pre-filled

Back to Table view after adding a couple of Option rows for Category K

[Dave_Willett]

LINKTOFORM(“Ticksheet_Form”, “JobID”, [JobID])

This seems to do the trick John.

Thanks for your assistance.

[WillowMobileSys]

Dave_Willett:

This seems to do the trick John.

LOL! I just edited the post and added a NOTE that I did not need to use the [_THISROW]. AppSheet is a little finicky about when it’s needed and when its not.

[Dave_Willett]

We got there in the end John

[Riki80]

Hi, I made something similar.  It works but I would like to land in the "Option" field after having saved, I'm using auto-save and I want to scan multiple barcodes ("Option") in the same bin ("Category"). Any idea how I can do this?

Already tried to invert the order but auto-save doesn't work even if they are both filled.