About JDuval_100

JDuval_100 · 02-07-2024

I have an app that has about 30 different sites each site has a floor plan and a number of inspection points and a bunch of inspections.when i use the app in mobile/tablet the map works perfectly. When I use the app in desktop the map loads just fine...

JDuval_100 · 02-13-2024

I heard back from support, and they said that there currently isn't a way to get this functionality working correctly in the new desktop mode. Thank you for taking the time to help me with this!

JDuval_100 · 02-09-2024

Thank you for taking the time to troubleshoot this with me. I will reach out to support and see if there is anything to be done.

JDuval_100 · 02-09-2024

I see. You might be able to use WEEKDAY() for the day number from a Date. Sunday is 1, Saturday is 7.you can look here for more information on date calculations.https://support.google.com/appsheet/answer/10107326

JDuval_100 · 02-09-2024

Could you use the Day() and Month() functions?I haven't tested this if it would give you the wright functionality , but something likeif(AND(NOT(MONTH([NOW()]) = MONTH([PreviouseDateTime])),Day([NOW()]) = (Day([PreviousDateTime]))), (Show true value)...

JDuval_100 · 02-09-2024

You can copy the data from the ID column and "Paste as special"->"value only" to preserver the current ID values. To use the current spreadsheet as input, I am not sure. You might have to have a separate table that isnt used by appsheet to copy over ...

My Stats

Paras_tomar07's Bio

Badges JDuval_100 Earned

Recent Activity

XY map view is reseting to the first row on clicking only on desktop view

Re: XY map view is reseting to the first row on clicking only on desktop view

Re: XY map view is reseting to the first row on clicking only on desktop view

Re: Expression to get the datetime of the same day of the week as a given datetime next month

Re: Expression to get the datetime of the same day of the week as a given datetime next month

Re: manually generated uniqueid() - app sheet not allowing to be a key