Download "Создание no-code telegram бота на integromat и airtables для ведения бюджета"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: КАК СДЕЛАТЬ ТЕЛЕГРАМ БОТА!🐍 Telegram Bot на Python для новичков! by NZT Next video: Мини-урок по AsyncIO

0:05

описание результата

2:00

начало работы с airtable

10:48

смотрим как работают сделанные таблицы

11:48

столюцы rollup

11:53

представления

14:40

описание integromat

15:16

добавление интеграции телеграма

16:50

создание бота в телеграмме

20:44

проверка работы телеграмм бота

21:40

запуск вебхука для сообщений телеграм

22:10

как смотреть что пришло в элементы и что вышло

24:08

описание первоначальной логики распознавания сообщения от пользователя

25:53

распознавание сообщения пользователя по regexp шаблону

28:03

описание логики сохранения данных от пользователя

28:40

поиск в airtable записи через integromat

31:15

получение информации из предшествующих элементов интегромата

32:40

разделение потоков интегромата роутером

33:20

создание записи в эиртэйбл через интегромат

34:48

создание фильтрации на поток интегромата

40:45

создание задержки при выполнении процесса интегромата

42:50

определение record id для элемента airtable

46:37

использование функций преобразования в интегромате

49:40

поиск нескольких элементов в интегромате из эйртейбл

52:40

array agregator и iterator - склеивание нескольких бандлов в один массив и наоборот

56:02

создание кнопок в чат боте телеграмма

57:38

json agregator - создание json из массива

58:25

создание структуры для json

1:00:05

преобразование массива в json структуру при помощи функции map

1:04:13

элемент compose a string, функции преобразования строк

1:07:21

создание ответного сообщения с кнопками

1:14:06

поиск в airtable соответсвия запросу пользователя

1:18:10

хранение состояния пользователя в data store

1:23:36

чтение состояния пользjвателя из data store

1:31:50

обработка исключений в интегромате

1:34:21

настройка автоматического запуска сценария интегромата

1:36:41

как можно использовать полученный сценарий и как доработать его под себя

1:42:26

стоимость интегромата и общий обзор

1:44:26

шаблоны интегромата

1:46:24

возможности подключения телефонов в интегромате

Мини-урок по AsyncIO

Мини-урок по AsyncIO

Channel: BotfatherDEV

КАК СДЕЛАТЬ ТЕЛЕГРАМ БОТА!🐍 Telegram Bot на Python для новичков! by NZT

КАК СДЕЛАТЬ ТЕЛЕГРАМ БОТА!🐍 Telegram Bot на Python для новичков! by NZT

Channel: Gleb [NZT]

TELEGRAM bot. ОБХОД БЛОКИРОВКИ API TELEGRAM

TELEGRAM bot. ОБХОД БЛОКИРОВКИ API TELEGRAM

Channel: nizamov school

1С TELEGRAM. ПИШЕМ 1С ТЕЛЕГРАМ БОТ. sendDocument

1С TELEGRAM. ПИШЕМ 1С ТЕЛЕГРАМ БОТ. sendDocument

Channel: nizamov school

Разработка Telegram Bot на Python. (1. Создание эхо-бота)

Разработка Telegram Bot на Python. (1. Создание эхо-бота)

Channel: BotfatherDEV

АВТОПРОДАЖИ, АДМИНКА, МНОГОЯЗЫЧНОСТЬ, РАССЫЛКА в aiogram ботах

АВТОПРОДАЖИ, АДМИНКА, МНОГОЯЗЫЧНОСТЬ, РАССЫЛКА в aiogram ботах

Channel: BotfatherDEV

Многоуровневое меню для магазина на aiogram 2

Многоуровневое меню для магазина на aiogram 2

Channel: BotfatherDEV

Клавиатуры. Inline Кнопки в ботах на aiogram 2

Клавиатуры. Inline Кнопки в ботах на aiogram 2

Channel: BotfatherDEV

Пишем TELEGRAM бота с ОПЛАТОЙ на Python

Пишем TELEGRAM бота с ОПЛАТОЙ на Python

Channel: Хауди Хо™ - Просто о мире IT!

integromat

airtables

integromat.com

airtables.com

no code

no-code

nocode

telegram

telegram bot

телеграм

телеграм бот

00:00:03

which means we, using the telegram integra

00:00:07

mat and air bubbles,

00:00:11

will get a budget management system in the

00:00:15

most primitive form, but using

00:00:17

funds, a fund is like some part of the

00:00:20

cash that you have

00:00:23

that we can spend on some a

00:00:25

certain goal, accordingly, well, I

00:00:30

will give the most banal examples:

00:00:31

food, entertainment,

00:00:33

training, transport, car,

00:00:37

something like that, and accordingly,

00:00:39

it is assumed that each fund has

00:00:43

some kind of limit per month or per code, it doesn’t matter,

00:00:48

and that’s when we spend something on

00:00:51

for food we allocate 20,000 rubles a

00:00:53

month for food, we spend 1,000 rubles to the

00:00:55

store, we have 19 thousand left, I’ll find it,

00:00:57

and accordingly we can

00:00:59

see at any moment how much

00:01:03

money we have left for which fund, well,

00:01:05

this is suitable for those who want to

00:01:09

save there money for something wants

00:01:12

to control how much he spends on

00:01:13

some things for which he does not know

00:01:15

how much to spend funds is much more convenient

00:01:18

than just counting the move every time

00:01:20

because they allow, on the one hand, in

00:01:23

general, count, I don’t write down every

00:01:25

check or every little thing in check, that is,

00:01:31

you don’t overload with details, but on the

00:01:33

other hand, they don’t provide the

00:01:35

necessary detail, that is, well, what kind of detail do

00:01:37

we want, we have set it and there

00:01:39

will be no detail below this, the first part will be

00:01:44

about how to make this sign in

00:01:48

rtb, the second part will be about how it all works

00:01:53

attach it to Instagram from their third

00:01:57

part, I’ll briefly talk about what

00:01:59

else you can add there,

00:02:00

so let’s go, so I just

00:02:03

registered for this and Ivan you were

00:02:06

literate, so we’ll create mouths was with a

00:02:10

table that will store the

00:02:13

Hondas that we want to have a

00:02:22

start background meetings Russian is to start from

00:02:25

scratch, so they offer us a certain tutorial,

00:02:30

well, I think we won’t use it,

00:02:33

offers to install an application on the

00:02:35

phone, but we won’t understand that either, and

00:02:37

so that means creating it for them and the paladin here has

00:02:40

already been created from scratch,

00:02:43

I’ll make the edge of the tent table, let’s call it funds

00:02:49

so here by default there are

00:02:54

some columns, but we sang with a name, this will be

00:03:01

our name, it’s already a name, then

00:03:06

here we will have a limit on how much of

00:03:12

this fund we have left and, in principle, this is enough for us for now,

00:03:17

then we’ll add a little bit here,

00:03:21

well, of course, let’s assume that we have

00:03:25

expenses

00:03:27

go there and yes!

00:03:34

that we have education shift and our

00:03:42

new entry education

00:03:47

charity for example a car

00:03:59

if someone has a car and there

00:04:02

may be public transport

00:04:04

minibuses all sorts of OSCE electric trains so well,

00:04:10

and for everyday life, of course, everyday life is

00:04:17

communal apartments and all that,

00:04:20

his assumptions go from 20,000 a month

00:04:26

entertainment 10000 per month

00:04:30

education I haven’t changed the type of this

00:04:35

item so custom ice type plank text

00:04:41

doesn’t fit we should have honest

00:04:44

even better money us park number a

00:04:47

currency money excellent

00:04:49

currency format currency symbol

00:04:53

let’s put our hand prestigious I think we

00:05:00

don’t need pennies allow negative for the leopard

00:05:05

if we put the fund somewhere else, that’s

00:05:11

enough, so now we

00:05:16

’ll have it and it’s divided up to 20,000

00:05:22

in the American style,

00:05:24

maybe it can be corrected somehow,

00:05:27

maybe no, I won’t seem now

00:05:30

entertainment 10,000 education 10,000

00:05:37

charity 10,000 car

00:05:42

how much our car squats

00:05:44

five per month, for example, for transport we

00:05:51

have an estimated 1000 and for everyday life we have

00:05:56

1 more example of dozens going back and forth, which

00:05:59

means we have created this, now

00:06:04

we will create those who will spend it

00:06:11

spender dictionary krait empty the apple

00:06:16

pen dors

00:06:26

so that means we will have

00:06:37

I won’t fill out the name now, it means we have

00:06:40

a name here, then we will delete everything, so

00:06:51

then we will have a

00:06:52

nickname, no to them, we will have a

00:06:59

telegram ati

00:07:06

telegram

00:07:07

to find it, it’s just the text that offers

00:07:15

to import, we don’t need it and the nickname

00:07:18

will also be a telegram nickname, but we

00:07:23

we won’t indicate that this is not the mainland,

00:07:29

it offers to indicate something by default,

00:07:32

but we won’t also indicate the fruit,

00:07:36

respectively, these are the people who will

00:07:38

spend, but we assume this man is a

