Hello, I would like to know if you have any idea how to solve this problem? thank you
In my Popup:
I would like the user to be able to enter existing order numbers prior to the current date by hand.
Ex: Everything before 2024 (current data/time->YEAR), I’d like the user to be able to enter it by hand in the field as follows: ex: 2023001, 002, 003, etc.
2022001, 002, 003, etc
But I’d like the field to be displayed automatically for the current year 2024:
current date/time formated as 202400Search for DB_Commandes:count
As far as I understand, you are trying to get a 3-digit number no matter the number is? If this is the case, see the demo below to show any number by adding 0s to the beginning:
Simply, you can check the length of the value and format the result as text depending on the length.
First check if it 1. If it is 1, add two 0s if not write another condition:
Thank you , but it’s not really what I’m looking for…
I’d like the user to be able to manually type into an input field an order number older than the current year (2024) → without any automation.
But for orders dating from 2024, these would be automated.
So before 2024
2023001 → (input typed by hand)
In 2024
2024001,
2024002,
2024003,
etc → (input with pre-filled field and 3 last digits automatic counter)
I think it is still the same. When you are populating that field in your form, you will use the logic I showed you. I was using an input to get the number, yours will be automatically getting this number from Search for DB_Commandes:count + 1.
thank you ! but i don’t have yes/no in my input text and number. This is for that reason that i ask you if i need to add a boolean yes/no in my database.
Doesn’t show because there is a yes/no field in a database.
It shows up because in any expression, you created a conditional. Like something is some other thing, or something > some other thing etc. It has nothing to do with a yes/no field in a database.
Of course, I want to add, it will show up for a yes/no field in the database or any condition as well. For example, you can do this and see the box as well: Current User is logged in: format as text: