/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 -----------------------------------------------------------------------------------------