Hi!
I am trying to build some functionality in my app that uses an action button in the user interface to create a new column.
I am hoping to implement this such that that the users can use a form to create a new row in one table, and that the name of that row can create a new column in a different table. Is there any way I could do this?
Thanks in advance!
You can’t create new columns from an application. Sorry.
What are you trying to do? Maybe we can find a better way.
I am making a dog training app where trainers can update a dog’s “progress report” and clients can view it. The trainers can select goals (from a list) that are applicable to each specific dog. The progress reports include a number value (1-100) to rate the dog’s progress towards each of the goals that the trainer has selected for this specific dog.
The problem I am running into is that I want trainers to be able to add and edit goals on the list to select from without adding a column to a table.
Currently I have it set up such that each goal is named in a column in my “Progress Reports” table, and the value for this goal (1-100) is set in a row, which is linked to the dog to which it correlates.
I am having trouble finding a solution where I can have trainers add goals, and still link the value that the trainer sets for this dog’s progress report to only that specific dog.
Please let me know if you need any additional information or clarification. Thank you so much!
If you are having to add columns, then it’s not a good database design. New goals should be on rows instead of columns.
Think of it this way, if you were allowed to add a column through the app, you yourself would have to go into the builder and modify screens or add components and logic to account for those new columns.
Right. I understand this. I am trying to fix it and find a better way. I made it the original way with columns instead of rows because I was anticipating only using it myself and it seemed easier considering that was the case. I now have others who are interested in using the app with me, so am trying to improve the functionality to make it more usable. Any feedback or advice on how to make this work?
Yeah, this smells of bad design.
Your Goals should be in their own table, one per row in a single column.
If you can add a couple of screenshots that show how your existing tables are laid out, we can probably provide some guidance on specific changes you should make.