Mandatory (obligatory) field not being respected.

[AJRIGO]

Hi Experts, hope everything is well with you all. 

I am facing a weird behavior of appsheets for a mandatory field (column) that user must to input a data there, even with error message appsheet allows saving it as blank. I suspect it is because the data type of that field (column).

Column type is a URL. It is flag as Required (no formula here). 

Here is a shotscreen. As you can see red message (in portuguese) is written that field is obligatory, however when user clicks on Save appsheets saves it as it was filled, but if I look at table that column is blank. I dont know what is the reason for that, but looks like a bug. 

Any ideas how to solve this?

[Joseph_Seddik]

I'm not sure what's causing your problem as you describe it. Seems like a bug, but I don't know for sure.

In any case, just to get your form working as desired, you might want to try putting this expression in the Valid if field: ISNOTBLANK([_This])

[Suvrutt_Gurjar]

@AJRIGO ,

My testing showed that the URL field respects the "Required" setting.

Also typically the message "this entry is required" gets displayed only when you are trying to save the form without entering any valid value in the field. So the "required" setting seems to be behaving as desired because the error message is displayed in your screenshot.

Are you saying that even after showing the error message , the form is getting saved? Then it could be a bug for AppSheet team to investigate. Or else you may want to doublecheck the configuration of URL column and any other associated logic.

Hi @Joseph_Seddik ,

Unfortunately one cannot check a blank with valid_if.  Checking for blank is performed by "Required" setting only.

Please take a look at the post below.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/DateTime-without-Time-value-will-not-be-saved/t...

[Joseph_Seddik]

@Suvrutt_Gurjar Thanks my friend. I completely forgot about this 😕 I had even liked your input in that post at that time. Thanks for the reminder!!

[Suvrutt_Gurjar]

Hi Joseph,

No worries at all. If you see the referenced post, I too had forgotten the peculiarity around Valid_if even though I had responded to such requirement at least once before. 

On lighter side, we all seem to be going "blank" on "checking blank with valid_if" 😊

[Joseph_Seddik]

that's hilarious 😄😄 

[AJRIGO]

Hi you all. 

That´s correct, few seconds after showing the error message (red one) it saves and go back to the previous screen, very weird in my opinion. 

My issue is not the error message (that is the correct expected behaviour), but the issue is system is saving data even with an error being showed as a message. 

I add formulas too like you suggested, but everything I tried is not working. 

I believe it is because the type of column "URL", if you change the data type it works... Looks like because when you use a "URL" data type, appsheets adds a text "http://" even when column is not filled (I mean when it is blank). So, for me, it looks like system understands that "http://" is some data filled, but after saving it, error message is displayed but system saves it anyway.  

[Suvrutt_Gurjar]

Thank you for all the updates. I had tested it with URL column only and it worked as expected even with that initial default http:// content.

I think it may be good for you to connect with the Appsheet support team. Hope you have ensured there are no other settings in your URL column. 

[AJRIGO]

Not working at all, even with that. I really believe that is a bug. In this case who should I report about it? Thanks guys.

[Suvrutt_Gurjar · Accepted solution]

Please try at this page

https://www.appsheet.com/Support/Contact

Would appreciate if you post back any solution you get for the benefit of other community members.