Can a form component have some components designated ‘header info’ and others have ‘add’. When an ‘add’ component is selected then a new row is created in the sheet but carries over the ‘header’ info. Time sheet app logs employee hours spent on a job and service code. In a day an employee can work …

I’m not sure I understand what you are asking. Are you saying that you want one row, but to allow the user to edit it if they want to add additional information? Or are you asking if for multiple rows per Job/ServiceCode, but you want some of the values to be automatically filled in? If you have …

Say you have 5 employees your submit for each day. Each of the 5 worked on (3) different ‘service codes’, this means that for the day you’ll make 3 entries for the 5 employees, however if you could enter their name, date and then make multiple entries for hours and service codes you save having to m…

What if you have 3 columns for service codes so each day is a single row?

If you wanted 1 form entry to create 3 rows, then you would probably need to incorporate some sort of script to handle splitting the data. Or maybe some sort of setup in a new google sheet with a query and/or transpose formula. It would get quite a bit more complicated on the back end.

if it was only service codes this would be an option to try, however there are 4 fields that need to be entered for each employee, so its 12 columns, I tried this option and it simply makes the form a long scroll was hoping for a ‘basket’ type function, select employee and date then add hours, serv…

i’ve not written a script, i’ll explore option to have all entries in 1 row then use query to summarize, many thanks

You can have it as sections in a form using visibility conditions. Would it work?

interesting, yes a good option, I can add a switch, ‘add more’ and then display next set of fields to enter, I like it, many thanks.

You can have a copy here of my take on this. [image] Available for copy: Newest form choice, progress bars & joined texts concept Project Showcase Hi guys, as I work with my latest apps, I discovered some tricks that may help with your app design, so I thought it would be…

many thank, this is great, nice resource for design

Add new row while retaining some row cells the same

Ask for Help

ThinhDinh October 3, 2020, 4:40pm 10

You can have a copy here of my take on this.

Topic		Replies	Views
Add a form within a form Ask for Help	6	230	May 13, 2023
User Input Submits to Existing Row (/Choose row) Feature Requests	26	2598	January 11, 2022
Stop form making new rows Ask for Help	2	615	January 8, 2022
Auto populate Identical Components on Adding and/ Editing a row Feature Requests	2	230	September 1, 2020
Date picked to be added to new row and not replace the value in the first row Ask for Help	2	75	April 30, 2024

Add new row while retaining some row cells the same

Related topics