The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Trending
Applications
Case Studies
What is Ragic
Talking Ragic
Facebook Twitter YouTube
Product
Guide
About
Trending
Applications
Case Studies
What is Ragic
Talking Ragic

Quick Data Entry Tips: Traffic light status indicator

By Berrin Sun

If you're trying to display from a set of images that will change according to a certain value in a selection field, the easiest way is to use an insert image BBCode in the formula on a free text field.

Since the image will need to be referred to with a URL, the image will need to be hosted online. This can be on your own website, on a free image hosting service, or even in an attachment you've made in a form comment on Ragic. In our example, we're using imgur to host 3 traffic light icons.

We would like our project proposals to show a red icon if the project proposal has the status "Rejected", a yellow icon if the project proposal is "On Hold", and a green icon if the status is "Approved".

Traffic Light Icons

Using a nested conditional formula on field A5, where our Status Indicator will be,

IF(A4.RAW=='Rejected','[img]http://i.imgur.com/JTH6pcq.png[/img]',

IF(A4.RAW=='On Hold','[img]http://i.imgur.com/cVorwf4.png[/img]',

IF(A4.RAW=='Accepted','[img]http://i.imgur.com/xqtgvSV.png[/img]','please make a status selection'

)

)

)

the end result is displaying the appropriate icon link with the [img] BBCode tag, and the text 'please make a status selection' if a selection is not made.

Selecting the field A4, which is the project status, we're able to view the icon on our form page.

The status indicator is also visible from the listing page.

Author's note: This is part 2 of my blog series, Quick Data Entry Tips. Click here for part 1, entering data into linked fields, and here for part 3, populating values with formulas.

Category: What is Ragic, Tips and Tools

Powered by Ragic! : #1 No Code tool for digitalizing your business processes
Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
Create your first database now!

Start Ragic for Free

Sign up with Google