0

real time link between local DB and Cloud DB

Hi there,

with the barcodeScan I can scan a barcode via my mobile app and place the barcode info in a field in the mobile app.

How do I pass this info over to the app in the Cloud, preferable in realtime. Is that possible at all ?

rgds

Leo

11 replies

null
    • Fred
    • 3 wk ago
    • Reported - view

    Is there a reason why you can't use the cloud DB in the app?

    If you have to use an offline DB, one way would be create a button that exports the updated records then emails them to a gmail account that you can setup with a middleware to then process any email/attachment.

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       Hi Fred - if what you mean is that I should download the DB to my app and run it here, then yes that would only give one problem - namely if the DB is a multi user solution, then others cannot access the solution, or if the DB resides both places I will have a sync problem.

      If - on the other hand - it is so that you mean that I can have a window from my local DB into the Ninox cloud and then from the ninox DB I can take advantage of commands only for mobile (as barcodeScan) and at the same time update fields in the multiuser ninoxcloud DB. Then it would be ingenious, however, I am afraid that this is not what you mean. If it is so then I would be happy to know how to do it.

       

      regards

      Leo

    • Fred
    • 3 wk ago
    • Reported - view

    If you have a public cloud account, you can access your DBs through the app. Once you login in the app you will see your cloud workspaces. You can then interact with your DB in the app.

    The cloud DB is already set for multi-user. You just have to have a different login for each user. So someone can be in the iphone app, another on a computer browser, and another on MacOS app.

    Then you need to setup your DB to multi-user friendly, but that is another issue.

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       Hi Fred

      thank you for the answer - that will help a lot. I didn't know that, and that is because I have tried to log in from the Mac app a couple of times and have not seen the public cloud content. I will of course try again, as this gives me a lot of possibilities. Any special way to do it either than log in ?

       

      rgds

      Leo

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       Thanks again - I am in now. Just had to chose the workspace. 

    • Leo_Woer
    • 3 wk ago
    • Reported - view

    Hi again Fred - have just tried it, and it works perfectly as I wanted - so thanks again for your great help

    I will mark this as answered

    regards

    Leo

    • John_Halls
    • 3 wk ago
    • Reported - view

    Hi Leo

    When it comes to designing the barcode scanning have a look at the binding options for a field

    The field used to capture the scan should be a text field the uses Global variable in memory. This means that each user can have their own value of scan without affecting each other. Then use a button or trigger to use the scanned data to find or update your data.

    I have just used this technique to record my year-end stock take and it worked seamlessly.

    Regards John

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       Supper John - thanks for the advise 

      regards

      Leo

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       Hi John

      I noticed that you have the index parameter checked - what exactly is the purpose of the index parameter ?

       

      rgds

      Leo

      • John_Halls
      • 3 wk ago
      • Reported - view

       Not sure, it is checked by default. Maybe someone else can shed some light...

      • Leo_Woer
      • 3 wk ago
      • Reported - view

       

       

      Hi John,

      here is the answer from support - it seems that you probably should uncheck it.

      rgds

      Leo

      The index option will if active set that data field to be indexed to optimize search processes in the database. Activating it for one field will then impact performance when searching for other fields as far as my knowledge goes, so you should use this option sparingly, if ever. There is a discussion about this on the forum where a few users share their experiences and findings about the index option if you are interested.

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 3 wk agoLast active
  • 11Replies
  • 67Views
  • 3 Following