00:07:41

child who believes everyone like that and,

00:07:45

accordingly, this plate

00:07:50

needs to be removed and we will add ours and ours we will have

00:07:54

5 ms this is every fact

00:08:00

every fact

00:08:02

of buying something means we also

00:08:06

leave the rest we delete it means we

00:08:12

have

00:08:13

a name what we bought we will write

00:08:15

for example there I went to the Pyaterochka store

00:08:17

for food then spent thousands in the

00:08:26

amount of the check someone us currency

00:08:30

should also be so it will be in rubles for

00:08:36

so we will have to edit here too together there

00:08:47

cannot be negative numbers it

00:08:52

can be and it can be if someone

00:08:53

returned the money to us for example and it was printed

00:09:06

so it means the name mount then we must

00:09:13

add

00:09:14

when this happened checkbox multiple

00:09:20

single here do it

00:09:23

format normal format

00:09:26

we get up and then indicate which fund it is

00:09:34

link to and a new record

00:09:38

phones to multiple we don’t need here while

00:09:45

one may be limiting the selection of these

00:09:53

but we don’t need to limit this and the

00:09:57

corresponding ones here asks what should we

00:10:00

display display name or nickname

00:10:10

we add a field that indicates who

00:10:16

added it from Conder record spin tires

00:10:23

and multiple is not necessary this is not necessary creed

00:10:28

field Well, I think that these things are

00:10:30

useless, so we will

00:10:35

add them spender is this, this has already

00:10:38

been deleted because we have in these columns

00:10:43

and so it will be shown what is happening,

00:10:47

so let’s see how it works,

00:10:53

for example, a certain person, a person, on February 21

00:11:07

spent the fund for food, so there is no one here, that’s what

00:11:15

I forgot, forgot, no, I didn’t forget,

00:11:21

energy, I just didn’t notice, here

00:11:24

we’ll spend 1270 rubles, for example, here What does

00:11:32

this give us? We can add a paddock

00:11:40

record that roll-up damage

00:11:46

shows related lists,

00:11:53

and with this we can create a grouping

00:11:57

by date,

00:11:59

for example, a bandit, let’s go here, do

00:12:05

a grouping and make taxes,

00:12:14

sort from the smaller to the larger, it’s not much

00:12:18

better for the latter to be therefore from the

00:12:20

larger to less and so we

00:12:22

will have the amount, what are you date you

00:12:24

spent 100 rubles if here they are

00:12:26

satisfied additional entries here the

00:12:29

amount will increase and we will add another

00:12:36

buy background so that you know in which span remember

00:12:41

that everything I write is in order to know in which

00:12:45

you go what We have a

00:12:53

football group, then it doesn’t matter in what format, so that

00:13:00

means we spent a total of 1270 on food,

00:13:02

well, logically, 1 entry and this is what we

00:13:06

spent, you can add

00:13:10

a calendar here and it will be

00:13:12

displayed on them every day, I’ll add how much

00:13:16

the film costs,

00:13:20

go awl we don’t need to set and it felt

00:13:26

but Politova doesn’t need anything again

00:13:30

offers to synchronize with an angle but for us it’s

00:13:35

subtle and this is the look we get,

00:13:46

yes that

00:13:49

means 21 people well people per fund

00:13:52

unfortunate name of the bodies this should

00:13:56

be called went to Pyaterochka

00:14:03

Friday blend ball led tape on in the

00:14:11

calendar it says that he went to get food in the

00:14:14

feed, well, that means we

00:14:18

figured out

00:14:21

who exactly went, we don’t know yet

00:14:24

because the name will be indicated here according to the

00:14:27

telegram, according to the properties of the telegram

00:14:30

telegram, find

00:14:31

the nickname and name, well, with all this, let’s

00:14:38

move on to in the letter

00:14:42

from means I also just

00:14:44

registered pull the basic

00:14:47

workflow well and there we will definitely

00:14:50

figure it out create then they say that

00:14:56

cookies are used create a new

00:14:59

script we won’t use anything

00:15:02

conti this is what it

00:15:08

looks like an empty script

00:15:11

this is the very first entry of which he

00:15:14

suggests doing this is what we need

00:15:18

telegram telegram

00:15:22

by telegram.bot

00:15:25

we're like this category telegram.bot

00:15:28

and so we chose this one asking what you

00:15:31

want to do telegram send

00:15:33

messages or reply edit

00:15:37

message forward delete attach

00:15:41

unpin send audio document

00:15:45

linton here by sticker saw a bunch of everything

00:15:49

we need around which will work when

00:15:53

we send something in telegram

00:15:56

and send it to the ass, well, we have a watch update around us

00:16:02

and then he says that it’s some kind of

00:16:07

web hook and since we don’t have anything, I

00:16:11

press the add button and he says

00:16:16

that this is the name where

00:16:19

to join and he, well, also there is nothing,

00:16:24

we add nothing and it lights up that this is my

00:16:26

telegram.bot connection in which east

00:16:28

since we don’t have anything yet

00:16:32

there and we add the same connection here is

00:16:37

the name since we have one as if I’ll

00:16:41

leave it in this, they suggest introducing

00:16:46

some kind of poker this is how we can take it in the

00:16:49

telegram itself,

00:16:50

there is such a phase, you can find it

00:16:54

either by name or he has

00:16:57

this dog but phase here and here, when we

00:17:02

write anything to him for the first time, he

00:17:05

sends this one, here’s what you can do with it

00:17:08

we need a new year that we

00:17:11

will create and he asks

00:17:15

how we will call it

00:17:18

we will call it int and letter and then I

00:17:40

will delete it so she says okay

00:17:44

now

00:17:46

choose the name of your bot

00:17:51

it should end with bot and in

00:17:56

one word I will name it accordingly also

00:18:01

thunder and quiet noise in the 1st half

00:18:14

God will pay attention to the packages and copy them just in

00:18:19

case

00:18:20

and so he says that congratulations here is

00:18:24

the link to your bot on it I will go to you and

00:18:31

click run accordingly well

00:18:38

nothing happens because it is not

00:18:40

configured for us it does not work says that you

00:18:43

can achieve everything, add a

00:18:45

description of something else, but the most important thing that

00:18:48

interests us is this use is taken to

00:18:51

access

00:18:53

through and honor and api, this is exactly what is

00:18:57

not said in integra mother and well,

00:19:01

naturally they say that there is no need to

00:19:03

show anyone if it it flows and like this they

00:19:06

can remove it from you God but also the link to

00:19:12

the documentation in the bot api

00:19:13

but we don’t need it yet here we

00:19:18

add the poker shakes and press

00:19:22

continue and he’s like oops everything is fine

00:19:26

checked everything is fine and accordingly

00:19:33

I pressed the button for additional

00:19:36

properties and here, for now, the

00:19:37

maximum number of connections is the same number

00:19:40

and we save these the flood fuque now

00:19:45

it has appeared that exactly this year will

00:19:48

happen, and here it is written that this is how we

00:19:55

configured this telegram.bot then integra

00:20:00

maxi it is configured for us, in fact there

00:20:03

is a return address if Well, here you don’t have

00:20:06

to use exactly this, this is

00:20:08

God’s telegram, so it’s lit, show the address, this is the

00:20:15

address at which integra mat lives

00:20:18

messages from the telegram,

00:20:21

well, in principle, this is not so

00:20:24

interesting for us because the integra mod has

00:20:28

already configured everything for us, accordingly, this is

00:20:31

it thing, she will be every time

00:20:34

something happens to

00:20:40

but something happens to the telegram she will

00:20:42

report it further on we will add something

00:20:46

some text stop

00:20:53

look what comes here is the

00:21:08

text parser and it will

00:21:18

actually we don’t care what it is does it

00:21:20

because we just need to see that the

00:21:21

grams were hanging, something comes and

00:21:24

says that we need to choose from and honor or

00:21:34

whatever, but it doesn’t matter, we save it, it’s

00:21:41

lit, that this thing shouldn’t

00:21:46

be the last, but we do

00:21:48

n’t even

00:21:52

launch it at all and he begins to wait for a request from

00:21:56

telegrams and that we have received a new

00:21:58

message, here is

00:22:01

ours, with which we can change

00:22:05

the description of the picture as it was written there and

00:22:07

send some

00:22:12

hello text and see what happened here,

00:22:15

well, first of all, he stopped expecting something to

00:22:18

happen and here there are buttons

00:22:21

that I say, not number buttons

00:22:23

that say how many events

00:22:29

happened, just a text came so it

00:22:33

came alone and here it came that there was

00:22:37

one ban on this set of messages in which there is

00:22:40

one message and

00:22:52

my owl

00:22:54

message we are watching Itachi here is our

00:22:57

hallow text attachments there is nothing Azarova, but there is a

00:23:02

tarot in an unusual format, it

00:23:06

indicates who one of them came from, so it’s

00:23:13

not as if my name didn’t come with the test,

00:23:16

my

00:23:19

name is username and what language I belong to,

00:23:26

accordingly, well, this is the

00:23:32

information with which we can, in principle,

00:23:34

work each when something

00:23:36

