Completed

Filemaker Pro Script Assistance

We print designs to different products and sell them online. I am using FMP to keep all the information about the individual items we print to and the many designs we can print to those items. from these separate PRODUCT and DESIGN databases I am trying to create a merged file to upload to the webstores.

I don't need any of the export information stored .. just exported like a mailmerge.

the DESIGN_CODE will match many records the PROD_CODE will match one.

For the example in the database I shared in my last post:

1) the user is prompted for DESIGN_CODE and PROD_CODE

2) FM finds ALL the matching DESIGN_CODE records

3) for each DESIGN record being exported - an export field will be created that combines the text from the current PROD_DESC record from PRODUCTS and the text from the SINGLE record found based on the input in the DESIGN table.

in basic old fashion programming logic: (obviously in just logic/concept form as I have not worked with FMP scripting and don't know the syntax yet)

get user input DESIGN_CODE from tableDESIGN (will be many records)

get user input PROD_CODE from tablePRODUCTS (will be one record)

var NUM_OF_DESIGNRECORDS = number total PROD_CODE records matching

while NUM_OF_DESIGNRECORDS > 0

do export

export PRODUCT:PROD_CODE as field PROD_CODE

export DESIGN:DESIGN_CODE as field DESIGN_CODE

export DESIGN:DESIGN_SUBCODE as field DESIGN_SUBCODE

export calculation of PRODUCT:PROD_DESC + " - " + DESIGN:DESIGN:DESC as field COMB_DESC (simply adding both product and design descriptions with a dash inbetween)

export PRODUCT:PRICE as PRICE

NUM_OF_DESIGNRECORDS = NUM_OF_DESIGNRECORDS - 1

end

LOL I am sure the logic and loop above reveal that I am old school as I was a computer science major when FileMaker was first released in 1985

I am including an image to help visualize my request:

in yellow: the records found based on user input of KRING for PRODUCT and FLWR for DESIGN

in pink are the fields needed from the PRODUCT records found

in red are the fields needed from multiple DESIGN records found

Skills: FileMaker

See more: adult script pro, script php filemaker, adult script pro questions, database administration, database development, mac os, database programming, cnc script pro, script pro add, dating script pro, magento report products ordered current stock, adult script pro templates, adult script pro template, html script pro xy maker, assistance php pro bid, free script creation automatic single web page, million pixel script pro texmedia download, java script pro, perl script unzip extract single file, million pixel script pro

About the Employer:
( 1 review ) Davie, United States

Project ID: #13306072

Awarded to:

skywillmott

Hello, Yes, this is something I can do for you. I have already used your provided information to create a sample file which you can take a look at. The file will open automatically using a non-admin account, though More

$160 USD in 2 days
(11 Reviews)
4.9

3 freelancers are bidding on average $207 for this job

ausprofreelancer

Hello I have over 28 years extensive experience with Filemaker Pro (almost as far back as when you first used the original FileMaker as well) and have developed, deployed and maintained many instances from very large More

$250 USD in 3 days
(6 Reviews)
5.4
tattwam

Hello. I have experience of FileMaker for 3+ years. I have understood your Requirement and I can work on that. We can have combined efforts to make your solution powerful.

$211 USD in 2 days
(1 Review)
0.6