Hi.
First app using AppSheet. Since USERNAME() is returning blank from some authentication providers, I need to ask for the user name from the user.
I created a table with the fields [Email] and [Name].
The Email is automatically populated so I present the user with one blank required field for the Name.
Since the record is not yet created, the user is able to press Cancel and leave the field blank. I need the user to fill in the Name before exiting the form.
How can I achieve this, please?