My Frist Creator Application
Hello Zoho Community,
I created my first Zoho Creator Application. It consists of a basic form in which I record usage data by date. The form consists of 5 columns
Date - Value1 - Value2 - Value3 - Value4
01-01-2017 - 1000 - 2000 - 3000 - 4000
08-01-2017 - 1100 - 2200 - 3600 - 4050
16-01-2017 - 1201 - 2400 - 3800 - 4100
23-01-2017 - 1308 - 2600 - 3990 - 4150
How can I add a column that calculates the number of day since the last entry?
example
Date - Value1 - Value2 - Value3 - Value4 - #Days
01-01-2017 - 1000 - 2000 - 3000 - 4000 - 0
08-01-2017 - 1100 - 2200 - 3600 - 4050 - 7
16-01-2017 - 1201 - 2400 - 3800 - 4100 - 8
23-01-2017 - 1308 - 2600 - 3990 - 4150 - 7
My goal is to calculate an daily number for Value1, 2, 3, and 4
Kind regards,
Wilco
(ZoHo Creator newby)