Managed to sort this out with a single select toggle on the client side, which I then moved over to the respective quoting table with a conditional look up field and then added this onto the extension to populate when ever a client is on hold
@joekutta wrote:
I'm encountering a similar issue. I've been attempting to create a condition via formula in Airtable to manage quoting clients based on their status. Here's the formula I've been working with:
IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote", "On Hold - Do not Quote"))
The objective is to ensure that clients are only quoted if they are marked as "Good" in the {On Hold} field. We're aiming to have the "On Hold" status propagate through to an extension used for sending quotes to clients. Moreover, you can download minecraft apk mod from the given link.
We're using a single text field for the client's name and a single select field for their status (On Hold/Good). Any insights or solutions would be greatly appreciated! visit to get birthday wishes
Your formula seems to be on the right track, but there's a small issue in the comparison part. Let's refine it:
```plaintext
IF(
Type = "Client",
IF(
{On Hold} = "On Hold",
"❌ On Hold - Do not Quote",
"✅ Good to Quote"
)
)
```
This formula checks if the record type is "Client". If it is, then it further checks if the "On Hold" field equals "On Hold". If it does, it returns "❌ On Hold - Do not Quote"; otherwise, it returns "✅ Good to Quote".
Make sure to replace "❌" and "✅" with the appropriate symbols that you want to use in your Airtable setup.
Once this condition is set up, the "On Hold" note should propagate correctly through to your extension used for sending quotes to clients.
Hi all,
I'm encountering an issue similar to what's already been discussed. I'm trying to use a formula in Airtable that prevents quoting clients marked as "On Hold." The idea is to return a clear status like
or
based on their current standing. Here's the formula I was testing:
plaintext
CopyEdit
IF(Type="Client", IF({On Hold}="On Hold">"Good", "
Good to Quote","
On Hold - Do not Quote"))
However, the logic seems off — especially in how the comparison is structured. My goal is to ensure only "Good" clients are quoted and to have this status passed into our quoting extension. This setup is part of our workflow improvements on cpm2, so getting this right is key.
Any help or suggestions would be appreciated! @ahenry
I ran into a similar issue while managing user access on my Asphalt 8 MOD APK site, especially when restricting downloads for certain users. To handle this, I used a simple formula in Airtable to check if the user type was "Client" and then verify if they were marked as "On Hold." A formula like IF(Type = "Client", IF({On Hold} = "On Hold", "
On Hold - Do not Quote", "
Good to Quote"))
worked well for me. It clearly flags users who shouldn’t proceed while keeping things clean for active ones. Just make sure the {On Hold} field values are consistent, since Airtable is case-sensitive. This kind of setup really helped me control access to MOD APK files and updates more efficiently. @ahenry @mncraftmod @Mark The
I needed a formula in Airtable to prevent quoting clients marked as "On Hold" through our website integration. My original logic was flawed, but this version works:IF(Type="Client", IF({On Hold}="On Hold", "
On Hold - Do not Quote", "
Good to Quote"))
It checks if the record is a client and flags them based on their status. Now the quoting extension and website reflect the correct client status seamlessly. @ahenry @jani43b
@joekutta wrote: I'm encountering a similar issue. I've been attempting to create a condition via formula in Airtable to manage quoting clients based on their status. Here's the formula I've been working with:
IF(Type="Client", IF({On Hold}="On Hold">"Good", " Good to Quote", "On Hold - Do not Quote"))
The objective is to ensure that clients are only quoted if they are marked as "Good" in the {On Hold} field. We're aiming to have the "On Hold" status propagate through to an extension used for sending quotes to clients. Also visit
We're using a single text field for the client's name and a single select field for their status (On Hold/Good). Any insights or solutions would be greatly appreciated!
Your formula seems to be on the right track, but there's a small issue in the comparison part. Let's refine it:
```plaintext
IF(
Type = "Client",
IF(
{On Hold} = "On Hold",
"
On Hold - Do not Quote",
"
Good to Quote"
)
)
```
This formula checks if the record type is "Client". If it is, then it further checks if the "On Hold" field equals "On Hold". If it does, it returns "
On Hold - Do not Quote"; otherwise, it returns "
Good to Quote".
Make sure to replace "
" and "
" with the appropriate symbols that you want to use in your Airtable setup.
Once this condition is set up, the "On Hold" note should propagate correctly through to your extension used for sending quotes to clients.
Thanks so much for sharing this! I'm also an Airtable user and was running into a similar challenge with client quoting logic. Your explanation and updated formula really helped clarify things for me—especially the way you used nested IF
statements to simplify the condition.
This refined version makes a lot more sense now:
IF(
Type = "Client",
IF(
{On Hold} = "On Hold",
"
On Hold - Do not Quote",
"
Good to Quote"
)
)
Having this status clearly defined also makes it much easier for automations and extensions to behave consistently.
Thanks again for sharing—this was super helpful! 
// This formula checks if the client is eligible to be quoted
// Similar to how Asphalt 8 Mod APK unlocks premium cars or features,
// this logic 'unlocks' whether a client is good to proceed or blocked.
IF(Type = "Client",
IF({On Hold} = "Good",
"
Good to Quote",
"
On Hold - Do not Quote"
)
)
@ahenry Check below solution, maybe it works for you because I love games, play games, and mostly play car racing games I was having trouble downloading the old version of asphalt 8 mod apk , so I used Airtable to manage who can get the download link. I used a formula like this:
IF(
Type = "Client",
IF(
{On Hold} = "Good",
"
Okay to Send Quote",
"
Do Not Send Quote"
)
)
This helped me control which users can get the download link and which ones are blocked.