DataMerge Code Snippit with Field and Column Name supression
$15-25 USD / hour
已关闭
已发布超过 12 年前
$15-25 USD / hour
I have a long data form created in Formidable that is being use in WordPress. We wish to take the tab-delimited output which I can move into an Excel spreadsheet, and build nice pages to print, preferably in Adobe inDesign or MS Word. It could also be done in HTML or PHP if that's what gets the job done.
The key is that I want to suppress any record's field that does not contain a dynamic value. But, that's the easy part. I can do that with the built-in programming. What I also need to do is also suppress a corresponding static field name and line space, probably through some sort of conditional logic.
Example:
<<Record 1>>
Static Text Label Dynamic field Value from DB
Color: Red
Size: Large
Material: Cotton
Water Resistance: [empty field]
Application: Sports
Warranty: [empty field]
Weight: 2 pounds
<<next record>>
In this case, what I want to eliminate from my page are the text labels and the dynamic values and the line spaces from the two fields that are empty, Water Resistance and Warranty. Thus the display would show:
Color: Red
Size: Large
Material: Cotton
Application: Sports
Weight: 2 pounds
There are perhaps 100 fields in the database form. I expect that I'll be actually showing no more than half at any one time.
This is a quickie project to show me how to do it, no more than two hours. But I need you to show me proof of concept.
Thanks -ab