SHeets add new row keeps using the formattings of the row abve

[Ruben_Koemans]

Google sheets module Add new row keeps getting the values from my header row. does anyone know how i can prevent this?

[Henk-Operative]

Hi @Ruben_Koemans,

Did you select ‘Unformatted = yes’ here?

Cheers,
Henk

[Ruben_Koemans]

Hi @Henk-Operative ,

I did not since the values in the rows contain links that needs to be clickable

[Henk-Operative]

I understand. Enable the unformatted option (yes) and try to pass the URL as such, this will put the URL in the Google Sheet unformatted but converts it to a clickable URL:

Cheers,
Henk

[Ruben_Koemans]

@Henk-Operative Thanks, it is almost perfect. As you can see in the screenshot below the first column is already pre-filled with a dropdown. when adding a new row this column empties. Any idea how i can fix this also?

[Ruben_Koemans]

never mind I got it. I needed to click on advanced settings and set “Insert data option” to ’ overwrite’

Thanks a lot @Henk-Operative