/Users/johnr/Desktop/IA pdf Downloads/Criteria__P__-_Coding_Project_Upload_all_2022-05-03/Product_Henri_05_01/Database/DatabaseScript.txt |
1 ={'Form Responses'!A2:A} --> ={'Form Responses'!I2:I} 2 3 ----------------------------------------------------------------------------------------- 4 5 =IF(ISBLANK(A3),"",J2+1) 6 7 ----------------------------------------------------------------------------------------- 8 9 =D3&" "&E3&" "&F3 10 11 ----------------------------------------------------------------------------------------- 12 13 =(firstThree(G3))&" "&H3 14 15 ----------------------------------------------------------------------------------------- 16 17 =INDEX(J:J, MATCH(99^99,J:J, 1)) 18 19 ----------------------------------------------------------------------------------------- 20 21 =INDEX( FILTER(D:D, NOT(ISBLANK( D:D ))), ROWS(FILTER(D:D, NOT(ISBLANK(D:D)))) ) 22 23 ----------------------------------------------------------------------------------------- 24 25 26 =IF(P15="May","05",(IF(P15="January","01",(IF(P15="February","02",(IF(P15="March","03",(IF(P15="April","04",(IF(P15="June","06",(IF(P15="July","07",(IF(P15="August","08",(IF(P15="September","09",(IF(P15="October","10",(IF(P15="November","11",(IF(P15="December","12"))))))))))))))))))))))) 27 28 ----------------------------------------------------------------------------------------- 29 30 =formatTime(P14) 31 32 ----------------------------------------------------------------------------------------- 33 34 =IF(ISBLANK(Users!A3),"",AH2+1) 35 36 ----------------------------------------------------------------------------------------- 37 38 ="<TI>"&S21&"<TI><DA>"&T21&"<DA><DP>"&U21&"<DP><AR>"&V21&"<AR><AU>"&W21&"<AU><NO>"&X21&"<NO>" 39 40 -----------------------------------------------------------------------------------------