I am new to BWS and was asked to create a simple script. I don't use the tool often, so the basics are slowly coming back to me - when you don't use, you do loose.
Does the "source" spreadsheet need to have column headers? The excel
spreadsheet I am working with for this script doesn't, so I thought I could use
the D("1"), D("2)", etc. as designation - instead of column headers. This
works for the first cycle of record processing, but once the Status is updated,
it shifts the first column to be the second column and the scripts goes into a
loop because what I am checking in D("1") is blank, instead of a the numbers we
are validating.
Example below is what the datastation looks like when the first record is
processing - note 6 columns:
[cid:[email protected]]
Example below is what the datastation looks like when the second record is
processed - note 7 columns:
[cid:[email protected]]
Amy Sobczak
St. Michael's Hospital, 900 Illinois Avenue, Stevens Point WI 54481 | phone:
715.342.7629 | email: [email protected]
________________________________
CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the designated
recipient(s) named above. If you are not the intended recipient, you are hereby
notified that you have received this communication in error and that any
review, disclosure, dissemination, distribution or copying of it or its
contents is prohibited. If you have received this communication in error,
please notify the sender at the electronic mail address noted above and destroy
all copies of this communication and any attachments. Thank you for your
cooperation.
--- To post a message to this list, send mail to: [email protected] You are
currently subscribed as: [email protected] Unsubscribe in the
customer center on our website:
http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx <<inline: image001.jpg>>
<<inline: image002.jpg>>
