How to enable Javascript

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
- 1reply
- 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