Discussions

 View Only
  • 1.  Multiple URL Address Field

    Posted 02-20-2020 14:32
    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
    ------------------------------


  • 2.  RE: Multiple URL Address Field

    Posted 02-20-2020 14:53
    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
    ------------------------------