I need to add up +1 to a google doc title

Beginner Questions
, , ,
1

:bullseye: What is your goal?

I need to add up +1 to a google doc title

:thinking: What is the problem?

So i have to automate diet plans, and i recently asked for help for that same project, so im getting the ID and title from that diet plans wich are always named as ‘‘Planning (number) (name)’’

Example: Planning 5 Alana

So i got that last planning ID, title and info, i need to add +1 to that plan, and that plan should be as simple as ‘’ Planning 6 Alana’', every month on a certain date i collect that data, and i have to add +1 per every plan. So from ‘‘Planning 6 Alana’’ to ‘‘Planning 7 Alana’’, same for every person just changing the number.

3

Hey Dobromir,

You can use the split() function to separate the name in an array of words so you can access them individually.

So get(split(plan-name-here;space);2) will get you the number. The you can just {{+}} 1 after it. Just remember to use the proper functions from the menu and not just copy paste what I wrote.

You can use first() and last() around split() respectively to get the other two words.

3 Likes
4

Hey Stoyan,

Thank you very much, appreciate your big help, 10/10!:laughing:

1 Like