About haskellf

haskellf · 02-26-2022

What would be the best practice to automatically add a new row in one table when a new row has been created in another table.For example,Lets say I have a new entry created for "Start Time" in Invoicing_Table. I want to create an action where any new...

haskellf · 02-25-2022

I have the following data that is automatically entered into a google spreadshet:EventCreateDateLocationFrom the "CreateData" data, AppSheet uses an expression to calculate the time into column "TimeT".However, when I sync, the AppSheet expression da...

haskellf · 02-22-2022

I want to create a slice that will be used to display column data based on two criteria from the following data:If I create a Slice using this data and expression, it works to display the start data column:1) [extractTime] = [Start]If I create a Slic...

haskellf · 02-20-2022

I have a google sheet with data that contains users logging into an account based on time and date.The sheet looks like this:CreateDate | Location | Date | TimeI am looking to create a virtual column called "StartTime" which will search the "Time" co...

haskellf · 02-27-2022

I have read that before but I am having a hard time understanding that workflow. I do agree that this would be relevant to my situation but its the implementation that I can't figure out and need a jump start.I created an action called "PostMessage" ...

haskellf · 02-22-2022

Yes. OR() works! Thanks!My logic was that if it is true for both [extractTime] = [Start], AND [extractTime] = [END], then I would use an AND(). However, it appears I need to use the OR() instead.

haskellf · 02-22-2022

I am looking to use this expression in a new VC column to determine the Start Time. A second VC will determine the End Time based on another range using Max. Finally, I will then minus Start Time from End time to get the duration of hours that they w...

haskellf · 02-21-2022

Specifically, I have a Ring camera in front of my jobsite gate. I am using IFTTT automation to create a new google sheet row each time the gate camera sees a motion. 99% of the motions are from the contractor. Therefore, the first motion entry of the...

haskellf · 02-21-2022

Thanks, this works great!Is there a way I can combine both the min and max expressions within a single expression? I tried using:AND(AND([Start Time]>="07:00:00", [Start Time]<="09:00:00"), MIN(SELECT(StartTimeRange[Start Time], ,[Date]=[_THISROW].[D...

My Stats

haskellf's Bio

Badges haskellf Earned

Recent Activity

Automatically add a new row to a Table when a new row is created in another Table

How to execute a column expression automatically, from gSheet data?

Slice to be used to display columns based on two criteria

Search first entry and last entry based on time range and date

Re: Automatically add a new row to a Table when a new row is created in another Table

Re: Slice to be used to display columns based on two criteria

Re: Search first entry and last entry based on time range and date

Re: Search first entry and last entry based on time range and date

Re: Search first entry and last entry based on time range and date