Ok. So I have almost everything in place for managing referrals. You can see it on: https://i8tva.glideapp.io/ (Tab: Win iPhone). Or see attached screenshot
It tracks number of referrals and gives the names of people who have mentioned you as a referrer using phone number as a referral id (uses Textjoin Array, in case anyone is interested).
It works. My only problem is that I have to enable Public with email to get this all to work. Ideally, I would want the user to login only when they click on the Tab (or favourite something, but this already works well even in Public apps). Or even more ideally, when the user click the “Create Profile” button after reading everything on the tab.
I tried the suggestion in Login workarounds? of making it public again. However, it doesn’t work for me because I want to customise what I show on the tab based on the login id. That is passed as a parameter when the user fills up the profile form.
Another idea I had was to IMPORTRANGE the data out to another spreadsheet, suitably anonimise it and let people view that to find out the same details. I might then be able to eliminate the login to fill the form.
Any other suggestions on how I can implement this?