Helpppppppppp! Look up not Auto Update

AppSheet AppSheet Q&A
1

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.

2

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:

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.

1 Like
3

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

1 Like