hi,

im constructing an import structure for my database. im going to have an excel sheet with info like name_id, name_full, product_id, and product_full (amongst many), from which im importing. the thing is that i need to structure the info according to company and location. for example, if its a medical company located in the states i want to be able to predetermine those values before the import, to file them (the imported persons) in the correct way.

what i want to do is to click a button called "import" and then have a popup window ask me about company and origin, where i then manually enter "medical" and "us".

i know how to do the rest of the import and how to structure the data, its just the popup thing i cant get to work. i will also need to save the variables entered, atleast temporary, when structuring the import. ideas?

thanks

nils

Hi Nils,

Your script can place you on a layout containing two global text fields (with popup attached for location and company). After your import, you will have an isolated found set. Your script could then continue and either loop through the records or using Replace Field Contents, setting the two fields with the global data.

Here's the loop and Set Field[] idea:

Import

Loop

Set Field [ Company ; globalCompany ]

Go To Record/Request/Page [ Exit after last ; Next ]

End Loop

Replace Field Contents idea:

Import

Go To Field [ Company ]

Replace Field Contents [ Company ; globalCompany ]

LaRetta

thanks, but i still dont understand how to get the popup-function? its probably just something i cant find in the scripting, but anyhow...

Hi Nils,

You've asked for popup-function, popup window and then described restricting Users to selecting Company and Location, which implies popup Menu on the fields themselves (so Users can't select a non-existant company/location (?). What do you need specific help understanding? FileMaker does NOT provide this functionality built into the import; you will have to create the layout yourself.

LaRetta