Save for later and send PDF when fully complete.

[AndrewHa]

Is it possible (in table form), to save a entry for later without having the bot send a PDF email? With the inspections we do, we need this ability to come back and edit later. We don't want 2-3 emails with differing PDF's. I don't know if this is possible on appsheet. 

[Marc_Dillon]

Sure, set up the bot's event condition to only fire on a certain value in a certain column, and don't set that value until you're ready for the bot to fire.

[AndrewHa]

So for example, if we need to wait 2-3 days to add a specification pressure, until that specification pressure is added, it won't fire the bot? How do you do this. 

[AndrewHa]

For example, a PSV inspection sheet. They need to refill the "replacement PSV" part of the sheet later. Is it possible to program it so if these specific entries are filled out, then the bot triggers. If they aren't filled in, the PDF won't be sent. This would be about 3 columns that would need to be filled out to trigger the bot. 

Or, is it possible to send a PDF ONLY if all the entries are filled out? If 7/10 entries aren't filled out, it won't send for example. 

[AleksiAlkio]

Or.. create an action button user can press when everything is completed. You can for example write the value as NOW() so it triggers the bot everytime when it's pressed. Sometimes it's difficult to "calculate" if everything is ready or not.

[AndrewHa]

How would create the action item? Is this possible in table format? Would it be added where cancel/save is located? 

[AndrewHa]

Do you have any examples of this so I can reference? 

[Marc_Dillon]

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials

https://help.appsheet.com/en/articles/953637-actions-the-essentials

https://www.appsheet.com/SampleApps

[AleksiAlkio]

For example like this.. 

[AndrewHa]

Is there a way to make it so that only if ALL the entries are filled out, the PDF bot is triggered? For example, if 7/10 entries are filled out, it doesn't send an email.

[AleksiAlkio]

Sure, you would need to check with the formula that all fields are filled.. and wrap them with AND().

[AndrewHa]

Can you give an example of how to do this formula? I'm not good with the formulas. 

[AleksiAlkio]

There are many ways and it depends what column types you have. But for example.. AND(ISNOTBLANK([Col#1]),ISNOTBLANK([Col#2]),...) But if you use this kind of formula, it will trigger the Bot every time when all fields are filled, but someone modifies one of them.

[AndrewHa]

If im using a enum type, is the code the same? 

[AleksiAlkio]

Yes you can use the same