I have a master sheet that has all of the businesses data already, so when a business signs in they do not need to fill out a profile. The user profile sheet captures their email address they sign in with and a Row ID.
If I can somehow pull over their name and featured image from the master sheet to the user profile sheet, that may work.
Okay, I get it.
Yeah, I think that would probably work. Just set it up in a similar that we did with your Public sheet.
I guess the problem is, if you allow them to edit their profile, then things will get messed up pretty quickly.
In fact, if youâre using ARRAYFORMULAâs to bring the data across, then the first time a user edits their name or profile pic, the formulas will break.
So youâd either need to keep those two columns read-only, or re-think your approach.
Ok thanks!
Wasnât there another formula and changes the copied data when itâs altered?
I think this was it:
={âName of Businessâ;ARRAYFORMULA(IF(âName fo Sheetâ!E2:E="","",âName of Sheetâ!E2:E))}
This formula changes when the orginal data is altered correct?