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.
Thought this would be an easy thing to accomplish. It works in other
Apps but not in this one.1 action calling 2 further actions.1st
Action:2nd:Target (which works fine): IF(LOOKUP(USEREMAIL(), User
Administration, Email, Daily ReSync)
I'm trying to create a slice which will count the number of items in
another table where the following conditions apply:Primary table: VRN
TableFields: VRNContains 12 VehiclesSecondary Table: Vehicle
ChecksFields: VRN & DatetimeOnly 8 Vehicles have h...
I am trying to check if some items are chosen from an EnumList and make
the choices valid if.....So invalid if it contains either of these 2
selections:NOT(AND(CONTAINS([Gate Check Results], "*Central Padlock*
Good Working Order"),CONTAINS([Gate Chec...
I have a menu action. When that action is run, it will record the
datetime that the user initiated that action. I don't want to be able to
run that action again if it was within 10 minutes of it being run. Here
is what I am using:NOW()-LOOKUP(USEREMA...
Hi All, I am trying to recall a data item in the App Script. Here is
what I have: var timeZone = Session.getScriptTimeZone();var Data = {Id:
Id}const payload = JSON.stringify({ text: "Site Manager - DMS Services -
Please Re-Synchronise - TEST POST - ...
ok, got it. So what I have done is to utilise time and allow a 8 hour
window. Time recording is first. second is an action that
re-synchronises and selects the view if NOW() > that recorded datetime +
8 hours. A third action to simple run the View. I...
Thank you for your reply, Adding a counter isn't what I am wanting to
do. I simply want to know if a person has re-syncrhonised today. If not,
re-synchronise and add todays date. If they have, don't add todays date
and give them the view they have as...
It's ok, I found another solution. I added a Day and Night count in the
VRN Data. So it would cross reference it against the checks being done
for that day:COUNT(select(Vehicle Check Data[Unique ID], AND([Vehicle
Registration
Number:]=[_ThisRow].[VRN...
Hi Suv, Apologies for the late reply, I have been away. Yes that works
perfectly. I made the mistake in not checking the spaces between the
text. It does work perfectly so thank you.
To be honest Jonathan, all my images have been setup using Appsheet's
image import facility. So all my images for menu etc are contained
within it's own data. So using a UX form, I simply import those images
and re-use them when I require them. It do...