Velotypo Posted October 24, 2016 Share Posted October 24, 2016 (edited) 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.pdfa.e. 10_18 Weekly Ad SALE Signs-sample.txt Edited October 24, 2016 by Velotypo Quote Link to comment Share on other sites More sharing options...
Leosmith Posted October 24, 2016 Share Posted October 24, 2016 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. LeoM_EDLP_FP.zip Quote Link to comment Share on other sites More sharing options...
Velotypo Posted October 24, 2016 Author Share Posted October 24, 2016 The data is Tab delimited Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.