comes to us right here through this

00:23:44

pipe, it came that what came here, well, the

00:23:48

same thing came because no, it didn’t

00:23:55

come, the same thing came again that

00:23:57

we wrote in the properties, some kind of garbage, oh

00:24:01

well for us now it doesn’t

00:24:04

mean what kind of logic we should have we

00:24:06

received some kind of message which we

00:24:09

look at what came there if it came

00:24:12

text here the text can be any

00:24:18

which we write down we write down here

00:24:21

went for and fights the tape that is we are writing a

00:24:26

telegram

00:24:29

went

00:24:33

an article about food in the feed and, separated by a space,

00:24:40

we put how much you spent 1270 and

00:24:44

send it and

00:24:46

we need this to look

00:24:50

and write that this is the name of the expenses,

00:24:55

then this is what he will write for the amount of

00:24:58

expenses and then this telegram.bot should

00:25:03

ask what and

00:25:04

what category does this belong to and must

00:25:07

indicate what categories we have, so

00:25:11

we select that this is food and he writes down

00:25:14

that this is the expense it creates, he

00:25:19

indicates that this category and yes, and

00:25:21

indicates that this came from us, well, from

00:25:26

us it looks like this here's who

00:25:31

that's

00:25:32

at rome from such a person and if

00:25:39

we have him, then he creates,

00:25:41

if he doesn't, then he creates such a record as

00:25:44

spender, and if we have him, then he simply

00:25:47

indicates him. Well, in principle, the whole

00:25:50

logic of this bot, let's start doing it

00:25:54

first In fact, we need to recognize that

00:25:57

this text has arrived in this form

00:26:00

or this text has not arrived in this form, for

00:26:04

this

00:26:05

we will delete this and so we don’t

00:26:08

need this and we will create a

00:26:15

text parser that should

00:26:20

look according to the template, but

00:26:23

according to the template, here it is I immediately

00:26:28

stuck there, well, simply because there’s

00:26:30

nowhere else so here we create a

00:26:34

pattern the pattern happens in

00:26:41

the pattern we need 3gp format

00:26:44

for those who don’t know it with the help of

00:26:49

some magic symbols it recognizes

00:26:52

the text this means that the very

00:26:55

beginning of the line this means the very

00:26:57

end such this means that any

00:27:01

number of any characters

00:27:03

this means a space this

00:27:07

means any number of numbers and that’s

00:27:12

all that is, he looks that there should be

00:27:14

some text, a space and some numbers that’s

00:27:18

all ok created well here it is again

00:27:24

I wrote a yellow one, this means

00:27:28

that be careful that this transformer

00:27:32

should not be the last module in the path,

00:27:37

well, I’ll click and Conor just so that

00:27:40

the pilot doesn’t show up, well, it’s clear that it

00:27:43

shouldn’t be the last because

00:27:45

some data comes from here and gets

00:27:47

here, the result is processed nobody

00:27:50

does not wait offensively this url this pair

00:27:54

so we need to add so that this

00:27:58

result is

00:28:00

recorded in

00:28:03

but before we record

00:28:06

the result we need to find out who and who

00:28:10

sent this message and record and

00:28:12

find out which category category

00:28:14

I suggest doing first by default

00:28:18

any one to put and then when but

00:28:21

we ask the user what

00:28:24

category it belongs to, respectively, when

00:28:27

he chooses there and retroactively we find

00:28:30

this expense and change the category, so

00:28:34

accordingly we need to find who it is we have

00:28:37

sent all this for this, we

00:28:40

will create a new integration with this one was an air

00:28:49

typer

00:28:51

and we will look for such printer

00:29:01

yes what you were not connected yet then we

00:29:05

start connecting and here again you need

00:29:10

an account

00:29:15

before the api here is the giner stage kay and she

00:29:22

says that it is your personal care that

00:29:25

needs it and to use their

00:29:30

api table and your personal api key must

00:29:34

is access to all

00:29:37

all the data that you have nativity scenes

00:29:40

so you show it in this drink only to

00:29:47

those whom you trust, well, these are the certificates, I

00:29:50

trust in principle

00:29:52

the appetite of the lectures balls paypal I easily

00:29:59

copy and paste it here and here he

00:30:10

is connected ingrid which database is this

00:30:16

who - when registering, I created a bunch of bashir

00:30:21

fables, but we need this for a long time

00:30:23

without a header

00:30:27

because the language one will call and add it and it will

00:30:30

burn out which database is up to the plate

00:30:33

and the plates, that’s exactly what we have, we

00:30:36

select stenders

00:30:38

and what is the formula here, the formula is how it is

00:30:42

searched

00:30:44

now let’s see how this one should search

00:30:46

like this, but we don’t need it, we have a

00:30:53

telegram id

00:30:55

telegram id should be from who it

00:30:59

came from so

00:31:04

the gram pass is

00:31:07

equal to and here we insert from who it

00:31:14

came from,

00:31:15

which means look here at all the nodes that

00:31:18

were there before they show their

00:31:21

information here here's the red one, this is what the

00:31:26

text is Arsen apartment for the party here is

00:31:30

Asenka this telegram.bot

00:31:32

and now we have this information that

00:31:34

I already looked at then message from from whom the

00:31:39

latest data is shown here who

00:31:42

it was for well the last and why did

00:31:46

I launch it once so here for now some data

00:31:48

will show that the ID code here is this

00:31:51

adige nickname from whom it came, which means the Yiddish nickname

00:31:54

must match the telegram and so on.

00:31:59

we clicked here and now instead of

00:32:03

this block of blue court it will be

00:32:05

substituted go telegram and here the

00:32:10

bus will check that the

00:32:14

telegram matches these with this or not sorting is

00:32:17

not needed limit we only need one

00:32:19

because there will be no more and we create okay

00:32:24

great means that We do further,

00:32:29

we may or may not find such a record,

00:32:36

and here a

00:32:41

tool like a router comes into play;

00:32:45

it takes the information and

00:32:50

divides it into several streams.

00:32:53

Unfortunately, there is no such thing here that several

00:32:55

forgings of streams are mixed into one, but

00:32:58

there is a way that they are divided

00:33:00

into this router will make two streams

00:33:04

in one stream, we will check that if there is

00:33:06

no record found, then we will create it in

00:33:09

another stream, we will use the

00:33:13

already found element,

00:33:15

so we will create the first stream, that if there

00:33:18

is no record, then we need to create a critical

00:33:24

record and now it will think and ask

00:33:28

what kind of cry tariqat do you want to do the

00:33:31

same thing antey here is my base the same

00:33:35

speedors

00:33:36

and so he got it by IP and all the names

00:33:42

means name we will have what we

00:33:45

get from the telegram from the telegram we

00:33:48

get the last name separated by a space

00:33:56

wool

00:33:57

well I have it’s written all in one, but

00:34:00

usually it’s a warm-up, here’s the telegram ID we

00:34:04

’ll insert, why we were looking for the ID, the nickname we’ll

00:34:10

insert is the one that also

00:34:14

transmits the

00:34:15

telegram to us, this is the grain and it

00:34:20

will be possible to find some user using it if

00:34:23

he’s someone unknown added well or it

00:34:26

will be possible to filter by it, so that

00:34:30

means we don’t need these mts smart

00:34:37

forest, we need even more before that, we have

00:34:39

enough to

00:34:44

create a record, and now on this

00:34:48

wrench, if you click, then we can

00:34:50

find out in this way to add some

00:34:56

restrictions with this filter and here the name,

00:35:04

well, we’ll write and well, spender

00:35:10

and what are the conditions here, provided that

00:35:18

Secchi records have arrived and we look at the

00:35:22

total number of battles, well, the number of

00:35:25

records that he found,

00:35:28

it should be equal to zero, a

00:35:34

new quart here you can choose from a bunch of

00:35:38

everything that exists does not exist contains

00:35:41

did not delay but we have by default

00:35:44

quartus then this should be equal to zero

00:35:46

okay, accordingly, if we have this

00:35:51

search here and find that we do not have such records,

00:35:54

we will simply create this in everything and in

00:35:57

all other cases we will

00:36:02

create a record this friend

00:36:05

who sent it to us, but for now we will

00:36:09

only check that he creates a record again,

00:36:18

I send a telegram, I have already sent

00:36:24

this thing, it has not yet been processed.

00:36:39

the message says that we have

00:36:43

unprocessed requests here, how about you

00:36:46

work with them, and here

00:36:48

the question is either new sheets, but I don’t want, I

00:36:52

want to process something that I

00:36:53

have already sent and process existing ones,

00:36:57

and here it shows, a telegram

00:37:00

request has arrived and that’s all over and what did

00:37:11

we end with this

00:37:21

ended with this because I don’t

00:37:24

transfer anything to the pattern I

00:37:28

forgot completely here we also need to

00:37:30

add

00:37:31

and fly off here we also need to

00:37:33

add from what to apply this template the

00:37:36

template that we created and we

00:37:41

need to try it on, here we are, the abomasum that

00:37:43

came from telegram, the

00:37:48

text went for food in feed 1270,

00:37:52

this is the text and we will

