Recall data automatically
Ciao
Please, I'm asking for your important help...
How can you do it, by typing data in a new field automatically search if these data are already present and, if they are present, call up the whole record for a change?
Thank you all for your suggestions
Valter
Per piacere vi chiedo un importante aiuto..
come si può fare, digitando dei dati in un nuovo campo ricercare automaticamente se questi dati sono già presenti e, se presenti, richiamare tutto il record per una modifica?
33 replies
-
That would be my idea...
Can it be done?
-
-
How is what you describe different than the Find (Trova) field at the top of your screenshots? Enter search criteria and hit Enter key. Then remove filter by clicking "x". The search is across all visible columns and you can add or remove columns by clicking any column header.
-
Thank you Dean for your answer and I hope the translator translates correctly.
I fill in the records while receiving a phone call from customers placing an order for my product.
While typing in the customer's name I need to know if the customer's name is already in the database so that I can quickly call him back, along with all his recorded data. If it is a new customer, I continue to fill in the record for the registration.
The FIND field does not search in this way. If a customer is not present in the database I have to delete everything and start again from the beginning the compilation of a new record. The FIND field is part of the system and I don't think it can be modified in its operation. For this reason I proposed the new solution. I attach other two screenshots in sequence to the first two to understand my need.Translated with www.DeepL.com/Translator (free version)
-
-
Please Dean, tell me what you can do... Thank you
Valter -
Thank you for explaining. Now I understand. I can not think of a way to do what you describe in Ninox. Maybe someone else can help you.
-
Thank you, Dean, for your concern. I hope someone else will help me find the solution.
-
-
Hi Jarder,
so.... I dont know of any way for Ninox to make a dynamic search i.e. show the results *while* you type letter by letter... BUT I do have something similar to what you want (and a bit more generic then the example above)
The "trick" is to use **regular expressions** (regex) and so you can check anything you want
Here is what I did/ my proposal
Create a new Table called "Dashboard". For that tabel create a view in the menu as a "Form".
Now in that Form create a layout element --- a VIEW; create a field to enter the name you want to search eg a text field called "NameToSearch"
In the View enter the code
let xToFind := text(NameToSearch);
(select Customer)[testx(Name, xToFind, "i")]Thats it.
so if for instance you have as customers Charlie, Charles, Charlotte, Bachara, .... if you enter "cha" it will find Charlie Charles and Charlotte, if you enter cha it will find also Bachara (the Cha is in the middle)
-
Hello, and thank you to Nick and Luis...
Both solutions proposed have their advantages and disadvantages compared to my needs.
I'm trying to figure out what's best for my needs. Anyway, thank you again.
Valter -
Ciao, Nick,
Is it possible to search only in the field Cognome Nome and not in the whole table? Screenshot 1
If I fill in the search field with data not present in the table is it possible to create a new record directly with the completed data?
Screenshot 2Thanks for your help.
Valter
-
-
Hi Valter,
In my example, you are looking for e.g. for the customer 'DALUCA' and if there is the customer his name appears in the field below and by clicking on it you are transferred to the customer's tab.
If the customer does not exist, the 'Add Customer' button appears. With one click you can create the new customer record with the searched name 'DALUCA' transfered to the new record.
And yes, it searches only in the field Cognome Nome.
-
Nice coding. Well done!
-
Ciao Nick, and thanks again for your help...
Your example has been very important to me, it has improved my work compared to before.
It's true when you write that "In my example, you are looking for the customer 'DALUCA' and if there is a customer his name appears in the field below and by clicking on it you are transferred to the customer's tab.". it works just like that.But it doesn't work the way you write
"If the customer does not exist, the "Add customer" button appears. With one click you can create the new record of the customer with the searched name 'DALUCA' transferred into the new record.".
The "Add customer" button does not appear and if I press 'Create record' the record is empty.
And also the search for the example, SCREENSHOT 3, BARBINA is not done in the field 'COGNOME NOME' but in the whole table.
The record 'DE LUCA' should not appear.
If you help me to solve these two problems you will do me a great favor.
But I don't know if it's better for you... others might come ;)
Thank you very much.
ValterTranslated with www.DeepL.com/Translator (free version)
-
Ciao Valter,
It works for me the way I described...
Anyway, please re-download the example file from Dropbox. The button 'Add Customer' is now visible.
Also I added a view with the code from @Luis above.
@Dean, thank you!
-
Hi, Nick,
Now it's right!
I'm very happy with the result, now I can fill orders very easily. The solution thus obtained is really effective.
Thank you for your great help.
I also thank @Luis for his advice that finally helped.
And goodbye to @Dean as well.but that's not necessarily how it ended... ;)
Ciao Valter. -
Ciao, guys.
how can I view the date like this?
Thank you for your contributio.Valter
-
Ninox uses the medium definition of the system i.e. Preferences, Langauge & Region, Advanced, Dates
-
Ciao, Luis,
Maybe I misspoke.
I wrote in English to make it clearer to you.
Actually, I would need the name of the day, whereas I don't need the year.
I hope that makes it clearer.
Thank youValter
-
yes.... I understand... as I said: Ninox uses the System Definitions! you have to go do the APPLE SYSTEM and change the way you define data... as said: go to System Preferences, Langauge & Region, Advanced, Dates and choose the format with the icons - see the example below of hwat you get
-
and now I changed the system again to show more verbose data
-
and now I changed the system again to show more verbose data
-
I'm sorry... I didn't understand...
Content aside
- 2 yrs agoLast active
- 33Replies
- 4051Views