What is the best app formula to calculate number of days past since new row was added?
How about NOW() - MAX(TableName[DateTime])
Thanks for the insight.
Looks like Iโm closerโฆ The spreadsheet displays decimal days, which is fine.
The app displays what appears to be hours:min:sec.
-neither the spreadsheet or the app update as the duration extends. How to get current days displayed in app? -how do I force the app to display days rather than time?
Iโm new to the MAX function.
Looks like used to determine highest value in an array.
Just to be clear, I am attempting to display the duration of days for each individual row.
With this in mind, does the MAX function still apply?
Need to display the elapsed time between when the row was created and NOW.
Thanks for your time!
Ok making more progress with one more snagโฆ =HOUR(NOW() - [Date])//24 + MINUTE(NOW()-[Date])/1440.00
Minimized your formula and the โtime durationโ is changing as it should be BUT only in the slice view _Form of my app.
Not sure why the slice view _Detail โtime durationโ is locked along with the slice view _Table.
Any suggestion on why the different view types donโt display the correct โtime durationโ?
Also, note that after sync the app the excel spreadsheet located in BOX is not updating either.
Thanks!
Okayโฆ I misunderstood your request slightly. I thought you want to compare between the last record of your table and now.
When you want to show it dynamically, you need to use it with the virtual column. If you want to calculate with date only, you could write it likeโฆ HOUR(TODAY() - [Date])/24
Sorry about the confusion.
The โtime durationโ displayed in view _Form worked perfectly over night!!
Donโt think the formula needs to change.
Not sure what to do so that the โtime durationโ is properly displayed in view _Detail and view _Table and also the source spreadsheet???
These still show the โtime durationโ at something other than actual โtime durationโ
I can check the app if you want. I need account ID number and app name.
Nobody else canโt open the app with the ID and app name. And yes I work for Appsheet
Hi.
Is it ok to post this publicly?
It doesnโt matter but you can send the information to support@appsheet.com. I can read it from there.
Thanks.
Our app isnโt much special.
Regarding security/privacy, are you saying only Appsheet can do anything with the account number and app name?
HOUR(NOW() - MAX(TableName[DateTime]))/24.0+MINUTE(NOW() - MAX(TableName[DateTime]))/1440.0
Thatโs correct
ID: 52b7e437-94bd-47ad-8f9e-e83fce1c1c10
App Name: HookRate08-596778
The ID is the 596778
Need anything else from me? What is the long code that I thought was the ID?
Not sure why the URL included โHookRate08โ.
I thought I named the app โHook Rate Developmentโ.
The HookRate08 is a shorter version of the name you saved it for the first time. It was probably like Hook Rate 08. The long code is for the URL.
The reason is simple. The calculation is happening in a normal column and it will update the value only, when you open and save the record. Thatโs why it wonโt update the duration in your Excel file. When you want to show it dynamically in the app, you should use virtual column but please remember you canโt save that value into your Excel file.
Thanks!
Sounds like adding a virtual column will fix the app displaying the current duration but the only option to update duration in the source spreadsheet is to drill down into ea customer and manually save it? โ We will need the current/accurate duration to be displayed in ea slice view _Table.
This way we know duration without drilling down into the customer.
Will a single virtual column resolve this requirement?
If so, any special virtual column setup requirements I should know about?
I ask because Iโm new to Appsheet and virtual columns.
โ Thanks again!!
Wow!
Looks like it will work.
What โTYPEโ settingโฆDuration, DateTime, Decimal? Having some conflict
Just add that existing formula into one virtual column and check from the slice itโs there as well.
Time duration is now dynamically displayed perfectly!!!
Thanks.
Now that it is dynamic via slices what is best suggestion to keep the spreadsheet current with the duration?
Iโm assuming add the spreadsheet column to the slice and check hidden?
This way I have two durations; one to keep the spreadsheet current and one for the user.
Seems like there must be a smarter way to do this.
Thanks
FYI.
Appsheet tells me type of the app formula โdecimalโ does not match the column type โdurationโ.
I tried changing from duration to decimal but no luck.
It should be decimal.
No more errors after I tried decimal type again!
Will this app formula keep the column current as the days go by?
Will it need to be forced refresh, etc?
It calculated 0.1 days immediately.
Im assuming this is a rounded value??
If itโs in a normal column, it will calculate the value only, when you open/save that record. If you add this formula into the virtual column, it will calculate new value every time you sync the app. Yes itโs rounded. You have probably chosed only one decimal?
Thanks again.
The time is stuck at 0.01.
Iโm wondering if my start date column is set up properly.
Is there a format it should be?
The spread sheet resides in BOX.
It consist of one spreadsheet table and a few virtual slice views.
Trying to get the days to appear in the slice views.
Added additional row.
The day counter produced an initial value of 0.19.
Previous row was 0.01.
Must have a format issue?
Since the automatic date and time stamp created by appsheet is the only variable in your formula Iโm thinking there is a format issue with the time and date stamp???
Does this seem likely???
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |