stef. idea

stef_idea

Joined: Tue Mar 07 10:35:29 UTC 2023

My Posts

Latest Posts

Re: Help in making queries
i am holding on, until i can show to the boss the db...not before next week..so i'll come later with more info!
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
@Fred ahh great..it was easy!
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
also i am thinking it would be good to be able to export datas when they start to get old, and be able to see it again in needed (also with other software on a pc..…
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
customize tables appearance

hello i have a db which is basically buit, in term of graphic/appearance is there any possibility to customize table..i mean shape, colors..and similar things? thanks
- stef_idea
- 2 yrs ago
- 1reply
- 164
- Get help
Re: Help in making queries
by the way, is any customization of the table possible? i mean shape, color or whatever?
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
the product list for now can reach 50..and there isn't any kind of sort..they are all sushi products..each box it's a meal itself...could be ordered by sold and return anyway the 6 records limit can…
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
for the table that don't respond to query, the opverview Does it have sense to keep it there I am thinking when there will be hundreds or thousands of records...…
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
@Fred ok so better to do not use it now then
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: Help in making queries
@Fred I have seen the new view..the code you are suggesting is already there? For what i see It seems just what i need!!Great! One question, will be possible if clicking on one row of the subtable…
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs ago
- 14replies
- 193
- Get help
Re: how to project this db
@Fred you are right!
- stef_idea
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@Fred
- stef_idea
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: how to project this db
@Fred i'll try t look at it
- stef_idea
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view

1 2 3 4

Welcome to the Ninox community

stef. idea

My Posts

Re: Help in making queries

Re: Help in making queries

Re: Help in making queries

customize tables appearance

Re: Help in making queries

Re: Help in making queries

Re: Help in making queries

Re: Help in making queries

Re: Help in making queries

Help in making queries

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Re: how to project this db

Overview