Help Troubleshooting New Error regarding "Required If"

I’m getting a new error that i cannot seem to troubleshoot. I have an action that triggers when a patient is flagged as discharged. Most of the action is working, but the part that blanks certain columns on discharge fails if the patient’s [Follow Up] column value is “No Follow Up”

Lemme share some screenshots that may help better explain what i am seeing. We’ll use my favorite test patient Homer Simpson

what’s throwing me is the fact that what it is complaining about no being present seems to actually be there :thinking:

do you guys and girls see something that i am missing here?

Hi @mykrobinson

About this:

Can you try instead:

IN("No Follow Up", [Follow Up])

For reference:

IN() - AppSheet Help

EDIT

At reading this:

The bot keeps in mind some “value when triggering” when starting a process. I had a similar situation earlier.

I would suggest either:

  • use a group of actions to blanks the field you need before firing the bot (if you actually need the bot - I prefer using groups of actions when it’s possible)

  • use various steps in the bot (not sure that would work, but just in case)

2 Likes

Funny, i had switched it to that before taking the screenshots to test, but apparently did not save it before testing.

Thank you, i’ll test in a bit and follow up to confirm if it’s working.

2 Likes

@Aurelien i may have just stumbled across the problem. Let me talk myself through this… Here’s the trail of events that happens when a new discharge record is created:

The “reset patient information after discharge” step fires the following action. Notice the part i circled:

I think this is causing a conflict since “no follow up reason” cannot be blank if the value of [Follow Up] is “No Follow Up,” and provider have only recently started marking “no follow up,” which explains why i have not seen this error before. Seems i can fix this by setting [No Follow Up Reason] to “Not Indicated” or some non-blank value, or by also resetting [Follow Up] to “Undecided” or something other than “No Follow Up”

Yes, that is what I’m trying to explain, please forgive my poor expression :slightly_smiling_face:

What I mean is that, at every step of the process, the bot keeps in mind the value stored when triggering the initiation of the process, no matter the change brought by the bot.

Just an idea:

Would you try just changing a trigger column? Like a “+1” value for example. And set the option “can trigger other bot”.

And another bot would fire because of this trigger, if you get what I mean. This second bot would reset the hospital information after discharge.

Here is a drawing of an example I made earlier:

2 Likes