- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 05:38 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 09:23 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 09:48 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 07:00 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 09:23 PM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 26, 2023 09:48 PM
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.
