Auto Populate Fields on Table View, Concatenate Values and Auto Number Increment

[Cantobravo]

Hello to everyone, I hope someone can help.

1. I have been trying to auto populate a field on Table View Design when another field is chosen.
   For instance, I have a relatioship Customers > Projects
   Each Customer has many projects. I can chose the customer when I create a new Project.
   For Each Project I have many Tasks. I can choose the related project when creating a new task, but I would need to auto populate the customer name related to that project.
   I want to do this on a Table view, and not on a form view

2. How can I concatenate two fields, such as First Name + Last name and create a Full Name field automatically after filling Name and Last fields.
   In this case, I can also work on a Form View instead of Table view, but if I can get help to add using the Table View it would be great.

3. Is there a way to create a unique default number for ID everytime I create a new Customer, or Project or Task on Table View?
   I am working with MySQL, but I think I made a mistake using CHAR(45) type for the IDs, and now I am worried that changing would affect relationships and it would mess the whole thing. Perhaps using an Action on the Table View Default number would be easier.

Thanks in advance for helping.

[ConorWebb96]

Hey @Cantobravo,

Question 1

You won't be able to do this two layers deep on your relationship. However, you can do this on your project view since the customer relationship exists there. In this case, the feature you are likely looking for is setting your view columns to read-only. I've attached a screenshot below showing how you would do this.

When referencing this view on the design screen, you can change the labels to make the columns more readable.

Question 2
You can use a formula column or create an automation that stores the first and last names to a new full_name field.

Question 3
I'd recommend doing this at your database level. You should be able to change the structure of your database. Any changes you do make. Just refetch the tables, and Budibase will pull in the updated schema with your changes.

I hope this helps.