Circular reference

Mahandry · ‎Jul 26, 2023

Need Help please.

I have decided to record my workout sessions on Airtable, and I want to customize the "Set" field depending on the "Type" field.
My goal is to format "Set" to duration when the "Type" is "Dead Hang". Otherwise, "Set" format will be number.

I have tried this formula, but I am getting an error message saying "circular reference". Can anyone help me with this?

Thank you

Mahandry · ‎Jul 26, 2023

Perhaps what I want to do is not available on Airtable, but the desired result is like in the image, without hiding some fields. All "Set" field formats will be duration when the "Type" field is "Dead hang", and number (int) otherwise.

See Solution in Thread

Sho · ‎Jul 26, 2023

Yes, you cannot specify more than one format for a single field.
It can be pseudo-replicated as a string, but the summary will not work.
If you don't mind splitting the View, maybe you could create a formula field for time display.

See Solution in Thread

Sho · ‎Jul 26, 2023

The error is caused by a reference to {Set} in the "Set" field.
Is there another field name where you are inputting the number of seconds of dead hang?

Mahandry · ‎Jul 26, 2023

Perhaps what I want to do is not available on Airtable, but the desired result is like in the image, without hiding some fields. All "Set" field formats will be duration when the "Type" field is "Dead hang", and number (int) otherwise.

Sho · ‎Jul 26, 2023

Yes, you cannot specify more than one format for a single field.
It can be pseudo-replicated as a string, but the summary will not work.
If you don't mind splitting the View, maybe you could create a formula field for time display.