Using Lists with Links

Questions and Help
1

I need help making a list. What I would like to do is be able to list a large number of my contacts in a drop-down menu where I would be able to check off the contacts I want to share. In the drop-down menu, it would only show the contacts name. However, once they are selected in the list I would like it to show "contact's name, profession, link to their website". Normally I would do this with a drop-down menu tied to multiple IF conditions, one for each contact. However, the part that I'm struggling with is how to have the system list the contacts I check off one after the other separated by a ";". Can someone help me with this?

Thank you,
Jen

2

Hi @EduSnip_Trailblazer are you looking for something like this?

{dbselect: SELECT Name FROM Table1 ORDER BY Name ASC; space=id; multiple=yes; menu=yes}{=join(name, "; ")}

You can get it by clicking on the three dots next to the "name" option and clicking on the "Insert sentence" option, as shown in this image:

image
image624×293 16.4 KB

1 Like
3

@Gaurang_Tandon You are the best! I thought data blaze might be able to help me and I played around with it a little bit. However, I had one issue I couldn't figure out. I wanted the website to be linked to the person's name instead of it showing an ugly URL. I couldn't figure out how to do it. Here's and example of what I would like the list to look like:

Janet, Designer, (555-555-5555); Dave, Hair Stylist, (555-555-5555); Mary, Make-up Artist, (555-555-5555); Amy, Alteration, (555-555-5555); Rose, Stylist, (555-555-5555)

In this example, the person's name would be hyperlinked to go to their website or social media page. I do want the contacts listed all together like this as well. Any ideas?

4

Sure, here's an example:

{dbselect: SELECT Name, Profession, Phone, Link FROM Table1 ORDER BY Name ASC; space=id; multiple=yes; menu=yes; name=results}
{repeat: for (result, index) in results}{if: index>1}; {endif}{link: {=result["link"]}}{=result["name"]}{endlink}, {=result["profession"]}, ({=result["phone"]}){endrepeat}

Notes:

  1. Used {repeat} command to iterate through the results: http://blaze.today/commands/repeat
  2. Used {link} command to create the dynamic link: http://blaze.today/commands/link
  3. Gave a name to the {dbselect} command so I can iterate over the results
1 Like
5

@Gaurang_Tandon This worked perfectly! Thank you so much!