Jan 12, 2021 10:34 PM
I’m working on a Risk Register. I’d like the Priority single select field to display options ranging from very low to very high, depending on the risk rating number that is returned through a formula field. For example, the formula field may determine the risk rating to be 25. I’d like the Priority single select field to display the words ‘very high’ in red. If the number value is returned as 5, I’d like the Priority field to display ‘very low’ in green.
Jan 13, 2021 04:50 AM
I think that the problem with using automations for this, is that you can’t diversify the action based on the conditional trigger. I would use a formula field with a
SWITCH() function and then use a conditional color code to highlight the records depending on their risk.
Apr 01, 2022 08:21 AM
I’m trying to do the same based on a formula field. The output is needed to colour code a map marker in the Map app, so this calculated (Yes/No) field needs to be replicated as a Single-select field. Is this possible? I only need an automation to trigger this script twice a day.
Apr 04, 2022 12:08 AM
Hi @MikeKennedy and welcome to the community!
Airtable now has conditional automation actions, which allows you to fill in a single select field, based upon the calculated result your mentioning. In the map app, you can then use the colours from that single select field to be reflected.
Apr 06, 2022 06:54 AM