0

Is there a way for Ninox to create a record from an email atachement or another form

I am trying to find a way to spead up data entry by way of Ninox extracting the data from another document or form to creat a record. Ninox could generate the document even?  I am open to any and all sugestions to try and increase the spead of data entry.

Thank you

8 replies

null
    • Sean
    • 4 yrs ago
    • Reported - view

    Yes, you can definitely parse information out of a document and then add that information to the database. It's kind of difficult to suggest a process based on the small amount of information you provided.

    • GST
    • Stuart
    • 4 yrs ago
    • Reported - view

    Thank you for taking my question.

    As an example I would like to set a standard resume/CV form that has set needed information that I would like Ninox to extract and create a simular record.  I hope this helps explain my question and appreciate the help.

    • Sean
    • 4 yrs ago
    • Reported - view

    You will need to develop the parsing code to extract the information you want and then use more code to copy the information to your database. Normally, this type of code would go in a button. I use these functions for this purpose...

     

    index()

    substring()

    substr()

     

    You can find the language reference here...

     

    https://ninox.com/en/manual/calculations/reference-of-functions-and-language

     

    There are many examples in the forum that explain how to create new records and copy information to them using code. If you get stuck, feel free to post a question.

    • Mconneen
    • 4 yrs ago
    • Reported - view

    You can also use third party services, like integromat, in conjunction with other third party forms services and / or email services.   Depending on volume, there is usually a fee.

    • GST
    • Stuart
    • 4 yrs ago
    • Reported - view

    Thank you.

    I have been able to get a little of what I want using google forms and integromat but I still cant get the multiple choice to work.

    Does anyone have sugestions on how to do somthing liek this with multiple choices?

    • Sean
    • 4 yrs ago
    • Reported - view

    I have zero experience with Google Forms and Integromat. Are you trying to get the value of the multiple choice from Google Forms and then assign the value to a Ninox multiple choice field?

    • GST
    • Stuart
    • 4 yrs ago
    • Reported - view

    Yes that is correct.  I want to make sure the form and the record have the same information and can be chosen with a click and not needing to spell everything out in case of mistakes.

    • Sean
    • 4 yrs ago
    • Reported - view

    When you extract the multiple choice information from Google forms, do you get the values of the multiple choice (names?) or do you get an index number? You can set the Ninox multiple choice field using an array...

     

    MCField := [1, 3, 5]