https://www.infopathdev.com:443/forums/131.aspxqRules adds support to your InfoPath forms. With qRules, you can add features to your form that require code, but without having to write it. enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/80315.aspxSat, 07 Jul 2012 20:58:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:80315dsnightthunder0https://www.infopathdev.com:443/forums/thread/80315.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=131&PostID=80315<div style="font-family:arial, helvetica, sans-serif;font-size:12pt;"> <div style="right:auto;" id="yiv1019597047yui_3_2_0_18_134167035565937">I have a situation with the system I am developing that I don&#39;t know how to fix!!! Maybe you guys can help me!!</div> <div id="yiv1019597047yui_3_2_0_18_1341670355659599"> </div> <div id="yiv1019597047yui_3_2_0_18_1341670355659601">The client has numerous customers who enter information into pre-formatted excel spreadsheets and submit them on a daily basis. I tried to talk them out of that and into getting them to input directly to sharepoint, to no avail... I think in 2007 you could connect a spreadsheet and regularly update it to sharepoint, but not any more... </div> <div id="yiv1019597047yui_3_2_0_18_13416703556591232"> </div> <div id="yiv1019597047yui_3_2_0_18_13416703556591234">So I am using the excel to infopath tool to upload the spreadsheets to infopath forms and populate a library. I promoted all the fields of the form so I could then call all of the data into a form and write it back out into a sharepoint list using qRules.</div> <div id="yiv1019597047yui_3_2_0_18_13416703556594508"> </div> <div>Anyway, I got all of that working and it is fine... Now I need to compare various business names to another sharepoint list and locate or assign id numbers to them.</div> <div id="yiv1019597047yui_3_2_0_18_13416703556592701"> </div> <div id="yiv1019597047yui_3_2_0_18_13416703556592703">I have no problem getting the ones that match already when I upload the data into the form...</div> <div id="yiv1019597047yui_3_2_0_18_13416703556593006"> </div> <div id="yiv1019597047yui_3_2_0_18_13416703556593008">My problem is that I then need to truly filter out blank business names and duplicates so I can submit only unique values back to the Businesses list and get a new id back for each one using Submit to SPList... I have tried everything I can think of to do this and I can&#39;t make it work... I have researched everything I can find and I am just not getting it...</div> <div id="yiv1019597047yui_3_2_0_18_13416703556594655"> </div> <div id="yiv1019597047yui_3_2_0_18_13416703556594657">I have attached screen shots and an explanation of the process - as well as the form template - to an e mail sent to the support mailbox.&nbsp; The form has a lot of data connections that are not in use yet, so I know it is confusing!!!</div> <div id="yiv1019597047yui_3_2_0_18_13416703556593742"> </div> <div id="yiv1019597047yui_3_2_0_18_13416703556593744">I have been working on it for about three days now... and it is a real deal breaker!!! Can somebody help me??? PLEASE!</div> <div id="yiv1019597047yui_3_2_0_18_13416703556591971"> </div> <div style="right:auto;" id="yiv1019597047yui_3_2_0_18_13416703556594565"> </div></div>