Hi,
I am looking for a way to insert 1 of 2 icons or images into a Collection using Name - Template, Replacements based on a total.
I am currently displaying training topics and related completion for a given quarter (layout image below)
This is being done via Template name and Replacements as shown below in Data view from the Users Table:
What I want to do is insert an additional Replacement that can utilise the course hours (Structured and Total numbers) and then insert 1 icon/image if the total is below a threshold (less than 1 hour structured and 3 hours total) or Insert a 2nd icon/image if the total is greater than a threshold (greater than 1 structured hour and 3 Hours total)
Any suggestions or recommendations please ?
Use an if-then-else column that returns the appropriate image based on the thresholds, then use the if-then-else column as a replacement in your template.
1 Like
Thanks Darren. Bit of a nooby question⌠should I be inserting the if-then-else column into the users table or a sub table ? I ask this as there is an if-then-else column set up already but it is within a different data sheet not the overarching Users.
Unfortunately when I try to modify the Replacements within the Name Template, I can not view/select the Display that is utilising the if-then-else as it is not listed under the Users tree ?
Here is a view of the Data sources⌠the if-then I am referring to is within Training Status Sheet and does not seem to be selectable as part of the name Template that is currently displaying the other information ?
You are creating this template column in your Users table, yes?
Could you bring the if-then-else from the other table either as a Single Value, or via a Lookup?
Correct, the template column is already established in the Users table.
Are you saying/suggesting I could create a new Lookup column in the Users table that brings/pulls the if-then-else from the other table (Training Status Table) ?
Also, are you aware of a way to switch the if-then-else statement (text) to an image or icon ?
Thanks once again for your thoughts and input
Yes.
Just reference the column that contains the image URL in the âTHENâ condition.
Awesome, thank you so much.
1 additional question, how do you create a new column in the user table as part of a sub group ?
In the image above, my Users table is divided into âsub groupsâ ? By sub groups I mean collections or groupings of columns. IE CSV | Current Period | Training Status |
I would like to create a new column within the Training Status group but unfortunately when I (+) a new column it is outside of the Training Status grouping and I cant work out how to include it within the training status collection ?
Easiest way is to duplicate one of those existing sub-group columns, then rename/reconfigure it, leaving the group name intact. Thatâs what I generally do.
Alternatively, you can âAdd column rightâ, then name it like Training Status/My new column
1 Like
