Hello MC,
Can someone please help me, I have a number of AI columns. I cant work out how to enable the column to only draw information when the variable column is populated.
Often if there is nothing in the variable column it will show ‘No Result’ but I just want it to stay blank. or even Better unless the variable column is populated not to run the AI at all use up uneeded AI credits.
has anyone found a solution to this?
hi @Moeydc, Sirah here from Mindflows!
Have you experimented with adjusting the words or output you were aiming for? This could impact the results. Additionally, you can check Monday’s Knowledge Base for more details on the AI Column here: https://support.monday.com/hc/en-us/articles/18640208769682-Autofill-with-AI
Hope this is helpful!
Perhaps tell it to leave the spot blank if no result? I haven’t tested that yet, but perhaps it could work?
AI columns auto-trigger on any update, even if the variable is empty — no native way to block that yet. Best workaround: add a condition in the prompt like If [Column] is empty, return nothing. It still consumes credits, but avoids No result showing up. Would be nice if we could set trigger conditions, but that’s not there yet.
Hello!
Thanks for the info I will try to figure it out for more.
I had found some code ELIF code that worked worked for me, and just put the else statement to return nothing.
AI ELIF Statements:
For Style (could also use for Finish):
def classify_image(label):
if label == “shelf”:
return “N/A”
elif label == “Hamburger”:
return “Chesseburger”
else: return " "
print(classify_image(Part Type))
I agree with the others—try being VERY explicit about that in your custom instructions. I’d also recommend providing multiple examples in your instructions, and making sure at least one of those examples is specific to blank values.
EXAMPLES:
Column X Value = “{put in an actual example}”
Desired Output = “{put in what the output should be}”
Column X Value = “”
Desired Output = “”
If that doesn’t do it, you can experiment with different ways to express the concept of “blank cell”. (Usually, “” will be recognized by computers/AI, but you might also try “null”, “blank”, “empty”, etc. to see if you get better results.)