Please enable JavaScript.

Coggle requires JavaScript to display documents.

Основа 3.0, ?rowId>0 - Coggle Diagram

- - - - doc=1sSGhFJNErtaK3ISTTAo1i4r_9-9YGP5-HMnRQdECKjA
      - range=A:A
      - search=%sys.extuid
    - - %value1=1
      - %rowId=rowId
      - %value2=2
      - %value3=3
      - %value4=4
      - %value5=5
      - %value6=6
    - - else
        
        %allowed=0
        
        Вход запрещен
        
        Запросить доступ?
        
        ///Нет
        
        end
        
        ///Да
        
        %bot.pushMessage=%sys.givenname|%sys.username|%sys.extuid
        
        calc %schedule=%sys.timestamp+2
        
        1 more item...
      - ?rowId>0
        
        %allowed=1
        
        ?allowed>0
        
        start
        
        $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        1 more item...
        
        ANSWER
        
        1 more item...
        
        QUESTION
        
        2 more items...
- - - - else
        
        $SYS.GET
        
        error
        
        continue
        
        %row=$[0] %cells
        
        fill_vars
        
        10 more items...
        
        Authorization: Bearer %token
        
        ANSWER
        
        %cells=values
        
        %docId=18-aYyX7uYOoNv-bqmaFBwiFCc56JdYxlyAgeBebewek
        
        %range=A2:R2
        
        %token=$.access_token %sys.googleOAuth2
    - - %document_id
    - - range=C%rowId
      - doc=17mHTBfUjPqrD8T3yrGZ_qFF4i5erkKa1M3UFdJ_ooHI