00:37:56

process it with this template, then we

00:38:00

will try again the same text

00:38:11

with a walk for example for 500 rubles

00:38:16

took a walk about launching ran vans the process is

00:38:27

known and from hop hop hop hop hop and

00:38:30

got to this let's see what

00:38:35

happened here here input you were alone went for a

00:38:38

walk this is what came to him

00:38:45

quantity 1

00:38:46

amount of text here from 1 this is group 1

00:38:50

went for a walk with 2 this group is 2,500

00:38:54

rubles, well, where did these groups come from,

00:38:57

these are the brackets in our request, this is this

00:39:01

group 1, this is this group 2,

00:39:03

that is, without these brackets, he would

00:39:07

also determine that the template is suitable, but he couldn’t

00:39:09

bear to have this text in these groups, well, here

00:39:14

it is We got it all right, but we do

00:39:17

n’t need it yet, let’s see what happened here, it

00:39:19

means there was an input ban, but that’s what he

00:39:23

found, you were spender

00:39:28

out put that all set of bangles 0, he did

00:39:31

n’t find anything here in the router knock knock

00:39:35

knock and now it came to court it didn’t go to court,

00:39:38

but because if something went wrong, it

00:39:41

came here because there are from singles, which

00:39:43

means input bomb what he found and

00:39:46

out put name created

00:39:48

what we had on telegram IT what

00:39:51

was the nickname everything was fine pulled out the ID

00:39:55

is the

00:39:56

identifier number the records and the time when

00:40:00

all this was created everything looks great here,

00:40:03

let's go see what we have in

00:40:06

rtb and in vr you were these few

00:40:09

records were already created when I created

00:40:12

the table,

00:40:14

well, here is the record that we need, he

00:40:18

created these things for us are not needed and

00:40:21

we will delete hit all the selected entries, let's

00:40:28

try again now, well,

00:40:36

this time we will make it create a new

00:40:42

entry in expenses, but we need to wait for

00:40:45

grammy so that if we don’t have this

00:40:48

user, it has managed to be created,

00:40:50

so that means we are looking for slip here is here slip

00:40:59

let's wait 2 seconds two seconds with vodka

00:41:07

here we are waiting, what if suddenly it is not there,

00:41:10

why are we waiting because from here there is a flow of

00:41:13

ships and ships here it is

00:41:16

being created and here we are waiting until it is

00:41:18

created if it is not there if it is then

00:41:20

it is here this filter is filtering, it wo

00:41:22

n’t go here too closely then they will

00:41:24

go here for now when we would be in vain then

00:41:30

we’ll be waiting for these two seconds in vain but it’s

00:41:36

okay but I’m in a hurry

00:41:40

accordingly here we also

00:41:45

create

00:41:47

a record and what kind of record we create as the

00:41:55

base one again we choose

00:42:00

we select the same table and this time

00:42:03

we create this mousse here we directly compose it here,

00:42:09

this is the text parser for parsing

00:42:12

this is the first group this went for a walk

00:42:16

this is the idea in the 2nd group 500 of this and

00:42:18

mount we add 500 to then we

00:42:22

indicate from in the power of a gram, this is

00:42:30

the date and,

00:42:33

well, that’s where we opened it on the message,

00:42:36

add a fund fund, we add it for now

00:42:41

just by default, so

00:42:47

here we need a door card index,

00:42:49

the card is taken from here, for example, here’s the

00:42:52

entertainment

00:42:53

we spent, well, this is the default fund

00:42:57

which will be set permanently, then

00:42:59

we will rewrite it, which means

00:43:04

across the url here we will get a link to

00:43:09

this

00:43:11

record

00:43:15

and here we will take the last part of it, insert it like

00:43:27

this, added

00:43:32

spender, but from spender we have something to

00:43:36

take and find the record, we will take from the

00:43:40

search this one, go and Well, in principle,

00:43:55

we should create a record, so

00:44:02

we’ll see what will happen now.

00:44:27

I went to the cinema, but thousands of rubles, for example,

00:44:32

so here we launch ran monsoon again

00:44:36

says that there is already a message to

00:44:38

process or something new to know since I

00:44:41

just sent it 1 process so

00:44:45

he got here came here the forerunners are

00:44:48

waiting and now he got to the court

00:44:51

excellent means here here but here

00:44:56

one unit all one unit there is nothing here

00:44:59

means this filter worked he didn’t

00:45:01

come here because he found our spender

00:45:04

and me so let’s see what it came here,

00:45:12

I went to the cinema, thousands of rubles, the date

00:45:15

was substituted for the adige fund,

00:45:21

the nickname was only indicated, this one is going to go, no one is going to buy, let's

00:45:23

see what happened here, and

00:45:29

so these, too, were already created, this is what

00:45:31

I did to show what is

00:45:33

happening, and now I went to the cinema,

00:45:36

the name was transferred normal amount

00:45:39

to transfer well 21 2 21 everything is as it

00:45:43

should be the entertainment fund as we

00:45:46

planned and spender Stepan Galina everything

00:45:49

turned out great just these

00:45:52

things I’ll delete well

00:45:54

for now I’ll show the grouping from by date

00:45:58

here today’s here the amount you were born according to the

00:46:02

funds is empty than zero rubles dust on

00:46:07

YouTube and yes, the calendar was also

00:46:09

added here, okay, so that means I’m deleting the

00:46:14

first 3 entries,

00:46:16

but we are not

00:46:17

needed, that’s great, so here, so as not to

00:46:26

wait

00:46:27

again, let’s try to add a formula,

00:46:33

so if

00:46:37

where does the farm come from, here I

00:46:40

added that data which, in

00:46:42

principle, we have already

00:46:43

calculated from somewhere, but we

00:46:46

also have tabs in this in this

00:46:51

employee window, and here these are the

00:46:53

main functions and in fact with candles,

00:46:57

then

00:46:59

there are mathematical functions, they are considered, there are

00:47:02

text and binary functions, here is the replay

00:47:06

stream,

00:47:07

well, dad waiting under this so the date

00:47:10

is considered for working with arrays something is

00:47:15

considered and

00:47:17

integra mat you can see how many

00:47:19

operations are left

00:47:21

and how much data transfer we have

00:47:27

left so but we need a general means

00:47:32

if Gessle kahoon

00:47:43

then numbers bonbon this is dirty

00:47:51

equals no not equal to zero

00:47:57

then we wait two seconds and if it is not

00:48:02

zero then we don’t wait for anything

00:48:05

because nothing is ok what to do next means

00:48:16

in general about how the integra mat works

00:48:18

here it’s already clear where to start where to

00:48:22

dig so I’ll now add a storage to

00:48:28

which we will write go for the records that

00:48:37

we just created, then do

00:48:40

these records, this is the

00:48:42

logic that we created this

00:48:47

record, then we send to telegram,

00:48:52

send to telegram the question that

00:48:56

which group does this belong to

00:48:57

and accordingly show buttons with

00:49:03

our groups and the user must

00:49:06

select one of groups that it

00:49:08

belongs to

00:49:09

and we will retroactively rewrite this

00:49:12

created record, what is there, well, such and

00:49:18

such a fund, and to do this we

00:49:20

need to save the last record in order

00:49:22

to understand which record the

00:49:25

user’s response will relate to, and so

00:49:29

now we need to get a list of all

00:49:31

EU funds and this is apple to draw

00:49:36

buttons in the telegram for this I

00:49:40

add one more mouths bells

00:49:44

network of rivers and here everything is the same

00:49:51

phantom here without so the plate

00:49:56

funds and formulas what formula no

00:50:00

conditions we don’t need so we don’t

00:50:04

need any sorting as we wrote there that’s how it

00:50:07

should be displayed, let’s set

00:50:11

a higher limit, we don’t know how much it will be there,

00:50:13

we need it all with flour,

00:50:16

well, let’s see what we have here again,

00:50:22

we start the romance again,

00:50:26

it’s waiting for our message

00:50:28

[music]

00:50:31

we’ll write something, I bought a moped for

00:50:38

how much and how much the mopeds cost from 40,000 missiles,

00:50:46

so he already clicked through everything while I was

00:50:49

switching, and here he

00:50:54

stopped and what is he writing to us in

00:50:58

people find files for one parameter

00:51:01

cyst resin parameter down with minimum value

00:51:04

is 1 and well, it looks like you can’t put a zero

00:51:11

to those and put a zero can

00:51:16

be read for at least one second,

00:51:18

well, I think it’s still better than 2

00:51:20

seconds,

00:51:23

let’s try one more time,

00:51:34

same thing, he went through it and this time

00:51:40

it went fine, here we can

00:51:47

see that the bomb fell and one here

00:51:53

we can see that he bought a moped

00:51:56

wrote everything and here we can look

00:52:00

out put out put charity

00:52:07

transport and entertainment everyday life

00:52:12

car education so well we see

00:52:15

the order is not the one we have

00:52:18

and you were so by the way added bought a

00:52:23

moped for 40,000 so pandas

00:52:28

charity yes well what can we

00:52:35

add sorting of some kind, well,

00:52:38

this is not important, so what is

00:52:43

