Show only rows that are relevant the current user from data imported from a google sheet

frenzoc08 · 2024-08-17T15:58:59.645Z

Hello everyone!

I’m currently importing data from a google sheet into my bubble app through SheetDB and Bubble’s API connector. I was able to successfully show the contents of the sheet in a table on bubble, but my problem is that the table should only show the rows that match the current user.

My thinking is that I should create a column in my google sheet that matches my user’s unique ID but I can’t seem to make it work. How should I go about this?

Thank you and any help would be greatly appreciated.

Zeroic · 2024-08-18T09:10:25.770Z

Hi! Yes, a field in your sheets to link records to specific User unique IDs seems to be a decent solution. You’ll need to be careful of your privacy rules though so that you don’t end up returning all the data from the server side

system · 2024-10-26T15:59:53.724Z

This topic was automatically closed after 70 days. New replies are no longer allowed.