Create Google Drive Folder - "New Folder Location" is based on form entry

How To
1

Here is my scenario:

I have a registration form and would like to create a new Google Drive folder for participants after registration.

The problem is that the participant should be assigned directly in the correct course folder.

For example:

  • If someone registers for the course in August 2024, then they should be created in the folder “Course August 2024”.
  • If someone registers for the course in October 2024, then they should be created in the folder , and so on.

My question: How can I create the location of the folder based on the course entry in the form? When mapping, only the folder ID seems to be accepted, not the name. However, I do not have this available at this point.

Bildschirmfoto 2024-08-15 um 11.42.40

I look forward to your ideas.

Many thanks in advance

1 Like
2

Hi @Michael_Hein

To solve your issue, you need to proceed in two steps.

Step 1: Search for a folder with Course Name. If not available, create a folder with course name
Step 2: Create a folder with Participant name. Here the location should be the folder ID from Step 1.

Please let us know if you have any other queries.

Regards,
Msquare Automation - Gold Partner of Make

@Msquare_Automation

1 Like