I tried the Lookup feature in Data with a simple case :
- An USERS Sheet with NAME and EMAIL
- A SUBMISSIONS Sheet with only EMAIL
- A Column Relationship of EMAIL in SUBMISSIONS with USERS
- A Lookup Relationship in SUBMISSIONS to get NAME from USERS sheets
It doesn’t seem to sync data to Google Sheets when I submit the form. If I remove Lookup relationship, it does work.