Skip to main content

ROLLUP or CONCATENATE

  • June 17, 2020
  • 4 replies
  • 54 views

Forum|alt.badge.img+8

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

4 replies

Forum|alt.badge.img+8
  • Author
  • Known Participant
  • June 17, 2020

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


Forum|alt.badge.img+19
  • Inspiring
  • June 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:


Forum|alt.badge.img+8
  • Author
  • Known Participant
  • June 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:


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


Forum|alt.badge.img+19
  • Inspiring
  • June 19, 2020

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?