Skip to main content
Nintex Community Menu Bar

Nintex Workflow - Workflow Schedule Date and pulling information Multiple lines of text box

  • June 18, 2020
  • 5 replies
  • 14 views

Forum|alt.badge.img+2

Hi all

 

2 Questions please.

  1. I have a workflow set up and scheduled to run @ 6am each day. It looks at another list within the site and pulls information items created within the last 24 hours. Ideally, I would like it to pick up any item that was created in the 24 hours from 6am the prior day to 6am today. I am not able to get this to work as the workflow always only picks up the prior days items no matter what I do with the Calculated Date action.
  2. Within the other list there are 2 Multiple lines of text fields which I am pulling information from via a variable and then inserted into an email summary. For some reason this data is being capped at 50 characters and I again can't figure out why that is.

5 replies

Forum|alt.badge.img+8
  • Novice
  • June 18, 2020

Hi @Amok7__5,

  1. You should be able to do
    1. Calculate date
      Date: Use date when action is executed, include time
      Hours: -24
      store in variable "targetDate"
    2. Query list
      Where Created >= targetDate
  2. Is the variable you store the info in also of type multiple lines of text?

Forum|alt.badge.img+2
  • Author
  • Rookie
  • June 18, 2020

Thanks Tarf

 

I had these tasks set up aready as attached but no deal 

Still only getting yesterdays results - not sure what I am doing wrong .


Forum|alt.badge.img+2
  • Author
  • Rookie
  • June 18, 2020
Oh and apologies - figured out my mistake for #2 Rookie error

Forum|alt.badge.img+8
  • Novice
  • June 23, 2020

Hi @Amok7__5,

in your query list, your are only pulling elements with created equal to your variable.
You want greater than or equal to.


Forum|alt.badge.img+2
  • Author
  • Rookie
  • June 23, 2020
Thanks Tarf 🙂

I tried greater than or equal to which provided every item on the list
Then tried less than or equal to which provided all items created yesterday again.

Please can I ask you to confirm again.