0

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

null
    • jarder
    • 3 yrs ago
    • Reported - view

    That would be my idea...
    Can it be done?

    ricerca

    • jarder
    • 3 yrs ago
    • Reported - view

    baron

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    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.

    • jarder
    • 3 yrs ago
    • Reported - view

    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) primo

    • jarder
    • 3 yrs ago
    • Reported - view

    secondo

    • jarder
    • 3 yrs ago
    • Reported - view

    Please Dean, tell me what you can do... Thank you
    Valter

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    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.

    • jarder
    • 3 yrs ago
    • Reported - view

    Thank you, Dean, for your concern. I hope someone else will help me find the solution.

    • Nick
    • 3 yrs ago
    • Reported - view
    • Luis
    • 3 yrs ago
    • Reported - view

    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)

    Screenshot 2020-05-04 at 14.18.39

    • jarder
    • 3 yrs ago
    • Reported - view

    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

    • jarder
    • 3 yrs ago
    • Reported - view

    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 2

    Thanks for your help.

    Valter

    screen1

    • jarder
    • 3 yrs ago
    • Reported - view

    screen2

    • Nick
    • 3 yrs ago
    • Reported - view

    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.

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

    Nice coding. Well done!

    • jarder
    • 3 yrs ago
    • Reported - view

    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.
    Valter

    Translated with www.DeepL.com/Translator (free version)

    • Nick
    • 3 yrs ago
    • Reported - view

    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!

    • jarder
    • 3 yrs ago
    • Reported - view

    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.

    • jarder
    • 3 yrs ago
    • Reported - view

    Ciao, guys.
    how can I view the date like this?
    Thank you for your contributio. 

    Valterdata

    • Luis
    • 3 yrs ago
    • Reported - view

    Ninox uses the medium definition of the system i.e. Preferences, Langauge & Region, Advanced, Dates

    • jarder
    • 3 yrs ago
    • Reported - view

    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 you

    Valter

    • Luis
    • 3 yrs ago
    • Reported - view

    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

    Screenshot 2020-05-18 at 15.16.10

    • Luis
    • 3 yrs ago
    • Reported - view

    and now I changed the system again to show more verbose data Screenshot 2020-05-18 at 15.30.01

    • Luis
    • 3 yrs ago
    • Reported - view

    and now I changed the system again to show more verbose data Screenshot 2020-05-18 at 15.30.01

    • jarder
    • 3 yrs ago
    • Reported - view

    I'm sorry... I didn't understand...

Content aside

  • 2 yrs agoLast active
  • 33Replies
  • 4031Views