Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Help in making queries
Hello i have a db (many thanks to @Fred ) and now i need to make some queries. In a table where i have a list of "transaction", (sum of products sold and product returned) i want,…
stef. idea
stef_idea
2 days ago
1
reply
19
Get help
Re: how to project this db
@Fred you are right!
stef. idea
stef_idea
3 days ago
Get help
Reported - view
Re: how to project this db
@Fred
stef. idea
stef_idea
3 days ago
Get help
Reported - view
Re: how to project this db
@Fred ok that s it!..is there possibility to sort by sol or by returned? (edit: i find it by clicking on th ecolumn name..it s not the best for average user..…
stef. idea
stef_idea
3 days ago
Get help
Reported - view
Re: how to project this db
one variation for data to display is the list of all the product sold and related return for a date client within a certain time...better than to select the single product The single product would be…
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred thanks..i see now where the error was..i deleted a part of MOVIMENT... I aded again the Total Returned Field..btw how you resize the field? For the rest..…
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
sorry did not make any copy and i don't know how somehting went wrong in gather data field
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred i'll try t look at it
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred @Fred i don't know how long th ebarcode for product...the one whio is there was in the example data! :) anyway seems not so difficult to change if it will be needed
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred i think i'll not be able to start i ton my own!Anyway in v4 i have added the TOTAL RETURNED which seemed to work..but i don't see it anymore in V5. It is not good?
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred i think the way it is now it is not too bad!
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
i see you have uploaded a v5 with some edit in the quick view One thing i could also suggest is th epossibility to choose also "all customer" option. I see tere is nothing about product yet...…
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred ok i don't understand why you have had this idea, what is not convincing you for the driver to scan in ninox?
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@Fred let me understand, with a later import how will be th ework of driver?what actually he will need to do?
stef. idea
stef_idea
4 days ago
Get help
Reported - view
Re: how to project this db
@stef. idea i am trying to go through all the logic of the sum part..but can't figure out yet how to do it..also not knowinf exactly the language makes the thing harder the query should be "select…
stef. idea
stef_idea
5 days ago
Get help
Reported - view
Re: how to project this db
ok starting from your table i have inserted the field Article in QUICKVIEW and i have strated to change the code you wrote for the possiiblities to query also by article.…
stef. idea
stef_idea
5 days ago
Get help
Reported - view
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
5 days 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
5 days 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
5 days 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
7 days 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
8 days 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
8 days 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
8 days 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
8 days 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
8 days ago
Get help
Reported - view
1
2
3
Next
stef. idea
stef_idea
68
2
0
Joined: 07 Mar 2023
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags