How to populate my google sheets according to occurrence from google forms

Unsolved

I am trying to create a finance tracker for myself using Google sheets. My google form takes in the relevant information and then populates my google sheet accordingly. I also wanted to add a feature into the google form where I can put in the occurrence of my expenses e.g weekly rent so I wouldn't have to manually input my rent expense every week. I don't know how to use the occurrence tab to auto duplicate that expense in my google sheet accordingly.

Currently as shown in the image, this is how my form auto inputs the data into my google sheets. For the weekly I'd like it to auto duplicate the rent row to show a weekly purchase, altering the purchase date accordingly. I would like to do the same for Monthly occurrence and so on. Any help would be greatly appreciated!

Posted Jan 7, 2026, 6:57 AM UTC

10
Loading comments…