Required Fields doesn't work well

I’m building a data management app for our baseball team.
When modifying a hitting record that has already been entered, an error occurs if the zero item called from the database tries to update it as it is.

Is there any workaround?
I would appreciate your advice.

If I understand you correctly, this is what is happening…

  1. You create a record, it has 0’s in those properties
  2. You make an update to that record and want to use 0’s still in those same properties
  3. The field is set to mandatory and because the record does not change, it returns an error that nothing has been entered

Is this the case?

Thank you for your comment.
Yes, that is exactly the case.
Please let me know if there is a workaround.

Hi Colin, I created a new app again and ran some tests to validate this issue, but the situation remained the same. I’ll share the image with you for your reference.
I’d appreciate some advice. Thanks.

Adalo does not consider zero as a number, I believe that is your problem. Try making it a text field, not a number field and it will work.

Thanks for the feedback!
I see. So this is an Adalo specification. That’s a pity. The text field can’t be used in the calculation, so the user will have to think of another way. I’ll try to find a workaround.

Maybe not make it a required field?

1 Like

YES! I’ll verify if that causes any other problems. Thank you!

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.