What is the best app formula to calculate num...

(Tim Meske) #1

What is the best app formula to calculate number of days past since new row was added?

(Aleksi Alkio) #2

How about NOW() - MAX(TableName[DateTime])

(Tim Meske) #3

@Aleksi_Alkio

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?

(Tim Meske) #4

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!

(Tim Meske) #5

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!

(Aleksi Alkio) #6

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

(Tim Meske) #7

@Aleksi_Alkio

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’

(Aleksi Alkio) #8

I can check the app if you want. I need account ID number and app name.

(Tim Meske) #9

@Aleksi_Alkio

Is it common to share this?

Do you work for appsheet?

(Aleksi Alkio) #10

Nobody else can’t open the app with the ID and app name. And yes I work for Appsheet :slight_smile:

(Tim Meske) #11

Hi.

Is it ok to post this publicly?

(Aleksi Alkio) #12

It doesn’t matter but you can send the information to support@appsheet.com. I can read it from there.

(Tim Meske) #13

@Aleksi_Alkio

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?

(Aleksi Alkio) #14

HOUR(NOW() - MAX(TableName[DateTime]))/24.0+MINUTE(NOW() - MAX(TableName[DateTime]))/1440.0

(Aleksi Alkio) #15

That’s correct

(Tim Meske) #16

@Aleksi_Alkio

Thanks.

Where exactly can I find the ID and app name?

(Tim Meske) #17

ID: 52b7e437-94bd-47ad-8f9e-e83fce1c1c10

App Name: HookRate08-596778

(Aleksi Alkio) #18

The ID is the 596778

(Tim Meske) #19

@Aleksi_Alkio

Need anything else from me? What is the long code that I thought was the ID?

(Tim Meske) #20

Not sure why the URL included ‘HookRate08’.

I thought I named the app ‘Hook Rate Development’.