the nuance here, that one bundle

00:52:46

generates one flow, that is, we

00:52:49

get one message here,

00:52:52

well, when we send one message,

00:52:56

here it is one bamboo and it launches

00:52:59

this entire chain once

00:53:01

if we wrote two messages here,

00:53:02

then here this whole chain would work twice,

00:53:05

and here we essentially have, in fact,

00:53:12

there are several messages, here is

00:53:15

one message, this is charity, 2

00:53:17

messages, transport, the third message, and

00:53:19

yes, that’s all that will happen next behind this

00:53:22

chain,

00:53:23

it will happen Well, that’s how many

00:53:25

records there are, just records,

00:53:27

and we won’t need this, we need

00:53:30

all these records to be combined into one

00:53:35

into one array,

00:53:37

and for this there is a special thing here,

00:53:41

it’s called an array of an

00:53:44

aggregator, here in the tool it’s there like this, that

00:53:48

is, if we we want to

00:53:51

turn several banks into one array

00:53:53

array, then we need to use this,

00:53:56

if we want, on the contrary, to know

00:53:58

the array there are several battles of the we

00:54:00

need to make a titrator and then for

00:54:02

each bank the following scenario will happen,

00:54:04

accordingly,

00:54:10

we create this thing to hook up the vessels and

00:54:16

we start setting it up who we need are

00:54:19

these 10 records praying we need

00:54:23

to find this is what we did so all the

00:54:33

records and we only need the name

00:54:40

like this they have united like this this is

00:54:43

gray this means that this will

00:54:48

happen a few times it’s like one

00:54:51

element that glues together

00:54:54

these 10 banks of mating inside itself and at the output

00:54:57

it will give something else. What should it give at the

00:55:00

output?

00:55:03

First of all, let’s check how it all works,

00:55:07

run it again and write what else we

00:55:16

can buy,

00:55:17

paid for the communal apartment, 5000 communal apartment, that

00:55:28

means here it worked and let's see

00:55:33

what we got here: input ban was one

00:55:39

charity, well, this is our herbs,

00:55:41

I chose the fields that will be filtered

00:55:43

and here is the output gang laden array just

00:55:48

turned into a massive one

00:55:50

and here is one two three four and here is a

00:55:54

charity gaspard everything is as we

00:55:56

need it from we turned this into this and this

00:56:00

and this and this is all we need to connect

00:56:04

in a telegram button and

00:56:08

telegram buttons and this is what it looks like,

00:56:13

which means we either have buttons

00:56:16

that appear instead of a keyboard and

00:56:19

either we have buttons, well not

00:56:24

shown here, which are after the message we

00:56:29

need exactly these kind of

00:56:30

keyboards and to make such a

00:56:33

keyboard we need to create a

00:56:37

Jason object in which

00:56:43

everything will be done in this format, that is, this is

00:56:45

one line in one line there is

00:56:47

something like this, well,

00:56:55

how can I say this and b&b siddiq

00:56:59

it will look like here here is ebcdi

00:57:05

here but I think that we will not do so

00:57:07

that there are several buttons in one line, it

00:57:09

will be enough for us to have something like this,

00:57:11

for this we need to have

00:57:15

transport

00:57:17

charity everyday life here, what else is there

00:57:22

for this we need to do

00:57:26

grayson object for jason objects in

00:57:29

the document there is a special field let's look for

00:57:34

jason here is jason of the aggregate

00:57:42

jason collect jason there is also

00:57:46

jason to xml just realizes jason

00:57:49

parsing jason transform there and jason

00:57:54

well we need to rob that means

00:57:59

where to get the information from this

00:58:02

aggregator ray aggregator, this

00:58:06

structure we don’t have any

00:58:08

structure yet and we will create it here, let’s

00:58:14

call it butane

00:58:16

bottoms and the specification, well, this is just

00:58:24

Jason’s format which will usually be

00:58:27

Jason’s of such a random shape, well, what kind of one do

00:58:31

we need? There is one, but here they suggest

00:58:33

setting it rigidly, which means we need to create

00:58:49

but we need to assemble something like this

00:58:59

keyboard

00:59:02

keyboard type

00:59:04

so type we will have an array

00:59:07

because we need to create

00:59:10

things like these, I’m now creating exactly

00:59:13

this and here

00:59:16

in the array there will be another array in the array of

00:59:23

lines there will be an array of buttons in one

00:59:28

line well We already have

00:59:29

one button for happiness, so it’s quite simple, it

00:59:32

means this array in lines and here

00:59:36

we will add an array of buttons and here we have the

00:59:40

default text type and

00:59:45

we’ll do something default default just to make it

00:59:49

clear it will be multiline nothing is needed

00:59:53

required is not needed and that’s later we

00:59:58

will add that here we also have a

01:00:02

resize keyboard avantime keyboard

01:00:05

so we will add a police port this is the

01:00:12

Russian bard type boolean

01:00:16

because there is either true or falls default with and

01:00:20

recurl

01:00:21

I will note that it is needed and we will add

01:00:26

this one time

01:00:28

keyboard Fontanka side is also a broth and

01:00:32

note with and also recurl

01:00:37

[music]

01:00:39

this is the kind of Jason we got

01:00:45

here and it automatically pulled the date

01:00:50

into the structure here and we need to fill out this template based on

01:00:55

these elements that we found in the

01:00:57

database

01:01:04

here too, by default we

01:01:06

have the Russian port wan time keyboard and

01:01:09

in the keyboard

01:01:11

we must add these elements when we

01:01:14

press just this, it already creates something,

01:01:19

but we don’t need to create it here by hand

01:01:21

every time it should be

01:01:23

different we can’t create it every time, for all

01:01:25

occasions, right now, so

01:01:28

here there is such a map function, it even

01:01:31

means that this array will not be

01:01:34

created manually through this graphical

01:01:37

interface,

01:01:38

but will be calculated on the fly, and

01:01:42

here there is such a function for working

01:01:44

with arrays which is called mek

01:01:49

mek

01:01:51

it takes as input some kind of array,

01:01:54

rips out some element from it and

01:01:57

puts everything into this Jason means which

01:02:01

element 1 should take the element

01:02:05

that we counted here is the

01:02:07

array of this the ray aggregator the last one

01:02:10

it takes in it is name but this is what

01:02:14

we created here is an array

01:02:16

and this is the name we need to wipe

01:02:18

here with our hands on the writer not and

01:02:22

take it from here because this is but the name that is,

01:02:26

in these in this array for each

01:02:29

element he will take it this one here well

01:02:32

here is an example about

01:02:34

a charity, well, okay, now

01:02:41

let’s check how it works, but first

01:02:44

we need to launch it

01:02:47

while I’m still awake, too lazy to come up with it, already went

01:02:53

for a walk again for 500 rubles, here

01:02:58

it went here, here we have this, here’s

01:03:03

a charity,

01:03:05

here it is, they’ve become one array and

01:03:09

what is going on here is what

01:03:16

happened

01:03:17

Jason string well we need this

01:03:20

object there is a small nuance

01:03:23

we have this Jason object that

01:03:26

we need here keyboard this is the

01:03:31

first line 2 3 here they are well an array of

01:03:36

arrays here but this object itself is

01:03:39

wrap the array icon here like

01:03:45

this and at the end there is the same one so that

01:03:51

if we send this telegram directly it

01:03:53

will swear that you sent an

01:03:56

invalid request to the plant and so that this doesn’t

01:04:01

happen much, remove this icon

01:04:03

first and at the end also remove the same icon

01:04:05

for of this we also have a

01:04:20

campus element and a string, it simply converts

01:04:24

the text accordingly, so it just takes

01:04:30

the text and returns it, but since we need to

01:04:34

convert it there we go to the section with

01:04:37

functions with text, so we cut it off,

01:04:43

it can be cut off by a function with about sub string,

01:04:47

in fact, here it is actually that means what is

01:04:52

happening here it takes some text

01:04:55

we indicate the beginning we indicate the end the text

01:05:00

we take the one that came out of

01:05:02

Jason string of the beginning we indicate but

01:05:07

there it goes from zero if you specify zero then

01:05:09

it will be from the very beginning to some

01:05:11

number we need just the first

01:05:14

cut off symbol so we write 1 and

01:05:18

we don’t know what the final symbol is because it’s

01:05:22

different every time so we need to

01:05:25

use one more function this is

01:05:28

links of tapes this length returns the length of the

01:05:33

text

01:05:34

so we press it and the text itself which

01:05:39

it will indicate we take the one that

01:05:44

came to we have the same type of string and

01:05:49

from it we subtract minus

01:05:59

-1 well, from the end one character,

01:06:05

that is, we take this Jason

01:06:08

string, we discard the first character and until the

01:06:12

very end of the line we

01:06:15

also fly off one in total, okay, let’s see

01:06:30

what this will give us again, we run again,

01:06:36

we send and we look at what we have here,

01:06:45

input here is such a text, it’s

01:06:55

not shown that there are these 7 weeks and

01:06:59

from the ceiling to the same text, but

01:07:03

here it’s so good with these symbols

01:07:15

