IDK how to use split

How To
1

I have a problem My problem is that I have a Telegram bot that I want to send my gym progress to. And then I have a Google Sheets document with several columns, one for exercises and the other five for repetitions and weight. My idea is that when I’m at the gym, I send messages to the Telegram bot, and it passes them on to Google Sheets so that I can keep track of what I’m doing at the gym. What’s my problem? When I send messages to the Telegram bot, it passes them on to my Google Sheets spreadsheet all in one message .I really don’t know what I’m doing wrong, and I couldn’t find any guide to help me.

image
image1889×483 13.4 KB

image

image
image460×934 37.6 KB

3

Hi @Bocajr and welcome to the Make Community!

You need a combination of get() and split():

  • Split takes a string and breaks it up based on the characer you choose. For example, what you have in you example. The result is an array.
  • get() takes an array (or another object) as a parameter and returns the item with the number you provide. For example, for column B you would use `get(split(3. Message Text;,), 1)`.

You can get more information here: Functions - Help Center and in the Make Acadamy.

L