Closed

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.

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

Skills: Electronic Forms, Format & Layout, PHP

See more: sports programming, php color code, one line programming job, it field, html spreadsheet example, html spreadsheet code, how code, example dynamic programming, dynamic programming example, dynamic programming code, database one word two, conditional programming, concept dynamic programming, code line, code electronic, adobe indesign job, excel spreadsheet labels, spreadsheet wordpress, name red, cotton , color red, code programming, code name one, at labels, excel php dynamic

About the Employer:
( 0 reviews ) United States

Project ID: #1243959

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

SigmaVisual

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

$15 USD / hour
(248 Reviews)
7.9
jefftyler

HELLO SIR PLEASE CHECK PMB

$15 USD / hour
(0 Reviews)
0.0