Iโd like to calculate the age by month and I use the App formula, Itโs work. But my problem is I have to click Edit the data first then the age will updated. The App Formula is not run if Iโm not do something with that data.
Iโd like to see the updated age on screen with no any action with app and I could not click Edit every month all data. Would you please give me any advise? Thanks.
Please use a virtual column for these types of live calculations
Thank you @Grant_Stead
Iโd like to reopen this topic
Iโm using the following app formula in a VC to calculate the current age:
FLOOR((HOUR(TODAY()-[Date Of Birth:]))/(365.24*24.0))
The calculation works, however it doesnโt automatically update unless I edit the entry. I thought having this formula in a VC would force the app to recalculate the age with every sync.
Can somebody please tell me what Iโm doing wrong?
That it doesnโt recalculate on each sync but does when the entry is edited suggests it isnโt a virtual column, but rather a normal column with an app formula. Youโll need to replace the normal column with a virtual column to recalculate at each sync.
Trust me, itโs a virtual column. See image below:
And all your other virtual columns update properly on sync?
None of the age virtual column update properly after sync. All other virtual columns update as they should.
That isโฆunexpected! Iโm at a loss. Perhaps @Aleksi has an idea?
@Guillermo_Perez What is your account ID number and app/table name if I check it directly?
Maybe you have all considered this, but just in case; is your expression listed under auto compute App formula or Initial Value?
@Guillermo_Perez I checked your app and all calculations are correct for column โAgeโ. Are you able to add one temporarely fake record so I could change the date and see what happens then?
@Aleksi please look at TEST CONTACT.
This contact is now showing the correct age. I started out with the date 4/27/1965. This correctly calculates the age of 54. I then tried to update the date in the spreadsheet to 4/27/1966 to see what would happen after a sync. It correctly updated to 53.
Iโm at a loss because one of my real contactโs date of birth is 4/27/1965 and a few days ago this should have automatically updated to 54, but it still remains at 53 unless I edit the entry. Please see the detail view and the form view below:
@Riki_Armstrong to answer your question, I placed the formula in App formula.
Iโm wondering if this could somehow have something to do with the fact that I created a slice of this table to rearrange the columns as I saw fit. Although, this would be weird because i made sure that the slice allowed for adds, updates and deletes.
@Guillermo_Perez It would help to find out the reason if your app could be in that stage where the age is wrong after syncing. When you see that behavior, donโt open and save that record so it wonโt change anything. When your app is in that stage, send an email to support@appsheet.com with details and we will debug the reason. For now itโs difficult because your app is not in that stage.
I have created another test contact with date of birth 5/7/2018. If tomorrow the age in the detailed view does not automatically change to 1, I will send an email to support.
Thanks for your help.
Thanks
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |