rbuschmeyer
Forum Replies Created
-
it is! …and I can attest to the support. The crew is amazing
Thanks, Peter. I think it does.
I think what we will do is use Templates for data management and then the View for people who need to just filter data.
Actually, both. We would like to use it for data entry as well as filtering/reporting.
This database will also track various times of service and other things, so I think it would be best for me to create a join table and a filter report from there.
I think what I was trying to accomplish was to have the “display name” available in the Child table tab views on the templates, but that’s a minor inconvenience.Thanks for helping me through this.
Ok, maybe this is a lack of understanding on my part with regard to how the plugin works vs. other low-code solutions.
Here’s my scenario:
I have two tables, Families and People (People is the Child table)
I need to display the
namefield (from People) AS LastName, Firstname in the sub-table of Families. I also need to utilize this field in other tables like in a similar fashion.I believe what you’re telling me is that I can create a “view” to use in these other tables, but I have no clue how to create that within the plugin or how to utilize it.
- This reply was modified 3 years, 3 months ago by rbuschmeyer.
I can also use the following query to actually SET the data within the column, I just cannot get it to work automatically when the record is created.
Update People SET Name = CONCAT(IFNULL(LastName, ''), ', ', IFNULL(FirstName, ''))Follow-up… the concatenated
Namefiled needs to be visible in child tables so that it can be selected. That’s why this is critical.Kim, in the SQL Query Editor, my original command (without the semi-colon) works perfectly. The issue is getting that query to work by issuing the concat and inserting that data into the
Namefield. (I changed the name of the column to “Name” instead of “DisplayName.” The new column name works file in the Query Editor.What I get is the following error when attempting to use in the Data Designer:
The following ALTER TABLE statement failed
ALTER TABLE
PeopleMODIFY COLUMNNametext NULL DEFAULT SELECT LastName, Firstname, Concat(LastName,”, “,FirstName) as Name FROM People where ID > 0;You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘SELECT LastName, Firstname, Concat(LastName,”, “,FirstName) as Name FROM Peop…’ at line 1
Is there some type of prefix or container that I need to use to make SQL run the command?
Should I use this code in phpmyadmin or in the Design Table dialog?
I believe I may have answered my own question on the issue of the child table display. It appears the “default” template is the one that is displayed in the modal pop-up. Is that correct or would there be another way?