About AdemarN

AdemarN · 08-27-2023

Hi,I'm using Top(Sort(Select())) in the expression below and expecting to retrieve the [Group Level] for last row it finds but it is giving me the first row. What am I missing?TOP(SORT(select(Event Rider Details[Group Level], [_THISROW].[TransponderI...

AdemarN · 02-11-2022

Hello,Any direction on what BOT I can create that would automatically update a specified field with a specified value every five minutes if a condition is true?Thanks.

AdemarN · 01-07-2022

We have a Bot that triggers on Data Change / Adds Only and works great. We’ve enabled the AppSheet Events Add-On for the sheet so that the Bot will trigger when adding the record directly into the Sheet instead of via the App. That is also working gr...

AdemarN · 12-07-2021

I have AppSheet Events Add-On turned on for the sheet. When I create a record directly in Google Sheet, and allow the AppSheet Events Add-On to trigger a bot that sends an email, the Bot does run and does send the email, but doesn’t include results o...

AdemarN · 12-03-2021

When users edit a record in a view, they sometimes mistakenly hit the back arrow on the top left (which then doesn’t save the entry) instead of clicking the Save button on the bottom right. Basic human error. Any suggestions on something I could impl...

AdemarN · 08-27-2023

Ok I think I got it. @SkrOYC let me on to something so I did this...I created a VC on the [Event Rider Details] table that returns a yes/no if the reocord is the Latest Record:[vcLatest Record] = IF(MAXROW("Event Rider Details","Timestamp",([Transpon...

AdemarN · 08-27-2023

Not sure I understand how to use a Virtual Column to sort. Can you elaborate? Also, "List" rather than "Value". Can you suggest a different approach. I just want to return one text value, the one having the latest Timestamp, from a list of many rows....

AdemarN · 08-27-2023

The last row in the table for that condition on [TransponderID] (row highlighted in the screenshot). In the table there's are two entries for TransponderID "00001". I want to to result in the bottom entry. So, I want the field to result in [Group Lev...

AdemarN · 08-27-2023

Tried it. Same result.Thanks,

AdemarN · 02-11-2022

Ok here's what I did. Looks like it works! thanks for all your help @Richard_Fages ! const hour = Utilities.formatDate(today,timezone,"HH") + ":" + today.getMinutes(); const minute = today.getMinutes(); const isGoodHoursRange = hour >= "10:00" && hou...

My Stats

AdemarN's Bio

Badges AdemarN Earned

Recent Activity

Using Sort() Function

BOT to update a field every five minutes if condition is true

Zapier Imports not Triggering Bot

External Eventing Doesn't Print <<Start: Select ()>> Results

Back Arrow without Saving

Re: Using Sort() Function

Re: Using Sort() Function

Re: Using Sort() Function

Re: Using Sort() Function

Re: BOT to update a field every five minutes if condition is true