About gcor71

gcor71 · 03-30-2024

Sharing this nugget because I can't find it referenced anywhere in AppSheet Help or this Community and thought it might help someone one day.It appears possible to express duration in days as well as hours, minutes, seconds (the later as shown in doc...

gcor71 · 03-30-2024

I am creating a Bot. I want to include a list of comma separated email address (user defined) in the CC: field. I am trying to achieve this by having an EnumList which the user adds required email addresses to.This assumes that the system will handle...

gcor71 · 03-20-2024

My set-up:1. Google Sheet runs a scheduled script to extract data from an online system, adding new records to the end of the existing table of data. [member_id] is the key.2. Same Google Sheet has Appsheet Events configured and send 'changeBot' trig...

gcor71 · 03-13-2024

What is wrong here please?A: a GROUP action (left side of image) that executes when triggered against a row via the UI. Together, the sub-actions force a refresh of the whole row - causing update behaviour in other columns on the row. This is working...

gcor71 · 03-11-2024

I have trained a model to predict the "scout group" based on an structured input text string. eg: INPUT column NOTE: "Enter ticket holder full name (person attending): John Doe | Enter Group & Section (ie 99th Portsmouth, Cubs): 70th Portsmouth squir...

gcor71 · 03-30-2024

@TeeSee1 , @Suvrutt_Gurjar thank you for the amazingly fast reply.@TeeSee1 , I went with your solution in the end - and it seems so very obvious that it was a "list of lists" now you point it out. I applied ANY() and resolved the problem.

gcor71 · 03-26-2024

I got a solution from support.My first bot adds a new row to a table.My second bot "on data change / add" sends an email, from data in that new row.I got the following error as the second bot fired (and failed).Error: "Key column 'qev_id' is not pres...

gcor71 · 03-21-2024

THanks for the input. I'm going to go back to basics and start from first principles. The error is clearly warning me of something - but, as it seems pretty clear I shouldn't be able to do what I'm trying, I'll give it up as a bad job and move on.Tha...

gcor71 · 03-13-2024

correct - the bot is simply a way to schedule the trigger/update.All calculations are formula within the column/table definitions.

gcor71 · 03-13-2024

Didn't take long. Same result. The timestamp column is nicely updated, but there is no recalculation happening.

My Stats

gcor71's Bio

Badges gcor71 Earned

Recent Activity

Express DURATION values in Days (ie in automation Wait/Pause)

How to use EnumList to create a list of email address (in one column)?

Help understanding "Key column 'member_id' is not present in the Data payload"

Bot Process Actions not executing the same way as the actions triggered via UI

How to use PREDICT in an app?

Re: How to use EnumList to create a list of email address (in one column)?

Re: Help understanding "Key column 'member_id' is not present in the Data payload"

Re: Help understanding "Key column 'member_id' is not present in the Data payload"

Re: Bot Process Actions not executing the same way as the actions triggered via UI

Re: Bot Process Actions not executing the same way as the actions triggered via UI