Form view - Save and New Button

[jaichith]

How to create  this Save and New button in form view ?

@AleksiAlkio @Suvrutt_Gurjar @Steve @dbaum @jyothis_m @Kirk_Masden @Rifad @MultiTech 

[Rifad]

It is not possible using appsheet.

[jaichith]

Disappointing. Please let me know if there is an option. 

[MultiTech]

---

@Rifad wrote:

It is not possible using appsheet.

---

This is a very common request, and you can create a solution for this using a combination of features:

1. Add an enum column to serve as a "Nav_Option" button as the last field in your form
   1. Give this the options:  "Save & New" & "Save"
      
      
2. Configure your form to auto-save
3. Add an action stack into the form save event with a couple of conditional actions
   1. Both actions are conditional based on the option selected in Nav_Options
   2. If they select "Save & New" the linkToForm() action kicks off, taking you back to the same form (bringing with it any parent Ref information, increasing sequential counts by one, etc.)
   3. If they select "save" then do something else, like take them to the detail view - or just don't do anything on this and let the default system behavior take over.

With this method you can create a very complex "force form flow", literally leading your users through the forms/views you want with 100% control and accuracy.

------------------------------------------------------------------------------------------------------------

I've got a sample app that demonstrates how to set this up:

• https://www.appsheet.com//templates/How-To-Let-The-User-Pick-Where-To-Go?appGuidString=9b489f9a-9832...

[jaichith]

Thank Mr. Matt, I have a Question . You have used normal column in comments table for Save, Add comment Etc . can I use Virtual column instead of normal column of type Enum . Is it advisable ? 

[MultiTech]

---

@jaichith wrote:

can I use Virtual column instead of normal column

---

No you won't be able to do that, virtual columns don't allow for interaction - it has to be a physical column. 

[Denny774]

Wow, only 3 months for the reply. Amazing 😆

[Mode]

This is amazing tried everything and than I found this.

One thing to note is that it wouldn't work with the system "add items" button, so you will also have to add a enum in the master/parent so it gets saved before adding items/childs

[jaichith]

Good Observation 

[WillowMobileSys]

Actually, there is an AppSheet built in way to do this very easily, just not exactly like the example you show.

Each Form view has an "Auto re-open" setting that when turned on, the Form view will re-open on a Save.   See image.  The down-side is that it is NOT user selectable so the the Form will have to open a second time for the user to Cancel out of the Form and stop the re-opening activity.

If you need the more sophisticated approach, then follow Matt's example

[Mode]

That's right, but as you mentioned the last cancel is what bothers, would have been a great idea for app sheet to have it with an expression like setting, same as "show" option.