About nhcohen

nhcohen · 02-16-2023

My app includes tables named FormResponsesTable and CaseDataTable. The source of FormResponsesTable is a Google Sheets sheet linked to a Google Forms form. I have a bot that is intended to add a row to CaseDataTable when a row is added to FormRespons...

nhcohen · 02-15-2023

I created a new app, and pressed the "Launch automation monitor" button on the "Manage" screen. A monitoring webpage opened in the browser. The "Document Parses" tab of this webpage shows both the new app and an older app in the "Apps" column, but in...

nhcohen · 02-08-2023

I want to add a Google form to an existing AppSheet app. When I invoke the AppSheet add-on in Google Formsand press PREPARE and then LAUNCH, a new browser tab opens up with a new AppSheet app.It appears that the form-submission event is sent to this ...

nhcohen · 12-07-2022

By default, the format in which a date is displayed, and input into forms, is determined by the locale of the user's device. My application will be used in a locale where the dd/mm/yyyy format is in common use, but many of the users will be ex-pat Am...

nhcohen · 11-02-2022

If I understand correctly, when the NOW() function is called by a bot, it returns the same value as UTCNOW(), because the bot is executed on the server and there is no user device to use as the time source. Is this correct?If so, how do I get a bot (...

nhcohen · 02-20-2023

Thank you for replying, but bots can be triggered through Google Forms interactions. The section "Create the data change events in your AppSheet app" of the Appsheet Help page External eventing with Google Sheets states the following:I had an earlier...

nhcohen · 02-20-2023

Thank you for replying. "Intake Form" is the name of the Google Sheets sheet that is the source of the AppSheet table FormResponsesTable:When I submit a form, a row does get added to the sheet, and a corresponding row is added to FormResponsesTable. ...

nhcohen · 02-08-2023

That's not true. I've done it successfully before, as described here.

nhcohen · 02-07-2023

Suppose I have more than 5 primary views. Is there a way to control the order in which the views are listed within each of the "first", "next", "middle", "later", and "last" groups? (The default seems to be to list the views in they order they were c...

nhcohen · 12-07-2022

Unfortunately, this solution does not allow for customization of date input fields.

My Stats

ronakbaps's Bio

Badges nhcohen Earned

Recent Activity

Bot not triggered when Google Forms adds a row to a table

Automation Monitor shows my app in the Document Parses tab, but not the Runs tab

Adding a Google form to an existing app

Application control over date input and output formats

How do I get a bot to set a timestamp in a specified timezone (accounting for daylight saving time)?

Re: Bot not triggered when Google Forms adds a row to a table

Re: Bot not triggered when Google Forms adds a row to a table

Re: Adding a Google form to an existing app

Re: How do I reorder the tabs in the App?

Re: Format Date Locale from NOW()

nhcohen's Ideas (1)