Hey APPSHEET,
I am a new User.
I want to continuosly append text everytime a value is changed in a specific cell without deleting its previous content.
for example,
i have a column named โLATEST SPO2โ containing data like this โ94% at 11pmโ and the other column named "HISTORY " saving the data.now my demand is to store the value of โLATEST SPO2โ as past record in โHISTORYโ every time value of โLATEST SPO2โ is changedโฆsuppose value of โLATEST SPO2โ changes now from โ94% at 11pmโ to โ90% at 12pmโ, i want to display only โ90% at 12pmโ in โLATEST SPO2โ column but display as โ94% at 11pm,90% at 12pmโ.
Again when value of โLATEST SPO2โ changes suppose to โ85% at 1amโ from โ90% at 12pmโ, โLATEST SPO2โ should show โ85% at 1amโ but โHISTORYโ should show โ94% at 11pm,90% at 12pm,85% at 1amโ
i hope my problem is clearโฆ
You can do that with setting the RESET ON EDIT property of your columns and using an expression in the Initial Value of the columns.
Thank You So Much ManโฆThanks A LotโฆSorted My Issue
Youโre welcomeโฆGlad to hear that you have solved itโฆ
I have used as saidโฆi have created a 3 columns namely latest,past and historyโฆlatest has the latest value while past has a app formula = history and history has a spreadsheet formula of concatenating latest with pastโฆ
it worked but it also changes it value even when form is edited in some other part and not the latest column result is duplicate repitition in history column.
for an example first i have latest value = 94 then i change it to 95โฆhistory shows 95 94 both as requiredโฆbut when i change any other part of form it again appends the latest value even if its not changedโฆi.eโฆif i edit the form 2 time for some else column still history wll be updated as 95 95 95 94โฆ
my requirement is to only append if the value of latest column changes else concatenation doesnt occureโฆ
i hope you understood my requirement and problem both
Dear Rohan Shah
I want to implement in my app as a column date and column history
when every time i update column date which is = Now() should be added in column history.
Logic is same you used. can you share what expression you used.
entry 1 date 12/08/2020 history 12/08/2020
update 2 date 13/08/2020 history 12/08/2020. 13/08/2020
update 3 date 19/8/2020 history 12/08/2020. 13/08/2020, 19/08/2020
In your case i suggest you to have 3 columnsโฆnamely dateโฆpast date and date edit historyโฆ
Now what u can do thatโฆu can add a application formula for past date โฆi.e. = date edit historyโฆ
And for date edit history spreadsheet formula of concatenating date and past dateโฆ
Logic is app formula is applied during edit or syncโฆwhile spreadsheet formula applies after syncโฆ
I could give u a example asโฆ
Suppose for 1st time u enter date 13 Augustโฆ
Past value would be blank and history value will beconcatenating date and past i.e 13 august and pastโฆpast is empty so history will show 13 august for 1st timeโฆ
Then u edit it to 14 augustโฆapp formula applies during edit so past will be equal to 13augustโฆdate equal to 14 august โฆso history will be 14 august || 13 august (|| i have used in concatenating formula for differentiation)
For 3rd edit of 15august โฆit would date = 15 augustโฆpast = 14 august|| 13 augustโฆafter sync and concatenation 15august||14august||13 augustโฆ
Also hide the column past โฆ
I hope u got my ideaโฆ
Still confusion u can continue to ask
Sir i am not able to do it
can you give me the spread sheet colum formula
=CONCATENATE((K2+L2)) getting value
44062.6956481482
Dear Sir
I am not able to do it, can you help me my whats app number 9895279540
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |