Please try below
Create a VC called say [Status] in the Clientes table with an expression something like
IF(INDEX(SORT([PAGOS REALIZADOS][FECHA], TRUE),1)<TODAY()-60,“Inactive”, “Active”)
The highlighted part may need change based on what exactly you are looking for as condition for “Active” and “Inactive” you have described is not exactly clear.
[PAGOS REALIZADOS] is assumed to be the name of the reverse reference column in the Clientes table.
Edit: If you are looking for updating a real column in the Clientes table, you could use reference action to update the Clientes table whenever a new row is added to the child table Pagos.
The below sample app demonstrates updating child record based on parent record update through reference actions. You could use a reverse flow.
https://www.appsheet.com/templates/This-app-shows-how-to-use-reference-actions?appGuidString=e76d2e7...
LinkedIn
Twitter
