Is it possible to make a column repeated by the user?

[Shalaw_Fatah]

Issue: How to make your app in a way where you have [date column] and [hours column] and they can be repeated [multiple columns per request] as you work for more than a single day and the client wants to know how many hours you have worked per specific dates?
It’s easy to set up the App for a single day, but can this day be repeated as you like?
Best.

[WillowMobileSys]

Hi @Shalaw_Fatah! Welcome to the AppSheet Community!!

From a data design perspective, whenever you have a large or unknown set of repeating data, you want to think of representing that data in terms of rows - not columns.

AppSheet apps have the concept of Parent/Child relationships between tables. Using your example, you may have an Employee table as the Parent table. And then you track time in an Hours Worked table as the child. You can add an arbitrary number of child rows to the Hours Worked table for each employee and they are linked back to the specific Employee row in the parent table such that when you view that certain Employee, you only see that employees Hours Worked records.

You can find out more about Parent/Child relationships in the article below. Scroll down to the " Expressing Ownership Between Tables" section.

Also, there are some sample apps that demonstrate Parent/Child relationships. You can find a link to them in the Education menu item at the top of this page.

Don’t hesitate to ask if you need more help!

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.