Helpppppppppp! Look up not Auto Update

[Xuxun_huang]

Hi,

I have data in Table A and Table B
In Appsheet I created 2 form → Form A and B which import data from table A, B respectively.

In Form A, I have looked up some of table B data.
However, when I edit data in table B it’s not auto update in form A.

I have to click on that row data in form A and Click Save again to get the update data.

I just wonder that how to auto update data in form A that I dont need to re-click the save button when the another table data has been changed.

[Aurelien]

Hi @Xuxun_huang

Welcome to the community !

This is probably because your lookup column is a real column.
You may prefer turn it into a virtual column, or use an action in order to update the value in the table A.

Here are more informations:

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

I didn’t retrieve a recent post relating to that, but basically:

• virtual columns are calculated on the fly
• real columns are calculated only when editing the row

In your case, virtual columns may be the best option.

[Steve]

https://community.appsheet.com/search?q=@steve%20virtual%20real%20column%20updated