DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

Is this even possible with DaDaBIK??

Posted by ChrisG 
Is this even possible with DaDaBIK??
July 08, 2016 12:56PM
I am using DaDaBIK is 7.3.2 released on 07-06-2016
PHP Version: 5.6.23
mysql version: 5.5.47-MariaDB
Web server: Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips PHP/5.6.23
Client: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0 OWASMIME/4.0500

I am attempting to create an inventory type program to keep up with items so that we know how many of each we have.

Is it possible to create a form for "adding items" and "removing items" in such a way as to increment and decrement the quantities field for the products?

My thought would be that the two forms would interact with say a "products" table.
Re: Is this even possible with DaDaBIK??
July 11, 2016 04:24AM
Any ideas on the topic???
Re: Is this even possible with DaDaBIK??
July 11, 2016 04:29AM
Hello,
the question is not very clear to me; can you provide more details? Which are the fields of those forms and the related tables? What does a user actually do?

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Is this even possible with DaDaBIK??
July 11, 2016 04:49AM
I am still in the process of setting up tables in the DB and also the forms in DaDaBIK... so I can set them however is needed.

My end goal is to have a form that we can use to "add" products to the DB and a form where we can "remove" products. I know that we can use the "search" form to lookup products and then should be able to see the quantity of that product that we have.

I saw the Demo ERP that you have on your website. I'm guessing this is similar to that... except I do not need to invoice anyone. We will use this internally to keep up with our inventory.
Re: Is this even possible with DaDaBIK??
July 11, 2016 08:33AM
Eugenio,
I've built forms similar to what you have used in your ERP demo.

I would like to be able to use a form to change the quantity of the products.

Example:
If I receive a shipment of 10 printers.
I enter the products into the database using the form.
When I do a "search" for the printers... or a "Show items"... I can see I have a quantity of 10.

Now... one of my techs need to take a printer or two for installation purposes.
I would like for the tech to be able to enter the quantity of printers he is taking without him having to manually change the product quantities field. So... if he is taking 2 printers... he would enter qty. 2 on his transaction and it would update the product quantity to 8.

I hope this makes more sense.
Re: Is this even possible with DaDaBIK??
July 11, 2016 01:21PM
So it seems you want a sort of calculated field (quantity) in a table, based on the number of records you have in another table. It is not a built-it DaDaBIK feature.
What you can do is to create a MySQL VIEW that represents the data you want (computing quantity based on the transactions table) and then install the VIEW in DaDaBIK.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Is this even possible with DaDaBIK??
July 15, 2016 08:42AM
Thanks for the info Eugenio. I think that is a little over my head though.
Sorry, only registered users may post in this forum.

Click here to login