AnsweredAssumed Answered

Script questions

Question asked by Sketter on Mar 17, 2010
Latest reply on Mar 20, 2010 by Sketter


Script questions


I have two questions.


I have never worked with Loops before, but from what I have read, I need a script that goes to every record and perform something.


Would it be proper to do a loop with if one of my functions being  a "Go To Record/Request step has an “Exit after last”" and I can end the loop with that right? (and I would still need to end the loop with End Loop?)


Second part, and I beg for your patience with me. (I'm going to try my best to explain this)


I have a script that the goal is to import data from a spread sheet into a database.

I have quite a few tables in this database.

The speed sheet has columns(fiends) that are in different tables.  So to compensate for this, I created a layout and table that will first take all the data from the spread sheet, and then plan on using another script that is commonly used when you create a single entry.

(In this database, when I add a Person, I created a button that will also create another record on another table, and of course made the records relate to one another(portal))


At one point (well two) you come across where it's not a text field, but a value list drop down box.

My first question is, how do I make the script determine based on a text field, what to pick in the value list?

My second question is, IF it can't find the value it wants, (and this value list drop box is editable) how can I make the script add the value?


There is one more question, but I want to stop there for now.



Thanks very much everyone!