FasdUAS 1.101.10 k l  This script is designed to take a user selectable Numbers or csv file in as input and update the first row with the field type meta-tags expected by the Tap Forms application. Assumptions are that the first row of selected table of the selected sheet contain the "Field Names". Final output of the script is to save the file in the original location with the original name and a ".csv" after it.   $ This script is designed to take a user selectable Numbers or csv file in as input and update the first row with the field type meta-tags expected by the Tap Forms application. Assumptions are that the first row of selected table of the selected sheet contain the "Field Names". Final output of the script is to save the file in the original location with the original name and a ".csv" after it.  l  l  p 0 filealias fileAlias 0 fieldtypelist fieldTypeList l r J mtext m number ! m""##date!$% $m&&''time%() (m**++date_time),- ,m..//contact-01 0m2233check_mark145 4m6677note589 8m ::;; phone9<= <m >>?? photo=@A @m BBCCweb_siteADE Dm FFGG emailEHI Hm JJKK phoneILM Lm NNOO ratingMPQ PmRRSSlocationQT TmUUVVfile o 0 fieldtypelist fieldTypeListWX WlXYZ YlZ[\ [l(] ]r(^_ ^I$` .sysostdfalisnull`a  prmp am bbccSelect the Numbers or CSV file you wish to prepare for Tap Forms _o 0 filealias fileAlias\de dl)8f fr)8gh gb)4ij il)0k kc)0lm lo), 0 filealias fileAlias mm,/  ctxt jm03nnoo.csv ho 0 saveasname saveAsNameepq plqrs rl9t tO9uv uk?wwxy xI?D .miscactvnullnullyz{ znEJ|} |IFJ ,0closetemplatechoosercloseTemplateChooser }fEF{~ ~rKV lKR IKR .aevtodocnullalis oKN 0 filealias fileAlias o 0numfilenumFile rWa 4W]  docu m[\ o 0numdocnumDoc rbm nbi 2ei  NmSh obe 0numdocnumDoc o 0nsheetsnSheets rnz nnv Iov 0 buildlist buildList oor 0nsheetsnSheets fno o 0 sheetnames sheetNames r{ c{ l{ I{ .gtqpchltns @@ns o{~ 0 sheetnames sheetNames  prmp mHSelect the Sheet You Wish to Prepare m  TEXT o 0 thesheetname theSheetName r n 4  NmSh o 0 thesheetname theSheetName o 0numdocnumDoc o 0thesheettheSheet r n I 0 buildlist buildList n 2  NmTb o 0thesheettheSheet f o 0tblnamestblNames r c l I .gtqpchltns @@ns o 0tblnamestblNames  prmp mHSelect the Table You Wish to Prepare m  TEXT o 0 thetblname theTblName r n 4  NmTb o 0 thetblname theTblName o 0thesheettheSheet o 0thetbltheTbl r I .corecnte******** n 2  NMCo o 0thetbltheTbl o 0colcntcolCnt r m o 0c Uq kl r l n 1  NMCv n 4  NmCl o 0c n 4  NMRw m o 0thetbltheTbl o 0colnamecolName r  b  b  b  m Column Name: o 0colnamecolName o  ret m*Select the Field Type o 0 promptmsg promptMsg l!! >8 set sampleValue to (value of cell c of row 2 of theTbl)p set sampleValue to (value of cell c of row 2 of theTbl) r!6 c!2 l!. I!. .gtqpchltns @@ns o!$ 0 fieldtypelist fieldTypeList  prmp o'* 0 promptmsg promptMsg m.1  ctxt o 0datatypedataType r7J b7F b7B b7>   o7: 0colnamecolName  m:=    < o>A 0datatypedataType mBE  > o 0newvaluenewValue rKb oKN 0newvaluenewValue n 1]a  NMCv nN] 4V]  NmCl oY\ 0c nNV 4QV~ ~ NMRw mTU}} oNQ| |0thetbltheTbl{ rcl [ch ocfz z0c mfgyy ox x0c{ ow w0colcntcolCnt v  Iru!" u.coresavenullobj !orut t0numdocnumDoc"s#r s kfil #ox{q q0 saveasname saveAsNamerv vm9<$$NMBRalisVMacSSDɼGDH+i Numbers.app? >; ?oa a0retlistretList d0i 9o ` `0objinobjIn 7m@@NMBRalisVMacSSDɼGDH+i Numbers.appmnop>m=<; =0 buildlist buildList <,0closetemplatechoosercloseTemplateChooser ;.aevtoappnull****n:,98qr7 :0 buildlist buildList96s6s5 50objinobjIn8q432 40objinobjIn 30retlistretList 20ir@10/. 1 kocl 0 cobj /.corecnte******** . pnam7)jvEO[l kh,6F[OYUOo-G,+tu* -,0closetemplatechoosercloseTemplateChooser,+t)( )0win (0winnamewinNameu l'&%$#"!f  '.miscactvnullnull & cwin % kocl $ cobj #.corecnte******** " pnam ! TEXT .coreclosnullobj *FB*j O3--[l kh,&EO j Yh[OYWX hUpvwx .aevtoappnull**** vkyyzz[{{d||rwx@"&*.26:>BFJNRUbn$    0 fieldtypelist fieldTypeList  prmp .sysostdfalisnull 0 filealias fileAlias  ctxt 0 saveasname saveAsName .miscactvnullnull ,0closetemplatechoosercloseTemplateChooser .aevtodocnullalis 0numfilenumFile  docu 0numdocnumDoc  NmSh 0nsheetsnSheets 0 buildlist buildList 0 sheetnames sheetNames .gtqpchltns @@ns  TEXT 0 thesheetname theSheetName 0thesheettheSheet  NmTb 0tblnamestblNames 0 thetblname theTblName 0thetbltheTbl  NMCo .corecnte******** 0colcntcolCnt 0c  NMRw  NmCl  NMCv 0colnamecolName  ret 0 promptmsg promptMsg 0datatypedataType 0newvaluenewValue  kfil .coresavenullobj avE`O*aal E`O_a&a%E`OaB*j O)j+O_j E`O*ak/E`O_a -E`!O)_!k+"E`#O_#aa$l %a&&E`'O_a _'/E`(O)_(a)-k+"E`*O_*aa+l %a&&E`,O_(a)_,/E`-O_-a.-j /E`0OkE`1O_0kh_-a2k/a3_1/a4,E`5Oa6_5%_7%a8%E`9O_a_9l %a&E`:O_5a;%_:%a<%E`=O_=_-a2k/a3_1/a4,FO_1kE`1[OYO_a>_l ?Uascr ޭ