hi !!! iโm about some weeks trying to find a way to add the previous value and the next value in a row. โwhy i want it?โ :
( i need to know the names history that edit the row,
if johny add a value i get johnyโs name, but if joao edit the same value i lost the johnyโs name and only get joao name)
and i canโt do it :(, idk if itโs possible.
someone help me
iโm trying to use a workflow: if this is true:
[_THISROW_BEFORE].[name] <> [_THISROW_AFTER].[name]
do this :
change data - calling a action
i create a new action but I do not know which action to perform.
In your Action configuration set it to
Do this
โ>
Date: set the value of a column Set this column --> name to this value --> concatenate ([_THISROW_BEFORE].[name] , [_THISROW_AFTER].[name])
That should set the value to โjohny,joaoโ in your example.
@Marc_Dillon i try it but seems like (_THISROW_AFTER) only works in workflow
appsheet.com - - portfolio of mobile apps created with AppSheet and check the app name ColumnHistory. - portfolio of mobile apps created with AppSheet appsheet.com
ty @Aleksi_Alkio its exactly what I wanted, thank you so much!!!
Oh, interesting.
In that case you can send a webhook from the workflow to update the value via a call to the appsheet API.
Its a bit complicated for such a seemingly simple task. Maybe someone else has an easier solution.
help.appsheet.com - Enabling the API
https://help.appsheet.com/integrations/api/api-the-essentials Enabling the API help.appsheet.com
yes [_THISROW_BEFOR] and [_THISROW_AFTER] are not currently available outside of workflow, so the solution you were planning doesnโt work.
However since your goal is to log the previous name, why not adding a column to your column structure e.g. [Name_Log] and in its app formula enter something like this: IF([Name_Log]<>[Name], [Name], [_THIS])
Or if you want all previous names, you could concatenate them like Marcโs suggestion.
Guys, no need to jump to API world:) You have three columns, โIDโ, โOriginalโ and โNewโ. For the โNewโ column you can write an app formula something likeโฆ
=SPLIT(LOOKUP([_THISROW].[ID],Update,ID,New))+ IFS([ORIGINAL]<>LOOKUP([_THISROW].[ID],Update,ID,Original), LIST([Original]))
Every time when you change the value in the โOriginalโ field, it will update your list in โNewโ field. The โOriginalโ is a text type field where the โNewโ is an EnumList. The main reason why it works itโs the IFS statement because you will evaluate the new value against the old (not updated yet) value in that table. Because the record is not saved yet, it will find out the difference.
@Aleksi_Alkio i canโt do it, i donโt understand the code, why there is update, if only have 3 columns? i create your example and i get this error:
Update is just a table name.
i canโt get this to work, SPLIT(LOOKUP([_THISROW].[ID],Update,ID,New)) update id new, are tables? if yes i do it and i get error
Let me create a sample so you would see how it works.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |