Help

Re: Formula to show true/false based on attachment field

Solved
Jump to Solution
452 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Caitlyn10
6 - Interface Innovator
6 - Interface Innovator

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"
)

 

1 Solution

Accepted Solutions
jerry4422cherry
5 - Automation Enthusiast
5 - Automation Enthusiast

@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.



See Solution in Thread

3 Replies 3
DJ_Montoya
4 - Data Explorer
4 - Data Explorer

Here are the 2 formulas that mimic what you describe above based on the table in the attached image.

 

IF(Map, "Has Image", "Needs Image")
 
IF({Has Image}= "Has Image", "Record is good", "impcomplete")

Screenshot 2024-09-28 at 2.51.07 PM.png

jerry4422cherry
5 - Automation Enthusiast
5 - Automation Enthusiast

@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.



Thanks @jerry4422cherry I really appreciate it!