Skip to main content
Nintex Community Menu Bar

Allow users to set dates prior to generating DDP?

  • September 18, 2017
  • 2 replies
  • 11 views
  • Translate

Hi everyone,

 

I currently have a DDP set up, which essentially pulls a Salesforce Opportunity report into Excel. The report has been configured and associated with the document package. Depending on who is running the DDP, the preferred dates for the report may fluctuate. Prior to generating the DDP, is it possible to allow a user to enter in a specific date range, or essentially filter the Opportunities displayed in the generated report?

 

Thanks!

John

Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+8
  • Nintex Employee
  • 76 replies
  • September 21, 2017

Hey John Stallings‌,

Absolutely, you can use a Drawloop Form to prompt the user for a start date and end date then pass those dates into the filter dynamically.

https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/manageDDP/FormFields.htm 

For example:  colDt_s=<<Contract_Start_Date__a>>&colDt_e=<<Contract_End_Date__a>>

Cheers,

Ryan

Translate

Hey Ryan,

Thanks for this. Definitely getting me on the right track. I had a few

follow up questions though. Can you explain or is there any additional

documentation around the filter syntax you provided below?

*For

example: colDt_s=<<Contract_Start_Date__a>>&colDt_e=<<Contract_End_Date__a>>*

I have a Form Step created with two form fields, "Report Start Date" and

"Report End Date", which I would like to use to set the filter dates of my

Salesforce report. I added the ranges (RPRT_START & RPRT_END) to my Excel

file and am using an Opportunity report to pull into the DDP. The

Opportunity report is using CloseDate in the filter criteria and I'd like

to pass the Report Start/End Date form fields into the filter. Can you help

to explain what the filter syntax would look like for this?

I noticed that Form Steps are not yet available in Lightning. Do you know

if this is on the road map for the near future?

Thanks,

John

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings