Skip to main content
Question

Multiple URL Address Field

  • February 20, 2020
  • 0 replies
  • 28 views

Hi,

Im building an app where users will complete a brief survey and be emailed a list of documents based on their responses. I have the documents sitting in an EOTI app and am having some difficulty getting the field to present a list of URL Addresses.

Below is the current
var text Docs = List("<br>",

If([HRP-211]=1,"<a href=\"https://domain.quickbase.com/up/db/g/ru/eh/va/HRP-212.doc">"HRP-212"</a>,"")
If([HRP-212]=1,
If([HRP-210]=1,
);

"<span style=\"font-size:110%; font-weight:bold\">Needed Stock:<br>" & $Docs)

I try fixing the a href statement  but i keep getting an error that the formula is expecting a Bool. This is actually a rich text field so im not sure where to go.

Thoughts/

------------------------------
GMacri
------------------------------

MarkShnierYou
Forum|alt.badge.img+24
try this

If([HRP-211]=true,"<a href=\"domain.quickbase.com/up/db/g/ru/eh/va/...
If([HRP-212]=true, ......
If([HRP-210]=true, .....
);

but this will also work

If([HRP-211],"<a href=\"domain.quickbase.com/up/db/g/ru/eh/va/...
If([HRP-212],  ......
If([HRP-210], ........
);

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------