Mar 25, 2020 06:06 AM
I want to build a function that duplicates the row for each Weekday IF Weekday is everyday or a checkbox that says “Repeat event”.
I am lost on how to achieve this and hope the community a help a poor beginner :slightly_smiling_face:
Mar 26, 2020 02:24 PM
I want to build a function that duplicates the row
If you organized a view properly, you could probably get things filtered for easy copy/pasting. For example, you could (1) make a new view that’s filtered by only the values that need to repeat, (2) select them all, (3) then click the plus icon for a new row, and (4) paste what’s on your clipboard. It might help to paste the values to an external sheet first though so you can adjust any values you need to. Or you could use another view that is filtered for recently added records.
Maybe someone else has an ideas on how you could reorganize your base so that you can leverage formulas, but I haven’t thought of any. Stay healthy to you too.
Mar 27, 2020 09:36 AM
Thank you. I tried to understand the scripting capabilities but there is no way to have a row duplicated?
I could only find a way to create a new row.
Mar 28, 2020 06:19 PM