About gjlook

gjlook · 11-01-2023

HelloI am trying to create a Bot to remove records from a calendar table where the calendar start date is before now() and the status is open.I can't find the right combination. The only one that works is a scheduled bot that deletes records based on...

gjlook · 10-30-2023

HelloIs there anyway to stop the Appsheet editor from opening the learning centre when it first launches? I find it useful to jump straight to a specific view or table (via a saved link), but every time I launch the editor, it flips over to the learn...

gjlook · 05-31-2023

HelloIs it possible to create a Google Calendar entry from a custom appsheet appointment entry? eg. a form with an appointments start and end date ? I have already setup a sync between AppSheets and Google Calendar, which works fine. However i am res...

gjlook · 01-12-2023

HelloWhen I change a column title, whether its within the linked google sheet source and then using regenerate structure, or by editing the title of a virtual column, I discover that I must manually re-insert the updated title to the majority of my U...

User defined date range in a list view · 01-08-2023

Hello I have a list of deliveries and i would like a user to be able to define the date range when they run the report .I am looking for a fairly simple from and to dates user input . Can this be embedded in the report view ? Many thanks George

gjlook · 11-02-2023

HelloThanks for coming back.I've looked into this, including deploying my app temporarily, and I have found the following:Scheduled bots only work if you are on a paid plan. You can deploy your app on a free plan, but the scheduled bot feature won't ...

gjlook · 11-01-2023

Hi , Thanks for coming back It seems to append &linkFrom=CopyApp#Home to my url Eg . my original url with your ‘&quickStart=False’ suggestion https://www.appsheet.com/Template/AppDef?appName=myappname&appId=myappid&quickStart=False&linkFrom=CopyApp#U...

gjlook · 06-11-2023

Thanks for replying with the link . I think ive found what i was looking for ( see below ) Thanks for the support link

gjlook · 06-11-2023

Hi thanks for getting back I was creating a data slice for the google calendar table for another purpose and noticed the Creator column in there . So I set the initial value of the 'Creator' column within the Google Calendar Data Table with an email ...

gjlook · 06-10-2023

Hi The 'Data: add a new row to another table' action suggestion works good. Google calendar updates when you click on a customised Action button within appsheets I tried to replicate this within a Bot that runs whenever my appsheet appointment reache...

My Stats

gjlook's Bio

Badges gjlook Earned

Recent Activity

Create an appsheet Bot to remove records in a table based on a date range

Prevent the appsheet editor launching in learning center

Create a google calendar entry from an appsheet custom appointment form

Changing Column title leads to manually editing UX view definitions

User defined date range in a list view

Re: Create an appsheet Bot to remove records in a table based on a date range

Re: Prevent the appsheet editor launching in learning center

Re: Create a google calendar entry from an appsheet custom appointment form

Re: Create a google calendar entry from an appsheet custom appointment form

Re: Create a google calendar entry from an appsheet custom appointment form

gjlook's Ideas (1)