change colours after update

AppSheet AppSheet Q&A
,
1

[ENG] After updating a registration, I need the color to change, to signal that the registration has been changed

[BRAZIL] Após atualizar um cadastro, preciso que a cor mude, para sinalizar que o cadastro foi alterado

Pedro_Gabinete_0-1718050473235.png
Pedro_Gabinete_0-1718050473235.png988×495 58.6 KB

1 Like
2

Please use format rules. There may be a column in the table called say [Registration Status] when it changes from “Not Registered” to “Registered” , you could use this status in the format rules to change the colors of the columns.

Format Rules: The Essentials - AppSheet Help

2 Likes
3

I understand, but that’s not what I want.

I need to change the color of the line after any data update

4

This will be a format rule that will check to see what the value of the column would be not blank. the expression would be ISNOTBLANK([Column-Value]). this will tell you that there is a value in the column and will cause the color change.

If you want the rows name to change to different colors depending on value change in a column. You could base the format rule on an enum choice. This will require many format rules based on each choice, but could give you a visual representation of a users choice.

5

Example:

Name: Jack
Telephone: 9999-9999

after update (name correction)

Name: Jackson
Telephone: 9999-9999

show name in red, because the name has changed.

6

This requires many formatting rules depending on how many fields you are checking, but you can:

  1. Create Y/N virtual columns ([NameChange],[PhoneChange],etc) with a formula that checks if the desired fields have been changed:
  • [_thisRow_Before].[Name]<>[_ThisRow_After].[Name]
  • [_thisRow_Before].[Telephone]<>[_ThisRow_After].[Telephone]
  1. Create a format rules that alters all rows where [NameChange]=TRUE, [TelephoneChange]=TRUE

A more generalized way that won’t specify what has been changed, but only that something has been changed could be:

  1. Create a Y/N virtual column [Change] with a formula that checks if the desired fields have been changed:
  • OR([_thisRow_Before].[Name]<>[_ThisRow_After].[Name],[_thisRow_Before].[Telephone]<>[_ThisRow_After].[Telephone])
  1. Create a format rule that alters all rows where [change]=TRUE
2 Likes