Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug, 21 2013
user Daniel Eng ... via Google+
i am trying to send emails with attachments from a spreadsheet but i am looking for a good way to update which attachments should be sent.
One sheet (filelist) contains a filename list and a idnumberlist (id:s for google drive files)
a1 filelist idlist
a2 file1 0B64xvjHVr1V7VHZuMS15azl4SzQ
a3 file2 1BIHsiL-yWEjdCHqMedu7sIrMA2WX7fRCXPbnowO_aJ4
another sheet contains form inputs and than it searches for the idnumber acording to the input in c and d and gives the idnumber in e and f
a b c d e f
a1 name email attachment1 attachment2 searchid1 searchid2
a2 Daniel firstname.lastname@example.org file1 file2 =idnumber file1 =idnumber file2
a3 ruben email@example.com file2 file1 =idnumber file2 =idnumber file1
a4 Oskar firstname.lastname@example.org file1 file2 =idnumber file1 =idnumber file2
when i tried to add the same cars several times in you car query it only displayed it ones in the search column. and in this one you see file1 shows up for example 2 times in the c column and the idnumber for file1 (0B64xvjHVr1V7VHZuMS15azl4SzQ) should be displayed twice in the e column.
also when i tried the query in 2 sheets i couldnt get it working because it querys only from one sheet.
Looking forward to your help.
here is the link to the spreadsheet:
As you see i want display an idnumber in F and G for each line file found in D and E and if the cell is empty than the search cell is empty.
Made some comments and such so you see easier.