FORMAT RULES COMMERCIAL VISITS

[Jose_R_B]

Hello App Sheet Community!

I need to give a format rule to the column "CuentaCliente (Text)" of the table "BaseDatosClientes" based on the last record of "FechaVisita (Date)" of the table "RegistroVisita".

If it does not meet the estimated term, it should be put in red.

Thanks in advance.

[aneeshatgoogle]

I am assuming you have a ref column in BaseDatosClientes that references rows in RegistroVisita.

You can add an expression in "If this condition is true" in the format rule to set text colour to red when it doesn't meet your criteria.

Please see configure the following properties section of the format rule: https://support.google.com/appsheet/answer/10106703?hl=en

[Jose_R_B]

Not quite,

I already had to use the column reference for these two tables but the other way around, that is:

RegistroVisita is that references rows in BaseDatosClientes

From what I could see they don't work bidirectionally so I thought about using the Select expression but without getting any results.

Any other ideas I can implement?

Thanks 🙏

[aneeshatgoogle · Accepted solution]

Using select() directly in format rule condition can slow down app UX performance if you have too much data since format rule condition is evaluated when app is rendered. 

I will recommend adding a virtual column to calculate the value you want to check in your format rule. The approach will still be the same, using select to find the right row in `Ref_Rows`

[Jose_R_B]

Thanks