This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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...
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...
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...
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" ...
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.
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...
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...
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...
