I have a dashboard with a search bar parameter. It works great, but if someone makes a spelling mistake or searching something not in the database, it will not show any results. Can I add an error message if no search is found? I was hoping an IF THEN statement could work.
My current code is: { FIXED [DISTRIBUTOR] : MAX(
IF CONTAINS(LOWER([PRODUCTS]), LOWER([Universal Search ]))
OR CONTAINS(LOWER([BRAND_FARM]), LOWER([Universal Search ]))
THEN 1
ELSE 0
END
) } = 1
From what I understand, it is a Boolean, so if I add another option besides True/False, then my parameter filter on the Search Results does not work.
I tried putting the "Oops" message in the place of the 0, and it does not show up on Search Results.
I am not a coder and barely understand the basics. Can I add an error message to say "Opps...try again with a similar word" in the code? I feel like it should be possible, but I do not want to spend weeks learning code to do this task.
This latest response is unfortunately a ChatGPT post. Based on the number of responses overnight and through today, the effort might even be automated. We have a BAN on any A.I. posts due to the high error rate. So, we're considering these posts as spam. Apologies for any inconvenience this may have caused.
