Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 18, 2021 10:11 AM
I have a main board that links to a task page which lays out all my tasks. When a task is marked as completed i would love for that field on the main board to demonstrate this. either through a color change or a strike through. I can make the color change within the task page but the change is not demonstrated on the main board.
In the below image - some of these tasks are completed and some not so there is no way to tell the priority !
May 18, 2021 10:34 AM
The design of Link to another record
-type fields cannot be changed.
What you could do is make the primary field in your [Tasks]
table a formula field that looks something like this:
IF({Status} == "Completed", "✔️", "❌") & " " & {Task Name}
That will add a checkbox emoji to the front of tasks that have been completed, and the checkboxes will show up in your [Projects]
table’s {Task}
field since the checkbox is part of the linked record’s name.
May 18, 2021 11:40 AM
Thank you so much Kamille!
That is a great suggestion, however it is not responding correctly. It is giving me the red x on everything.
Can you advise me on how to amend the code?
Thank you!
May 18, 2021 11:47 AM
Sorry, I assumed that there would be a Single select
-type field where one of the options is “Completed”. You’re using a Checkbox
field so it will either have the value of true
or no value at all (Completed
is not a possible value), which is why every record shows an X
. Adjust the formula like so:
IF({Completed}, "✔️", "❌") & " " & {Name}
May 18, 2021 03:26 PM
Hi Kamille!
That formula works however when I attempt to add it to the primary field it tells me it causes a circular reference.
Thoughts?
Thank you!
May 18, 2021 04:06 PM
I’m assuming you didn’t duplicate {Name}
and are trying to overwrite it directly. You’re not trying to replace the {Name}
field but add to it. So duplicate {Name}
so you don’t lose any data, then turn the original {Name}
field into the formula and reference the copy of {Name}
instead.