Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 26, 2024 09:16 PM - edited Sep 26, 2024 10:59 PM
Hi there, hoping someone can assist me. I need a formula that will note true/false based on an attachment field.
For further context, this will be used in another formula that combines various fields into a link which goes to a custom Typeform. The fields from Airtable are set as hidden fields, but at the moment I'm having issues with the logic because it can't recognise if the data is true/false since the entire file name is showing. Having this terminology would be good so I can simplify the link and the Typeform logic.
I tried working with the TRUE formula but couldn't get that to work.
Let me know if you need more information. Any assistance would be appreciated.
UPDATE - I've found a solution;
IF(
{Attachment Field},
"TRUE",
"FALSE"
)
Sep 28, 2024 02:52 PM
Here are the 2 formulas that mimic what you describe above based on the table in the attached image.
Sep 30, 2024 01:24 AM
@Caitlyn10 SpotifyPie wrote:Hi there, hoping someone can assist me. I need a formula that will note true/false based on an attachment field.
For further context, this will be used in another formula that combines various fields into a link which goes to a custom Typeform. The fields from Airtable are set as hidden fields, but at the moment I'm having issues with the logic because it can't recognise if the data is true/false since the entire file name is showing. Having this terminology would be good so I can simplify the link and the Typeform logic.
I tried working with the TRUE formula but couldn't get that to work.
Let me know if you need more information. Any assistance would be appreciated.
UPDATE - I've found a solution;
IF(
{Attachment Field},
"TRUE",
"FALSE"
)
Great to hear you found a solution! Your formula:
IF(
{Attachment Field},
"TRUE",
"FALSE"
)
is a solid approach. It effectively checks if there’s an attachment in the field, returning "TRUE" if there is and "FALSE" if there isn’t.
If you want to simplify your logic further or incorporate it into another formula, you might consider using the boolean values directly (without quotes), like this:
IF(
{Attachment Field},
TRUE(),
FALSE()
)
This way, it maintains the boolean nature, which can be useful if you’re using it in subsequent calculations or logical checks.