DataMerge Code Snippit with Field and Column Name supression

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.


<<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

Skills: Electronic Forms, Format & Layout, PHP

See more: what is dynamic programming, what can you do with programming, Sports Programming, php job application form code, php color code, one line programming job, ms excel programming, it field, html spreadsheet example, html spreadsheet code, html form to spreadsheet, how to do dynamic programming, how code, example of dynamic programming, dynamic programming example, dynamic programming code, database one word or two, conditional programming, concept of dynamic programming, code line, code electronic, adobe indesign job, programming with excel, excel spreadsheet to labels, word to indesign

About the Employer:
( 0 reviews ) United States

Project ID: #1243959

2 freelancers are bidding on average $15/hour for this job


We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$15 USD / hour
(248 Reviews)


$15 USD / hour
(0 Reviews)