Automation/Bot - No Longer Able To Create Template?

[mykrobinson]

In the past, i have crafted automations to create reports on a schedule, and they have worked well for over a year now. Today I am trying to make a new one with a different table and different schedule, but the option to create the template is now missing. Here is what i see on the new bot i am trying to make:

vs what i see in the old bot:

I also am unable to specify which table i want to work with. Has something changed with how this process works, is something broken, have i done something wrong, or somewhere in between all this?

Lil' help, please.

Thanks

[TeeSee1]

Do you have a table set for this process?

If no table is chosen, then you do not get a create template button.

[mykrobinson]

that's the fun part, i am also unable to select a table. The event is Schedule, and i lose the ability to select a table at that stage, but i am also unable to select one in the task.

[TeeSee1]

Display the process and you get an option to choose a table

[mykrobinson]

what's odd is the process option does not show unless i toggle on this option first:

[mykrobinson]

and now it is giving the same error for the Task. Something is not right, it is not allowing me to set tables on these things as it used to 🤔

Now i need to disable the bot until i can figure this out, because the app will not load as long as i have it enabled

[TeeSee1]

I have run into a similar situation before. I needed to delete the bot and create a new one to erase the error unfortunately. Not sure if it will also work for you.

[Koichi_Tsuji]

With Scheduled event, you need to turn on "For Each Row" option, otherwise AppSheet Automation  is not able to identify for which table you are working on. This is not new, but functionality down there from the begining.

Once you set "For Each Row" option, but you just want to send only SINGLE (One) email, then push the condition, like "Any(TableName[Keycolumn])"

Then Automation is invoked to each row, but only for single one arbitrary record only, resulting in sending one email.

[Koichi_Tsuji]

I agree this is not "intuitive". Hoped Google would make it easy, but no improvement to make the app creators life easier.  As they are keen on Gemini AI stuffs too much, probably. So they could be running out the resources, as far as we see from the fact.

[mykrobinson]

This kinda worked. Let me try to explain.

When i toggle on that option, i am able to select a table, however the filter condition requires a Boolean answer from the expression, so i ended up using ISNOTBLANK(Any(Dialysis Rounding[_recordID]).

That still tried to fire off the process for every one of them, because i can not dumb it down to only one thing when its all said and done. I was able to add all the rest of the automation but AppSheet crashed upon save because it didn't like the expression above despite it passing syntax check.

BUT.... After this, i was able to untoggle the For Every Row parameter and the table i had previously declared stayed with the rest of the automation. After going through this, this is likely what i did with the previous automation that has been working for a report for the past year.

Notice that both of these report generators are listed under Other instead of being tied to an actual table, but it seems there is literally no way to select a table for automations if you first choose Schedule for the event. I need for someone to confirm this behaviour or prove me wrong. 

I think i may make a clean new app to see if the behaviour is repeatable, as there may be something in this app that is contributing to the issue somehow 🤔
But even in saying this, it kind of doesn't make sense that appsheet would NOT allow you to select a table for a scheduled automation, regardless of whatever else may be going on in the app in question.

[mykrobinson]

confirmed the same behavior in a brand new app using a default Appsheet database:

[TeeSee1]

I got a similar behavior except for one little difference.

Yes, enabling ForEachRowInTable lets me create a template and after I create a template and disable it, I have no issues. What is weird in my case is though the bot is listed under Others, I continue to see the table selected in the initial event config in the step setting. But the bot is not executing for each of the row and the result is OK.

I have struggled with this new bot cofig UI, especially with scheduled events, and really have just been doing trial and error to get it right.

Hope someone writes up a definitive configuration guide here..

[Koichi_Tsuji]

My previous comment was not clear and comprehensive. The filter condition after turning on "For Each Row" option, the expression should be something like : -

Any(Dialysis Rounding[_recordID]=[_recordID]