Want to create a link that auto updates

Ask for Help
1

I’m trying to create links like the search gmail link on the CRM template.

I have this link:
https://www.facebook.com/groups/146144436188767/search/?q=Nita%20Gaylard

I need it to auto change the text from “Nita Gaylard” to say “Emma Lang” for each person. The names are currently one field, but I’ll change if I need to but would prefer if I didn’t (I.e. Emma Lang, not Emma in one and Lang in another).

(This is for Facebook group management and getting new moderators on board - Not cold DMing or similar!)

Any tips on how to do it? I know this below was the original formula on the CRM template and know I need to do similar, but still learning! :slight_smile:

from urllib import quote_plus
“Gmail search Gmail” % quote_plus($Email)

1 Like
2

Assuming you have a Name column:

from urllib import quote_plus
"Facebook search https://www.facebook.com/groups/146144436188767/search/?q=" + quote_plus($Name)

Then set the type of the column to Text and the format to Hyperlink.

2 Likes
3

Thank you!!! Saved me hours of searching as I need to open them multiple times… And do this again in the future, but more importantly, I’ve figured out how to do it on my own!!

1 Like