Creating PDFs from WordPress Forms with Gravity Forms (Part 2) 🎥
📋 Overview
Creating PDFs from WordPress Forms with Gravity Forms (Part 2)
This video was created by one of our customers
In this Video we
1. Loading Data in SQL
2. Creating Report
3. Creating parameters
4. Loading report
Original forum post can be found here
https://www.etl-tools.com/forum/advan...
chatgpt prompt
DECLARE @json NVarChar(max)
select top 1 @json=text_field_02 from event_log where id =:sqlparamater;
SELECT * FROM OpenJson(@json)
WITH (
"mobile" VARCHAR(100) '$."{{mobile}}"',
"candidate_ID" VARCHAR(100) '$."{{candidate_id}}"',
"candidate_name" VARCHAR(100) '$."{{candidate_name}}"',
"candidate_address" VARCHAR(100) '$."{{candidate_address}}"',
"candidate_position" VARCHAR(100) '$."{{candidate_position}}"',
"candidate_ctc" VARCHAR(100) '$."{{candidate_ctc}}"',
"join_date" VARCHAR(100) '$."{{join_date}}"',
"join_company" VARCHAR(100) '$."{{join_company}}"',
"company_address" VARCHAR(200) '$."{{company_address}}"',
"company_logo" VARCHAR(100) '$."{{company_logo}}"',
"appointment_id" VARCHAR(100) '$."{{appointment_id}}"'
)
Using above references as a template , adapt above code to include following fields and give me the new SQL code. I am using SQL 2019 and above code works. Remove the fields not relevant and add the ones which are .
🔗 Download Advanced ETL Processor
Try it yourself:
https://www.etl-tools.com/advanced-et...
❓ Need Help?
For assistance with data transformation or setting up automation, visit our support forum:
https://www.etl-tools.com/forum.html
👍 Found This Tutorial Helpful?
If this video helped you, consider giving it a thumbs up and subscribing to the channel for more powerful ETL and automation tutorials!
#AETL #WordPressAutomation #PDFGeneration #DataAutomation #AdvancedETLProcessor