Find User here you can look for a user

Ez Database

#1 2018-12-02 19:59:49
Nice job on the app.
Just wondering if you plan to add an “import csv” function? It would be very handy!
#2 2018-12-03 19:39:42
Jroth1234 said:Nice job on the app.
Just wondering if you plan to add an “import csv” function? It would be very handy!

I had not planned to, but since you requested it I can probably get that in there for the next release
Owner of Ape Apps
#3 2018-12-03 20:04:32
Wow, that’s what I call responsive.
#4 2018-12-05 03:39:51
I like EZ Database! Thanks for making it.

Can you add many-to-one support in the relationship field type so that a record with a foreign key to another table can multi-select values from the foreign table and have those multiple values displayed separated by semicolons?

This would make lookup tables more functional.

For example, I’d like to use EZ Database to make a migraine headache log. One table is for the log, and another table is to hold medicines taken, and yet another table is for triggers. One Log entry can have multiple values from medicines and from Triggers. But to do that in the current version, I’d have to add multiple lookup fields to support something like “medicine taken 1”, “medicine taken 2”, etc. it would be much better to have a single “Medicines Taken” field that referenced multiple records in the Medicines table, with each medicine listed in the log separated by semicolons.
Edited by TobyHosterman on 2018-12-05 03:44:10
#5 2018-12-29 14:51:23
OK, I had another thought. How about if you added a "simple query" option, for instance, SELECT RECORDS THAT HAVE LASTNAME = SMITH, where LASTNAME is a field in a table. The = operator could be >, <, LIKE, NOT ...... You would then show all records that meet that criteria. The very first table I built will have about 200 records, so that is what prompted me to ask for this.
#6 2018-12-30 13:21:23
@Jroth1234 and @TobyHosterman I will be working on the next EZ Database update within the next week or so, I will see what I can come up with for these requests!
Owner of Ape Apps
#7 2019-01-03 18:25:32
I have updated EZ Database to v1.4.0. This version adds "many-to-one support" for relationship fields, and the ability to import a .csv into a new table.

It will take a bit more work @Jroth1234 to implement the query feature you requested, but I will come up with something.
Owner of Ape Apps
#8 2019-01-03 20:48:21
Thank you!
#9 2019-01-10 11:21:55
Wondering why the first row from a linked table does not appear when you call it from a different table. Eg. I have a table called plants which lists all my plants. Then I have a second table called garden actions. In this table I record when I watered a particular plant. So instead of typing the plant name, I just look it up from the linked table called plants. However the first row never populates. I had to make it blank and create a new row at the end of the table, so that it would populate. Very strange....