Update Data on a Table, When other table create new entry

Hi guys Im doing a fitness app.

Table 1 Columuns are:
Users - Weight

Table 2 Is a Register of many diferent weight mesures per user in different dates:
Date - User - Weight

I wanna update Table 1 Weight (Per user) auto-updating last weight mesured

Example:
Table 2
15/7 Juan - 230lbs
15/8 Andres - 255lbs
15/8 Kevin - 165lbs
15/9 Juan - 228lbs
15/12 Andres - 156lbs
15/30 Juan - 220lbs

Table 1 AUTO UPDATE LAST WEIGHT PER USER:
Andres - 156lbs
Juan - 220lbs

How May I do it? THANKS!

https://community.appsheet.com/search?q=update%20other%20table%20%23ask

1 Like