and now I’m sending all this, so we’re

01:07:19

creating a telegram. bot

01:07:22

senta text m then text so it means he

01:07:29

asks well connection this is what

01:07:32

you started doing here he asks where to

01:07:35

send go away go away we take the same

01:07:37

one from where it came to mine and here's

01:07:40

the thought

01:07:41

chrome these such and such

01:07:46

text text we send what what fund

01:07:52

well what fund does this refer to who it

01:08:01

was here it's applied like this portsmouth it's

01:08:14

well this text it should be 1 well

01:08:18

displayed as if it's html or

01:08:21

markdown but we're not here they don't

01:08:23

use that so I put a mark there so the

01:08:28

design was no he chuckles this means

01:08:30

that the person who receives this will not

01:08:33

receive the sound, that is, the message came

01:08:37

more quickly, it was displayed, but the phone did not

01:08:40

vibrate, but this is not necessary, the design was a

01:08:45

preview link, this means that if the text

01:08:47

contains some kind of link to, well, some

01:08:51

Internet page later

01:08:53

the title of this page and the picture will be loaded, we do

01:08:56

n’t need that either, so I went to show

01:09:01

additional properties while reggae

01:09:04

original month means that if we

01:09:06

respond to some message, then we

01:09:10

indicate that this is for this message,

01:09:13

here, in principle, we can add

01:09:15

which message this applies to here we are

01:09:18

neighbors,

01:09:19

well, this is the purpose of the work that came so

01:09:23

ender for the fish markup we don’t

01:09:32

need to

01:09:39

collect anything to collect what to give in response or

01:09:47

there will already be a ready-made text, which means that’s

01:09:49

exactly what we looked at in the markup of the

01:09:52

telegram buttons means inwin keyboard

01:09:56

keyboard

01:09:57

and we need should we make a Ryazan bar, should we

01:10:04

hide that the cyborg should not be hidden,

01:10:08

this custom cura tour after the answer,

01:10:12

well, and other such nuances here you

01:10:19

can add, and online keyboard and

01:10:22

so the message is not the fault and the keyboard is

01:10:24

which will be well, in the telegram messages

01:10:28

here you can add some elements, but

01:10:30

since we have already added all these elements

01:10:32

in a private object, we select

01:10:36

interplay as the mark and here we indicate the

01:10:39

text that we glued together in the

01:10:42

previous stage, okay, let's try

01:10:49

how this all happens, now the

01:10:58

unique text that we have give a

01:11:03

gift for the doors are a

01:11:05

gift but the holes are a charity,

01:11:09

in theory, so we send and

01:11:21

y and let's launch oh forgot to launch ran vans

01:11:28

aigle didn't forget

01:11:38

everything is correct, I didn't write the amount on the

01:11:46

tarot in the song for example 1000 2000 and

01:11:53

in theory he should ask us about what happened

01:11:57

about to this gift for holes which

01:12:00

fund it belongs to and here are all our funds

01:12:03

and zrtp well, we are writing

01:12:06

charity

01:12:08

well and nothing happens because we haven’t

01:12:10

done anything yet, that’s great, that means what

01:12:17

happened here is what was received

01:12:21

at the input from us and that’s all that

01:12:27

happened, well, what went to which

01:12:30

fund went perfectly, there is

01:12:35

a button of the line, it aligns all

01:12:38

our buttons and the scale means that

01:12:43

then we sent these

01:12:51

telegram funds to the user, he accordingly

01:12:54

clicks on one of them, well, here’s how I

01:12:57

clicked charity and it turns out that

01:13:04

this word charity went away from me as a user on Instagram,

01:13:06

nothing happened because it doesn’t

01:13:08

fall under this birthday gift template.

01:13:13

2 2 thousand rubles we need to do so that

01:13:18

if the word that we sent matches

01:13:24

any name of the fund,

01:13:26

then we have to write this thing to her

01:13:30

that it was from such and such a fund, the

01:13:34

expense how to do it from us from the

01:13:38

telegram comes here and here if it doesn’t

01:13:41

fit everything stops in the template, that’s why

01:13:43

we add a router here

01:13:47

that will duplicate this flow

01:13:57

of years and it will turn out like this,

01:14:01

food router, we divided the flow and here we

01:14:06

will add a search

01:14:09

hey tails that this is the fund that

01:14:13

we sent, what if such a record and you

01:14:19

were a network record and now we again indicate

01:14:26

that the database, this is you, was the

01:14:33

fund and the formula, we indicate here that

01:14:37

we are

01:14:44

equal to

01:14:46

quotes and what came from telegram.bot,

01:14:53

but the text sorting view is rattling for us,

01:15:04

too, the day is a cube and they themselves are what he must

01:15:06

endure for now and here and accordingly

01:15:12

[music]

01:15:16

let's see what we got, let's launch

01:15:24

he asks that we already had

01:15:28

messages about the message we had just

01:15:30

this charity which the

01:15:32

latter sent personally now

01:15:35

let's look at it let's check that it's us and this is a

01:15:47

charity it means here

01:15:50

before the trial it came here, he didn’t let me in according to the template

01:15:56

and passed, but here we have an incubus for

01:16:04

charity and there was only one ban, so

01:16:07

he found a charity limit of ID

01:16:10

records

01:16:11

when he consciously, well, in general, found everything we

01:16:15

need, which means now we need to

01:16:20

indicate this record that we

01:16:23

created at this step after

01:16:27

we checked who the sender was, at

01:16:30

this step we

01:16:37

created a new record in the MTS network and here

01:16:41

we indicated that the fund is, well, some kind of fund, we

01:16:45

took some kind of love by default, and

01:16:47

we need to change this record fund

01:16:53

for what we found at this step and

01:16:56

for this we need

01:16:58

some kind of storage, that is, here

01:17:01

we will write down that this is the entry we

01:17:06

made by default, here at

01:17:09

this step we will look for the entry

01:17:12

that we made by default and let's

01:17:14

change the fund, how this is done, we

01:17:19

have it here, we have it

01:17:35

here, we'll add an on link and vessels,

01:17:45

we'll add a database module,

01:17:50

date

01:18:04

tattoos,

01:18:06

and then above the history,

01:18:10

this storage is in int and letter itself, that

01:18:14

is, in fact, you can store it

01:18:15

anywhere, there's a lot of integration

01:18:17

save anywhere from anywhere, read from anywhere, but

01:18:20

for clarity, I’ll do it, but here it

01:18:25

means it’s a replay and a record, we need to

01:18:28

create a record here since we don’t have

01:18:35

anything, let’s add May date stora date

01:18:40

structure data structure we have

01:18:44

bottoms for telegram, but we need this

01:18:47

then the other one doesn’t fit,

01:18:52

so that means here we will have 1 ty us,

01:19:03

so that means something must be an

01:19:08

identifier, we will have the ideas of a

01:19:14

person in the telegram, that is, one

01:19:15

person can only have 1 record saved,

01:19:18

but so that there is no confusion, then

01:19:22

we have here there must be a record number air

01:19:27

temples what we created so that later we

01:19:31

could find it

01:19:34

well, in principle, and everything reads like

01:19:39

this it will be called Rio carta di

01:19:42

century one type text and coattails no Ricky Reid

01:19:48

to multivan no so save it so it means

01:20:00

we created it do the storm with and here and

01:20:05

now the key but we are creating a record in this

01:20:11

to delight and the keys we will have go to

01:20:17

Qatar of the one who sent the message

01:20:21

to go and the

01:20:25

record with such faith then the investing record

01:20:29

if we have a person who sent two

01:20:31

messages there well

01:20:33

went for a walk 500 from went to the cinema there are

01:20:36

thousands, then only the last ones will be saved

01:20:38

if the penultimate one he wants to

01:20:41

correct, he can enter this and was to

01:20:43

correct the colors because in telegram

01:20:46

be afraid to create complex logic it will not be

01:20:48

very convenient then it will be inconvenient

01:20:49

to use here is the IT record we

01:20:54

take air you were

01:20:57

it what we created crate eric here is

01:21:01

this identifier

01:21:03

ok

01:21:06

so this needs to be connected all this needs to be

01:21:11

straightened out

01:21:14

and accordingly

01:21:16

and for her I made a mipo here this is necessary here

01:21:23

on link this is necessary here can link

01:21:26

and this is the thing here the courts here

01:21:38

well here it means we receive a message,

01:21:42

we look if it fits the template

01:21:44

then we write down enter mts then we don’t

01:21:51

write down the coins we don’t write down this amount

01:21:54

first we look who it is but he sent whether there is such a person

01:21:56

or not if there is such a

01:21:58

person there is no such person here he

01:22:01

creates if there is such a person then it

01:22:06

records the database so I made a mistake

01:22:12

friends and here is the Crete record it should

01:22:17

be somewhere we created the record and then we

01:22:26

have to save it here we are hidden

01:22:33

link made

01:22:34

a cry this or the record recorded

01:22:37

what was created there the pacifier I’ll check since

01:22:42

I don’t get it

01:22:44

open record to go through this, they wrote down

01:22:50

the number of this record,

01:22:53

then they looked for all the funds by their you were

