When I link to a Base with a “RATING” (Little Hearts) to create a viewable, duplicate column in another base, it only allows the field to show up as integers in various forms. No Hearts. It doesn’t make sense as I’ve been able to pull over logos from other fields, is RATING just broken?
Solved
Can't Link "RATING" with icons showing
Best answer by ScottWorld
It isn’t.
Ahhh, I see, you’re using a lookup field.
I don’t know of any way to lookup a rating field and maintain its symbols, because it seems like lookup fields will only result in an array of text, numbers, or dates. (Oh, and attachments too, as you mentioned!) This would probably be a good product suggestion to add into the #show-and-tell:product-suggestions category.
Your best bet would probably be to keep that lookup field intact, and then create a new formula field that is based on that lookup field.
Your new formula field would convert that lookup field’s integer into a certain number of emojis, such as the heart emoji.
Your formula could look like this:
REPT("❤️",{Potential Revenue})
Hope this helps!
+35Hmmm… it sounds like your field type might be set to “number”. In order to see symbols, your field type must be changed to “rating”.
Hmmm… it sounds like your field type might be set to “number”. In order to see symbols, your field type must be changed to “rating”.
It isn’t.
+35It isn’t.
Ahhh, I see, you’re using a lookup field.
I don’t know of any way to lookup a rating field and maintain its symbols, because it seems like lookup fields will only result in an array of text, numbers, or dates. (Oh, and attachments too, as you mentioned!) This would probably be a good product suggestion to add into the #show-and-tell:product-suggestions category.
Your best bet would probably be to keep that lookup field intact, and then create a new formula field that is based on that lookup field.
Your new formula field would convert that lookup field’s integer into a certain number of emojis, such as the heart emoji.
Your formula could look like this:
REPT("❤️",{Potential Revenue})
Hope this helps!
Ahhh, I see, you’re using a lookup field.
I don’t know of any way to lookup a rating field and maintain its symbols, because it seems like lookup fields will only result in an array of text, numbers, or dates. (Oh, and attachments too, as you mentioned!) This would probably be a good product suggestion to add into the #show-and-tell:product-suggestions category.
Your best bet would probably be to keep that lookup field intact, and then create a new formula field that is based on that lookup field.
Your new formula field would convert that lookup field’s integer into a certain number of emojis, such as the heart emoji.
Your formula could look like this:
REPT("❤️",{Potential Revenue})
Hope this helps!
Awesome! Thank you so much, and I will make the suggestion.
+35Awesome! Thank you so much, and I will make the suggestion.
You’re welcome! Glad I could help! :slightly_smiling_face:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.