I have set up a "Competitors List" Title with 12 available spots. I have this mapped to a Google sheet data source that is programatically filtered for different categories.

Some categories may have 8 competitors, and others may only have 4. I have statically mapped the title values to a particular row for each spot. It works great and loads the data as expected, however when I change the list to a category with fewer competitors in the list,

the previous data for positions 5-8 still remains.

Is there any suggestions with code how I can clear that pre-existing text values in the title when there are fewer competitors than the previous category? I'm pretty new to scripting and looking for some guidance.

Cheers
Darren

Thanks MartLeib

The problem is that the google sheet data is written dynamically each time - I have established a workaround in the interim by writing a web scripting function SetText to add a space to each field which visually clears the title then just reload the title.