Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.

Little lost on creating PDF form based on spreadsheet


Former Community Member

Hi all,

Here at work, they use alot of spreadsheets set up as fill in "forms". Some have pretty complex lookup formulas of varous named ranges inside the spreadsheet.

I'm not sure what the best way to recreate similar funtionality within a PDF form. I can get the basic fields done without a problem but am lost at this point on how to translate those lookup formulas to LC.

I'm guessing this would best be done with a table bound to some database but since I'm pretty new to LC I'm a bit unsure what the best practice might be.

Any suggestions on what I can do?

Simplied Example: User selects an item from a dropdown. Then in the next cell, enters a number (lbs). The next cell does a vlookup what they select in the dropdown, and returns 3rd column and multiplies by the amount in the second cell.


0 Replies