0

show three formula fields (with icons) together in a fourth field

How can I show three formula fields (with icons) together in a fourth field?

I have:

'Avviso nota' + 'Avviso allegato'+'Avviso link'

.....doens't work!

The three fields have formula expression like:

if Link != null then
styled("", "", "linked")
end

 

What should I do? Thanks

9 replies

null
    • Jorg
    • 4 yrs ago
    • Reported - view

    Hi, 

    Please try the following:

    if Nota != null then 
    styled('Avviso nota' + 'Avviso link' + 'Avviso allegato',"", "", "pencil") 
    else 
    if Link != null then
    styled('Avviso nota' + 'Avviso link' + 'Avviso allegato'"", "", "linked")  
    else 
    if Allegato != "" then 
    styled('Avviso nota' + 'Avviso link' + 'Avviso allegato',"", "", "attachment") 
    end

     

    Or also you can try it that way:

     

    styled('Avviso nota' + 'Avviso link' + 'Avviso allegato',"", "", 
    if Nota != null then "pencil"
    else 
    if Link != null then "linked"
    else 
    if Allegato != "" then "attachment" end)

     

    Best, Jörg

    • Birillo
    • 4 yrs ago
    • Reported - view

    thank you, tried... but doesn't still work :-(

    • Birillo
    • 4 yrs ago
    • Reported - view

    I'd like to have shown the three icons together in the same fileds, not only one icon

    • Birillo
    • 4 yrs ago
    • Reported - view

    in the same moment, I mean..

    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    I think in a formula field you can only have one icon. You could try  using unicode (📎 - 🔗 - ✏ - ...)character instead of the build in icons.

    • Birillo
    • 4 yrs ago
    • Reported - view

    what's unicode?

    • Nick
    • 4 yrs ago
    • Reported - view

    @Steven is right, works with unicode characters. Search the internet for Unicode Characters then copy and paste.

    Screen Shot 2019-05-20 at 20.56.09

    Screen Shot 2019-05-20 at 20.57.52

    • Birillo
    • 4 yrs ago
    • Reported - view

    WOW! Thank you  :-)

    • Nick
    • 4 yrs ago
    • Reported - view

    Of course, in that case you don't need "styled" function.

     

    let d := today();
    if d >= DateStart and d <= DateEnd then
    "🔔"

    end

Content aside

  • 4 yrs agoLast active
  • 9Replies
  • 1731Views