Appsheet Episode 93: How to disable previous dates in data entry. Simple Steps!
HTML-код
- Опубликовано: 7 сен 2024
- Welcome to my AppSheet tutorial! In this video, i'll show you how to set up a validation rule in AppSheet that prevents users from entering dates before today. I'll also guide you on how to add a custom error message to help users understand the validation rule.
What You’ll Learn:
1)Navigate to the Data tab in AppSheet.
2)Select the table and date column you want to validate.
3)Enter the Valid_If expression to prevent past dates.
4)Add a custom error message to inform users.
Join this channel to get access to perks:
/ @aris_azhar
Aris, thank you so much for all your appsheet videos! Wouldn't have been able to learn and complete my project without your help.😄
You're very welcome! Glad it helped regarding your project! What's the project about?
@@aris_azharIts a mini school project for my internship company, a part timer scheduler...😀
@@aris_azharcan i ask if it is possible for my default starting view to be employee menu for employee, but for admin i want the starting view to be admin menu?
Thanks for doing this for app sheet..You are till date the best
And thank you for the support brother..it means the world to me! legend
Hey Aris, your videos are really helpful and have helped me a lot. I have a question: after exporting the data to a CSV file, I want the exported data format to be XLSX instead of the comma-delimited format. I've been searching for a solution on RUclips and Chat GPT, but I couldn't find one. My guess is that you can probably figure this out using AppScript or a similar method. I hope you can help me with this.
It is possible to do this only by using the BOT, try this way.
@@sergio_molinari can you please explain this.
@@abdullahazam on google search this: Create and save a file from an automation - AppSheet Help
Hello, I'm new to appsheet. I made a database with a column where i put the dates. I would like to display the dates in ascending order in the PDF report. how can i do that?
how to prevent previous month entry
Valid if:
Month([_thisrow].[date])>=month(today())
I will share my formula that allow you to add and edit only one entry par day.
Thanks to god then to you Aris, this is from your tutorials.
İn valid if:
Or(Not(In([date],
Select(mytable[date],
[name student] = [_THISROW].[name student]))),
[_THISROW_BEFORE].[_this]=[_THISROW_AFTER].[_this])