Re: ROLLUP or CONCATENATE

Leslie_Miller · ‎Jun 17, 2020

IT’S ME AGAIN,
I would like to add a column that contain code based on fields.
This is the code with the field names inserted. But how would I get airtable to pull those fields and write out this code?

<a href=“Instructors page Link”>name
medium
Date Range Friendly
Time slots
Bottomline

Thanks to all of you that help us undereducated

Amy Brakeman Livezey
Acrylic
March 25-27, 2021
9-4
$325.00/3-day workshop

Results in

Leslie_Miller · ‎Jun 17, 2020

It didn’t copy my code correctly but basically a break between each field.

AlliAlosa · ‎Jun 17, 2020

Hi there! If I’m understanding correctly, you’ll want your code to look something like this…

"<a href=\"" & {Instructors page Link} & "\">" & {Name} & "</a>" & "\n" & {medium} & "\n" & {Date Range Friendly} & "\n" & {Time Slots} & "\n" & {Bottomline}

However… if you’re trying to eventually output this in HTML, which it appears you are… you’ll want to replace each "\n" with "<br>". "\n" will give you a line break in Airtable, whereas "<br>" will give you a line break in HTML.

Hope this is helpful! :slightly_smiling_face:

Leslie_Miller · ‎Jun 17, 2020

not working do all fields have to be a text field or can they be multi-select?

AlliAlosa · ‎Jun 19, 2020

The fields can be multi-select. It should return the options in a comma-separated list.

What exactly isn’t working? Is something displaying incorrectly?