Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

ROLLUP or CONCATENATE

Topic Labels: Formulas
2549 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

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 Screenshot 2020-06-17 13.59.57

4 Replies 4
Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

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

AlliAlosa
10 - Mercury
10 - Mercury

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:

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

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?