Lookup sync problem with Google Sheets when submit

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.

1 Like

I think I can reproduce this. I tried it in staging. I added 2 records using a form button to a sheet that has a lookup column. Those rows do not show in the google sheet. Once I remove the Lookup column, it works again to submit a form, but the data is now out of sync with the sheet and seems to have overwritten the third row in the glide data (I believe it said user2 instead of blah2). Rows added while the lookup was there still do not show in the google sheet.

Capture

1 Like

On it!

1 Like

Should be fixed now. Thanks for reporting!

1 Like

Looks good to me!