Use make.com to fill excel

Hello,

"How can I add a new subitem and simultaneously create corresponding fields based on the number of subitems?

Currently, I directly add 15 default subitems, but if I only enter one, there’s too much blank space."

[Subitem]

[Google sheet original file]

[Google sheet auto filled by make.com but too much blanket]

Best Regard ,

Vino

Welcome to the Make community!

One way of doing this is you can delete all the empty rows using a Repeater module with the “Delete a row” module.

1.

Please share screenshots of all the module fields and filters? It would really help other community members to see what you’re looking at.

2.

Please export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826

Uploading it here will look like this:

blueprint.json (12.3 KB)

3.

Please provide the input/output bundles of the modules by running the scenario, then click the bubble on the top-right of each module, save the contents as a bundle.json file, and upload it here into this discussion thread:

Screenshot_2023-08-29_100800

Following these steps will allow others to assist you here. Thanks!

2 Likes

Hi Samliew,

only need to delete the row in red frame

the blueprint
blueprint.json (161.2 KB)

the bundles
step1.json (1.5 KB)
step7.json (192 Bytes)
step6.json (15.6 KB)
Step5.json (106 Bytes)
Step4.json (5.9 KB)
Step3.json (4.0 KB)
step2.json (17.0 KB)

Other step as following cause one post can only approve 10 links
step8.json (328 Bytes)
step13.json (42 Bytes)
step12.json (1.2 KB)
step11.json (5.2 KB)
step10.json (4.9 KB)
step9.json (488 Bytes)