Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
stef. idea
stef_idea
77
2
0
Joined: Tue Mar 07 10:35:29 UTC 2023
Follow
My Posts
Latest Posts
Re: how to project this db
@stef. idea UPDATE! I didn't know that there is a app for NINOX..i installed it now and form the app the barcode reading works! Good Things. I was trying the multiple reading...…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred it could be a possibility. Boss said that she would like to have the driver update inrealtime the db..but for what i have seen this possibility is only theory..…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
aahh i miss this notification of the new db..i am gonna try it. Meanwhile i was trying to see about the barcode reading in android. Ninox doesn't says about android/apple..…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred i was looking at it yes..one question is to possible tyo have a kind of form (like those in access for example) where i can select form a dropdown menu the client,…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
i am looking at it, i should need to introduce more parameter..in that table there is time and sold/return But if i want to introduce in addiion to these, client and product id?
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
ok thanks for claryfing...hopefully ninox can sort the problem For the graph/statistici the table where start from is MOVIMENTI i suppose? From this table we should make some query Ideal would be if…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred i have contacted them..just tell me, with apple, you didn't need to do anything special to have barcode reading, right?it just works? Ok how can we proceed now for data analysys, graph..…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
now seems theproblem is the barcoding readin on a smartphone. I am using android and have installed a barcde readin app. When i go to the cusotmer id field for example...…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
ok much better.. One thing: after some test seems did not work anymore correctly..but i ll test it more So i think this is a good starting point for doing some statistics
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred mmm good question...asi think the return items should not be so big, may be the multiple scanning should be the best solution..and the aim is to have less and less return....…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
ok i could give a go... the kitchen seems very smart, i have 2 possibilities to insert product, both with scanning right? the delivery i still see it complex for the operator that works on the fly…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred just uploaded..i'll have a look tomorrow, that it has many new things to see..i had just give an eye for now!
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
i don't know really how many clients, i believe that 50 is even overestimated..but she think for the future nd she is confident probaly....anyway even 30 on a smartphone it s not nito deal with it
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
Ok.The dropdown (or radio) with 100-150 client on a mobilephone (the operator is moving around and will use a smartphone) it isn't very hand. He should at least use a search field inserting 2,…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred for what i undertand those fileds in the new table don't work with barcode reading right? i spoke with the boss and she really want to do as less thing as possible.…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
i had an idea about the barcode I actually don't need a table for client and a table for product In the SALES table i can just insert what i read from barcode..whic is the real name..…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
just to specify more..it is not a need to know to what order belong that return..in any case. i understand perfectly your point to "save "records..and this was my concern too..…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
there will be 1 or 2 persons using the db in general. It will be 1 at the office in the morning, inserting product going out, and then the operator that is out for deliver will insert the returned…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: linked table marked red in field list
@Fred ok so i might just delete the last part, the broken one
stef. idea
stef_idea
2 yrs ago
1
Get help
Reported - view
Re: how to project this db
the whole db. I am asking if it structured enough good to obtain report and keep data for some years. Also..i would need to input client name and products by scanning a barcode (with smartphone may…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: linked table marked red in field list
i don't know what is supposed to do, that was linked to th einvoice field which i don t use anymore..can't imagine what wold this function would be used for
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: linked table marked red in field list
@Fred ahh right. Well that field it is not anymore there as i don't need. I think i can delete the whole string?
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
@Fred yes i correct it as i said in my last post..and this is e reason why year don't work also a part that...do you think is it a good structure?it seems so o me now i need to create more able for…
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
that's it yes they are not dynamic now, both month and year p.s. just disvoered that if i take away the year it works..the problem is that the simple choice get as value the id number of the items.…
Attachment
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
Re: how to project this db
let me add..work fine in your table..in mine i don't get any total ever..always 0
stef. idea
stef_idea
2 yrs ago
Get help
Reported - view
1
2
3
4
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics