Jump to content

Formatting the Return


Recommended Posts

Hi all, I am new to FusionPro and have a kind of complex project. I have several requirements that need to be met and I hope someone can help me with the JavaScript.


In the database are several key fields that I am using and several that are not used at all. Key fields are Dept, Description, Size, and several pricing columns, I need to run a variable job dropping the Description and Size in and then the price with the proper formatting which changes based on what the price is, i.e. 1.99 formats differently then 2/5.00 etc. (as an example the 1.99 would be just the price no $ sign, all the same size, versus the 2/5.00 would be 2/$5 with the 2 and $ superscripted.) I think there is a total of 8 pricing styles that format differently. There is a total of 22 diff pricing columns in the database. I plan on running each column as a separate job.


Another thing is if there is a Description and Size but NO price then I need to skip that record.


One last complexity is based on the Dept field. Depending on which department the product is for each record will get 0, 1 or 2 - 11x7 signs and 0, 1 or 2 - 5.5x3.5 signs.


I am attaching a tab delimited txt file and a pdf showing a couple of pricing samples.


Yea I know this has gotten very crazy, any help would be much appreciated!!!

WeeklyAd SALE-SamplePages.pdf

a.e. 10_18 Weekly Ad SALE Signs-sample.txt

Edited by Velotypo
Link to comment
Share on other sites

Hi Velo,

I would start with creating a 5.5 x 3.5 template and insert pages as needed depending on the formatting requirements. Attached is a project that you can view which has different formatting requirements. It is not the best written for FP but it works and should give you an idea.


On your data I couldn't figure out what you had for delimiter.




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...