Please enable JavaScript.

Coggle requires JavaScript to display documents.

Заполнить из базы - авто (start (%Proekt=%projectId (lab12 ($SYS.GET…

- - - - $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        ?rowId>0
        
        lab4
        
        %KPP_Dolzhlika=%value9
        
        %NomerDela=%value1
        
        17 more items...
        
        %Data_sled_suda=%value6
        
        %Proekt=%value0
        
        %Data_zayavlenia=%value24
        
        %Istci=%value25
        
        %Opredelenie_o_naznzchenii_kad=%value2
        
        %Otvetchiki=%value26
        
        %Pochta_dolzhnika=%value27
        
        %Cena=%value28
        
        %Nomer_Otcheta=%value29
        
        %Data_Otcheta=%value30
        
        %Torg_Ploschadka=%value31
        
        %Perechen_lotov=%value32
        
        %Zadatok=%value35
        
        %Gde_publikovat_torgi=%value34
        
        %Osnovanie_ocenki=%value33
        
        %Shag_aukcion=%value36
        
        %Srok_publichnoe=%value37
        
        %Shag_publichnoe=%value38
        
        %Cena_otsechenia=%value39
        
        %Polnoe_naimenovanie_Dolzhlika=%value10
        
        %AS=%value3
        
        %PasportDolzhnika=%value42
        
        %Data_sled_suda=%value6
        
        else #
        
        ANSWER
        
        %value23=23
        
        %value13=13
        
        %value12=12
        
        %value14=14
        
        %value11=11
        
        %value15=15
        
        %value10=10
        
        %value16=16
        
        %value17=17
        
        %value18=18
        
        %value19=19
        
        %value20=20
        
        %value21=21
        
        %value22=22
        
        %value9=9
        
        %value8=8
        
        %value8=8
        
        %value7=7
        
        %value6=6
        
        %value5=5
        
        %value3=3
        
        %rowId=rowId
        
        %value2=2
        
        %value1=1
        
        %value4=4
        
        %value0=0
        
        %value24=24
        
        %value25=25
        
        %value26=26
        
        %value27=27
        
        %value28=28
        
        %value29=29
        
        %value30=30
        
        %value31=31
        
        %value32=32
        
        %value33=33
        
        %value34=34
        
        %value35=35
        
        %value36=36
        
        %value37=37
        
        %value38=38
        
        %value39=39
        
        %value40=40
        
        %value41=41
        
        %value42=42
        
        QUESTION
        
        range=Sheet1!A1:B300
        
        search=%Proekt
        
        doc=1-zJB-gIWJ_ngzhZNWcOXpkUZhs_2vBdO2l5p5MgMj6c