01:22:57

merged into one element, they were sent to

01:23:00

telegram so that it was in the form of buttons, this is

01:23:02

brazil, it means well, accordingly,

01:23:07

here when we found that this

01:23:10

charity coincides,

01:23:12

indeed, then we should look there

01:23:19

ready top a record for this user

01:23:23

if it is there and then we

01:23:26

will rewrite the fund for what we have

01:23:30

now received into it if there is no such record then

01:23:33

we do nothing like this

01:23:51

according to the

01:23:57

filter, this is a little different, now I was

01:24:00

created before and so here we select the date,

01:24:06

too, here is

01:24:07

the guitar of the cards and here we select in

01:24:12

this thing our only do the storm

01:24:14

by key which is equal to what came

01:24:18

to mind from the telegram

01:24:21

ID okay, and then then we look vrt

01:24:29

balls this is the record you plant which

01:24:32

we have already found but which are saved in the date

01:24:38

100 g tariqat this is when we know

01:24:42

the identifier to offer and the record if

01:24:44

we know some kind of field only the

01:24:46

name is there damn it then all chirp is the

01:24:51

same tight and bass table and

01:24:56

teams record these equals

01:25:01

record these from saved date 100

01:25:07

respectively

01:25:08

[music]

01:25:13

accordingly we need to check that

01:25:16

such a record was found or not, if it was

01:25:21

found

01:25:24

then we update it, which means we will

01:25:29

now add what is here, etc. and so on.

01:25:39

you are full of this in the record the same thing

01:25:49

for reliability let's put this one to go

01:25:52

although it should be equal to the same for the

01:25:54

katadyn session

01:25:57

here we write the fund that the

01:26:09

river is equal to the

01:26:16

fund that we found so we

01:26:22

searched here from the records network this

01:26:25

funds and here go the boxes that

01:26:29

would be found from here we were looking for a limit of one only

01:26:31

one record and therefore we can

01:26:33

use in this cherry to that's ok

01:26:44

then we have updated this record and what should we

01:26:49

do next accordingly next we will

01:26:51

write to the user that everything went

01:26:53

well we have recorded

01:26:57

the expense such and such fund such and such

01:27:04

corresponding add telegram

01:27:07

send message read send to the same person

01:27:11

from whom we received this text write

01:27:23

everything went successfully

01:27:33

added new entry

01:27:41

fund and fund from us we will remove name and

01:28:03

name here we will indicate what exactly we

01:28:10

added the amount of

01:28:28

400 rubles for example, so good ok,

01:28:35

so here we are finished, we have

01:28:38

one place left that is not very good from it,

01:28:44

that is, when its message arrives, it is

01:28:46

checked for compliance with the

01:28:53

oil template, it passes, it will go further, there are

01:28:57

no problems and they are checked for

01:28:59

compliance with

01:29:00

this mod, whether there is such a thing or not,

01:29:07

respectively here are 10, but we need to limit

01:29:10

that if this was not found, what record was

01:29:12

not found, then we don’t need further tags,

01:29:15

out put, this is a set of bangles, we

01:29:23

need to check again how many and what

01:29:25

result

01:29:27

came, and here we make a filter

01:29:34

that checks for compliance

01:29:41

the name of the matching fund fund

01:29:54

you know that we got a gang of leopards here, it

01:29:59

should be of big world 1 is equal to

01:30:05

one okay, that means it was cut off here

01:30:09

here too, if there are no such records,

01:30:13

then we also don’t need to do anything, which means

01:30:17

we have a vice-rector and go there should be an

01:30:25

existential

01:30:28

okay and the corresponding one if the record

01:30:37

exists not for some reason, we

01:30:39

don’t have it

01:30:43

already deleted, or it’s in the wrong

01:30:45

format, anything else there, there’s also

01:30:48

no need to perform further, that is, this

01:30:55

gtk thing, it should also exist,

01:31:03

updates, record update and record if we

01:31:15

update a record then everything is fine

01:31:21

because we have already found it and what will

01:31:24

happen to it during the time we

01:31:26

update it, well, purely theoretically, of course,

01:31:28

something can happen when many

01:31:30

users are sitting at the same time, but

01:31:33

since this is a demo file, who is it?

01:31:35

we can easily be neglected,

01:31:37

no one will be there in a split second

01:31:39

to change the data in the table several times,

01:31:45

but it may be that something

01:31:50

will go wrong here, for example, we will not be able to

01:31:54

change for some reason, well,

01:31:57

there is no access or something else and so that it didn’t crash for us,

01:32:04

well, we received some kind of message to

01:32:07

end the script there and add

01:32:10

this to the hole that can work at this step, that

01:32:16

is, if something

01:32:18

goes wrong here and then we’ll

01:32:22

finish normally, we think what it is

01:32:24

maybe it’s okay, so we won’t

01:32:30

send errors, so we’ve got this

01:32:35

scheme, let’s check how it works, now one

01:32:38

more time,

01:32:39

that means we’ll run it and check the

01:32:47

birthday gift. in 2000 and he tells us

01:32:58

which fund it belongs to, we write to

01:33:01

a charity, so only here again

01:33:03

he and start the romance is processed and

01:33:10

so he didn’t go here, went here and

01:33:15

we received a message everything was successfully

01:33:17

added record fan

01:33:18

charity sum 2000 and let’s go air

01:33:24

you were with let’s see what what's going on there

01:33:28

and this is a gift to the shore 7

01:33:33

everyone was by default entertainment

01:33:35

stopped and the last one became

01:33:37

charity come here

01:33:41

adblock keyboard and I'm no longer there it's

01:33:44

still there and we need to force

01:33:46

reset it these are the last

01:33:50

message everything went well

01:33:53

let's go here and here this is the

01:33:56

last message in the telegram we

01:33:58

will edit a little show advanced

01:34:01

settings

01:34:02

and here and the reply symbol with a poppy to collect the answer

01:34:09

and here we will indicate that the flag that you

01:34:14

need to delete the custom keyboard

01:34:21

means so as not to launch the romance every time

01:34:24

I saved this script and here

01:34:29

I turn it on in the

01:34:30

france script when he asks

01:34:35

how it should be turned on either immediately

01:34:37

or at some intervals or once

01:34:41

every day some day of the week

01:34:44

shadows of the month and some specifics of Bates

01:34:48

but the specifics of our script is that

01:34:52

it always I have to listen to see if

01:34:53

anything has arrived from the

01:34:54

telegram, so I’m releasing the name and

01:34:57

the slow ones, maybe there are some

01:35:01

other scenarios

01:35:02

that you will do in which you

01:35:04

will need to

01:35:06

check your mail there every morning, for example, and

01:35:07

send it to

01:35:08

some of your friends if in the mail

01:35:11

it appears that you’re coming to a party,

01:35:14

for example, but in this case it’s not like that,

01:35:17

everything including it is turned on and now in the

01:35:22

telegram it will be executed immediately, you wo

01:35:25

n’t have to run it sequentially every time,

01:35:28

so that means we’ll do it again, we’ll go to

01:35:31

five and we’ll move the mouse to the feed

01:35:36

exactly a tape for 3000,

01:35:42

here he is waiting for how many seconds and now he

01:35:47

must answer 100 watts he answered

01:35:50

charity cans portrait

01:35:53

food years pour in food for sale now we have

01:35:58

these buttons although I pressed and

01:36:04

nothing happened let’s see what

01:36:08

happened I just haven’t had time yet everything went

01:36:17

well

01:36:18

added new entries fund and up to the amount of

01:36:21

3000 rubles and here there are no buttons anymore

01:36:24

here there is just a button from a bot

01:36:26

that will leave a slash

01:36:28

but those buttons have disappeared everything is as it

01:36:33

should be so now I’ll tell you

01:36:38

what’s next but for those who repeated after

01:36:42

me this is all that can be

01:36:45

done here next, first of all, you can check the

01:36:52

sum of the soup the remaining amount of the fund, that is,

01:37:00

here you need to add the

01:37:03

sum of all the elements that are

01:37:12

recorded belong to this fund, that is,

01:37:14

here I went to the cinema, bought a moped, well, with

01:37:23

this saw grouping by iPhone

01:37:28

here you can see what the disk is

01:37:30

adding up in funds, the same can be

01:37:32

done through

01:37:34

roll up, here through roll up

01:37:47

we indicate there with this and indicate

01:37:51

the amount in it and then it writes that the amount of

01:37:54

this mount is output here this will be the

01:37:57

total spent and then add one more

01:38:00

column that we subtract from the limit

01:38:02

how much was spent

01:38:04

and when we update the record

01:38:09

there and after that we read again

01:38:13

this record of the fund and see

01:38:16

how much is left in it and in this

01:38:19

message instead of this text like

01:38:21

that everything went well, we introduce that the

01:38:23

guide fund has so much money available, this is the

01:38:30

first thing, well, it’s just more convenient

01:38:33

to work,

01:38:34

second, where do these funds come from,

01:38:37

there are several approaches for whomever is more convenient,

01:38:41

accordingly, if a person receives a

01:38:43

fixed salary for example, every

01:38:46

