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.
Jun 17, 2020 01:29 PM
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
Jun 17, 2020 01:30 PM
It didn’t copy my code correctly but basically a break between each field.
Jun 17, 2020 02:15 PM
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:
Jun 17, 2020 02:45 PM
not working do all fields have to be a text field or can they be multi-select?
Jun 19, 2020 06:31 AM
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?