I am trying to add more information to an existing data entry. I tried using the ‘update’ logic from one of your videos but I’m not getting the desired outcome. I also tried to work on it on my own but something is still going wrong. I’ve attached a screenshot of the logic I used, could you tell me where I went wrong or point me in the right direction?
What is the desired outcome and what didn’t work?
I am making a player database where coaches can add new prospects and their evaluations to the data base. I need to add information to an object (player) in my table. Essentially there is an initial “entry” that users make to save a new player in the database. I am trying to make it so they can make an additional “entry” to that same player if they want to. I don’t know if there is a way to add the new entry info to the same column or if I have to make new columns for each entry. What you’re seeing in the screenshot above is me trying to save the second “entry” as new columns but it’s not saving. Or should I make a duplicate data table for each new entry and create a relation between each corresponding column?
I have to make new columns for each entry
Definitely no. It’s bad practice.
What you’re seeing in the screenshot above is me trying to save the second “entry” as new columns but it’s not saving. Or should I make a duplicate data table for each new entry and create a relation between each corresponding column?
We could make it work using
Dynamic Schema Definition but I don’t think it’s the right decision.
I do not clearly understand the situation at all. But if the information you try to add looks like an entity that could exist independently - we could manage them as relations.
Or you could store this information as JSON columns, and edit/extend it whenever you want from your logic.
Does it make sense for you?
Ok so I’m basically trying to add another recording of the same property, in the same object, through ui builder. So in the screenshot you see there is one record for the property “BatSpeed” for that object in the data table. It’s 55. I want to be able to add another record of that same property to that object. So if I add another record it’ll say 55;45 and if I add a third record it’ll say 55;45;65 and so on. Does that make sense? And is that even possible through UI Builder?
Hi @MaCcalia_Swinton ,
Your idea will not work for the INT data type column. I would suggest you change the datatype to the JSON column.
Ok I will change the column data type. How would I build the logic for this operation in the UI builder?
We were able to add another entry using this code: