At https://lowcode.agency we’ve been working on a couple of MASSIVE apps that I’ll show you guys (hopefully) soon, but today I wanted to show you this app.
TheFreeBirds is a community, and the challenge for this client was that everything was in a different place: Facebook group, Kajabi, job board, etc.
Probably it deserves another post but I’m gonna write it out here first.
I have a separate sheet with 4 rows. Let’s call it “Social”. One fixed column contains these values:
Then 1 user-specific column called “Dynamic link”, which I will use for this trick.
Then back to the user’s sheet, I make 4 template columns contain text values email, phone, LinkedIn, website.
Those 4 template columns are then used to make 4 relations to the “Social” sheet.
The action when any user opens each user’s profile item is firstly view details, then 4 set columns based on those 4 relations to insert the actual email (mailto: Email), phone (tel: Number), LinkedIn (URL) and Website (URL) to the “Dynamic link”.
By doing so, I only need 4 rows to achieve what I need.