Looking for help on my script logic

[mdavis6537]

Hello - I am trying to do the following:

 

I have a technician that needs to go into each room in a house, record a bunch of data in a form, and have all the data for each room link back to the one customer who owns the house.

 

So far I have - a database and table of customers with all the fields you would expect.

A field list with all the possible room options

 

I am trying to write a script that will do the following:

 

Loop through each one of the rooms in the list.

Add a new record for each room

Set a property for that record to be the name of the room.

Link these records some how back to the single customer who's house the rooms are in.

 

 

So far I have the attached script. I have programmed for a year or so in C# but I am struggling to use this built in scripting piece of file maker.

 

Does the way I am going about this make sense? Is there a better way? If not, can someone attempt to help me finish out this script? Thanks.

 

[comment]

This is a duplicate post:

http://fmforums.com/forum/topic/89903-new-to-fmp-creating-layouts-based-on-checkbox/#entry412657

 

Please post your question only once.

[Lee Smith]

I deleted the duplicate post.

 

@mdavis

 

Please do not multiple post your questions. This is only one list divided into several topics, and most of the members read all new topics..

 

There are several reasons for not posting multiple posts, and if you need more information on this, please send me a private message.

 

Lee

[comment]

I have a technician that needs to go into each room in a house, record a bunch of data in a form, and have all the data for each room link back to the one customer who owns the house.

 

Is this going to happen only once for each house, or is it some kind of periodical inspection?

 

 

I am also puzzled regarding the workflow you envision for the technicians. So they create a record for each room (or you create these for them in advance) - what's next? How do they navigate among them and make sure they cover each room? Wouldn't it make more sense for them to select the room they are about to inspect from a list of the house's rooms - and perhaps create the necessary record by this selection and not before?

[mdavis6537]

@Moderator - sorry - the other thread didnt seem to be put into the correct forum.

 

Is this going to happen only once for each house, or is it some kind of periodical inspection?

Its more of a periodical inspection - each house will have this form filled out for the rooms 3 or more times.

 

Whats Next:

Well - after the records are created for each room (and I am not set on doing it that way), then they would go in and fill out a bunch of information on that page. I guess at the bottom of each page I would need a button that would take me to the next record somehow to ensure they dont miss anything. I wouldnt have an issue with them selecting the room they are about to fill out, I was just trying to avoid creating a record for every room in the house, when they might actually only need two or three of the available rooms. They wont always be working in every room in the house.

[Lee Smith]

@Moderator - sorry - the other thread didnt seem to be put into the correct forum.

 

As long as you have posted it in a topic that relates to the problem, then there isn't any one correct topic. In the future, if you feel that your topic should be move, just notify one of the moderators.

[comment]

I guess at the bottom of each page I would need a button that would take me to the next record somehow to ensure they dont miss anything.

 

I think that if I were doing the inspection, I would like to see a list of the rooms that need inspecting. I would select one of them and a form for that room would open - perhaps in a new window. At the bottom of the form, a "Done" button would close the form and take me back to the list (where the room I had just inspected would be marked as such). But that's just my (uninformed) idea.

 

 

I was just trying to avoid creating a record for every room in the house, when they might actually only need two or three of the available rooms. They wont always be working in every room in the house.

 

This point needs clarifying. Obviously someone needs to indicate to the technician which rooms need inspecting, before the actual inspection can take place; but is it possible for the selection to change in-between inspections? For example, a house has 5 rooms: the first inspection covers rooms 1, 2 and 3, and the next inspection deals with rooms 1, 2 and 4?