first number

01:38:47

he can configure this in another

01:38:51

script that every first number

01:38:54

will add to the van damme, well, the amount

01:38:59

that he is ready to spend on them, that is,

01:39:02

if I, for example, receive 50,000, then I will find I

01:39:05

spend, for example, 10 thousand and so every

01:39:07

first number and here there will be food there plus

01:39:10

10 thousand pieces twenty thirty forty

01:39:12

respectively and every month I

01:39:14

will spend something there and

01:39:15

here the amount of money that I

01:39:18

can spend on food will all the time be

01:39:20

subtracted from this total amount

01:39:23

accordingly at the end of the code you can

01:39:25

see how much was spent

01:39:27

on food for the year, well, in this case, we

01:39:31

strictly hammer down what amounts we track

01:39:35

what we spend on, that is, we know such a

01:39:37

salary, we know how much we need, I will find a

01:39:39

second option if a person does not receive

01:39:45

a salary from time to time or he does not know

01:39:48

what it is there will be some percentage of

01:39:51

sales, for example, today he is there 50 thousand,

01:39:54

it turned out tomorrow 150,000 he will receive,

01:39:56

respectively, here you can set up the

01:39:58

same thing, only there will not be fixed

01:40:00

amounts, but some percentage will sink, we decide

01:40:03

10 percent I spend on saving there

01:40:07

in investments or for charity

01:40:09

she is going I spend 20 percent there and,

01:40:12

accordingly, it can be done so that again,

01:40:16

in some format here, the

01:40:20

income there is five thousand rubles, so he

01:40:25

would write an income of 5 thousand rubles and

01:40:27

here we would have what if it’s not like this

01:40:30

and not like that here again, what

01:40:33

exactly is income and a certain amount, then there

01:40:38

would be a scenario about what to

01:40:40

do with this amount, that is, it would be

01:40:42

broken down into interest, something else,

01:40:44

whatever it’s convenient for, and so

01:40:50

these things would be filled up. In

01:40:53

addition, you can do this once a month,

01:40:56

for example, if I have a monthly budget,

01:40:59

then all these MTS networks and those that

01:41:01

exist go to another table,

01:41:03

for example, there are archives with this and this

01:41:07

table is cleared, that is, in the archives

01:41:09

on things will be all the expenses there are for your entire

01:41:12

life, and this sugar is the expenses only for

01:41:14

this month, so as not to accumulate

01:41:18

these forfeits and that there were no big

01:41:20

numbers,

01:41:21

well, again, who likes a year as convenient, this is the

01:41:24

most basic functionality

01:41:27

that simply allows you to conveniently manage

01:41:30

expenses It’s not like using Excel

01:41:33

tablets at home or for example google google

01:41:38

of scam excel and when you need to use it in a

01:41:42

couple of weeks, you

01:41:43

have to scroll very

01:41:45

far down to add some

01:41:47

element, well, it’s much more convenient to

01:41:52

write it down this way and you can visually

01:41:56

see how to create some types by

01:41:59

which it is clear that but some amounts like how

01:42:03

much was spent by date can

01:42:07

also be viewed conveniently, again, it is not

01:42:12

necessary to use exactly them you

01:42:14

were with, you can save Google ones in order to

01:42:18

save any other database as

01:42:20

quickly as possible, grease in your reading and writing, all this is there, that

01:42:24

means Let’s see, we

01:42:28

sent such messages several times and

01:42:31

what does our cost mean, each

01:42:34

transition here, here, here

01:42:37

is one element of calculations, that is, 1

01:42:42

element is 2 and a millimeter element is 4, well, that’s how much it

01:42:46

takes, the fewer

01:42:48

elements, the more you can do

01:42:52

for free thousands of rubles so

01:42:55

let's see what

01:42:58

's going on in our dashboard here operations usd 10

01:43:03

percent

01:43:04

1000 free here we have this graph

01:43:09

which means in numbers this is 100 operations

01:43:16

done today I didn't do that

01:43:19

much just a few messages

01:43:23

usually well for expenses that's enough

01:43:26

if you spend 12 3-4

01:43:30

times a day for some kind of purchase in a

01:43:33

store in a minibus, you pay for it or the

01:43:35

metro, in principle, this is enough for a month, it

01:43:40

may be enough, but if that’s not enough for you, then

01:43:42

there is a plan,

01:43:45

well, again, if you

01:43:48

spend more on some... then the logic where you

01:43:51

will need more, then there is basic for the

01:43:54

matter of dollars per month and here they already give

01:44:00

10,000 operations, that is, 10 times more than

01:44:03

on the free one, perhaps someone for someone,

01:44:08

well, perhaps this will suit someone, I think

01:44:12

that the standard is 40 thousand operations out of 29

01:44:16

dollars this is already too expensive, but

01:44:18

again, who wants what, this means

01:44:24

this is the script that we made,

01:44:27

you can create a new script and

01:44:30

use some

01:44:32

templates, for example, facebook that we have

01:44:38

facebook is mine her

01:44:46

facebook custom audience facebook group

01:44:52

son website facebook pages

01:44:56

facebook messenger for example, a continent and

01:45:04

what we have

01:45:06

view a message send an action

01:45:10

send a message

01:45:12

well, that’s what integra mother itself is and

01:45:16

you can see, well, even a board with vodka

01:45:22

all the information

01:45:23

script is a list of scripts for an hour on a

01:45:27

topic you can create a new template

01:45:31

this is what some prepared

01:45:34

modules posts message knitting tweet from a

01:45:41

watch it with from a discord account that

01:45:43

is, we make some kind of tweet and

01:45:46

it is not automatically copied soon here

01:45:49

from google sheets something is sent to

01:45:52

telecom, that is, there are a lot of such small

01:45:55

blanks on which you can see

01:45:57

how it all works connection is happening, this is

01:46:01

what we have already connected, that is, these are

01:46:05

the paths to which intagram is

01:46:08

waiting for something, that is, at this address

01:46:10

in telegram you can add a bypass edge

01:46:14

for Facebook for many more such

01:46:18

keys,

01:46:21

you know such a device you can add

01:46:25

your own phone and on the phone there create

01:46:27

buttons and here in this document you can

01:46:30

listen that when you press a button one,

01:46:33

for example, one script is launched when you

01:46:35

press a button 2 another script or

01:46:38

you can send your location to

01:46:39

Instagram from there, too, some kind of script

01:46:41

will have what if I approach to

01:46:43

the metro, something needs to be done there, that’s

01:46:50

basically it, that’s all, thanks to everyone,

01:46:54

bye

Description:

Показываю создание telegram бота по принципу no code - использую только графический веб интерфейс и no-code платформы: airtables для хранения информации и integromat для связи. https://www.make.com/en/integromat-shutdown?fromImt=1& https://www.airtable.com/ 00:05 описание результата 02:00 начало работы с airtable 10:48 смотрим как работают сделанные таблицы 11:48 столюцы rollup 11:53 представления 14:40 описание integromat 15:16 добавление интеграции телеграма 16:50 создание бота в телеграмме 20:44 проверка работы телеграмм бота 21:40 запуск вебхука для сообщений телеграм 22:10 как смотреть что пришло в элементы и что вышло 24:08 описание первоначальной логики распознавания сообщения от пользователя 25:53 распознавание сообщения пользователя по regexp шаблону 28:03 описание логики сохранения данных от пользователя 28:40 поиск в airtable записи через integromat 31:15 получение информации из предшествующих элементов интегромата 32:40 разделение потоков интегромата роутером 33:20 создание записи в эиртэйбл через интегромат 34:48 создание фильтрации на поток интегромата 40:45 создание задержки при выполнении процесса интегромата 42:50 определение record id для элемента airtable 46:37 использование функций преобразования в интегромате 49:40 поиск нескольких элементов в интегромате из эйртейбл 52:40 array agregator и iterator - склеивание нескольких бандлов в один массив и наоборот 56:02 создание кнопок в чат боте телеграмма 57:38 json agregator - создание json из массива 58:25 создание структуры для json 1:00:05 преобразование массива в json структуру при помощи функции map 1:04:13 элемент compose a string, функции преобразования строк 1:07:21 создание ответного сообщения с кнопками 1:14:06 поиск в airtable соответсвия запросу пользователя 1:18:10 хранение состояния пользователя в data store 1:23:36 чтение состояния пользjвателя из data store 1:31:50 обработка исключений в интегромате 1:34:21 настройка автоматического запуска сценария интегромата 1:36:41 как можно использовать полученный сценарий и как доработать его под себя 1:42:26 стоимость интегромата и общий обзор 1:44:26 шаблоны интегромата 1:46:24 возможности подключения телефонов в интегромате

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Создание no-code telegram бота на integromat и airtables для ведения бюджета" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Создание no-code telegram бота на integromat и airtables для ведения бюджета" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Создание no-code telegram бота на integromat и airtables для ведения бюджета" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Создание no-code telegram бота на integromat и airtables для ведения бюджета" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Создание no-code telegram бота на integromat и airtables для ведения бюджета"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Создание no-code telegram бота на integromat и airtables для ведения бюджета"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.