Need help for separating dates and creating a flexible table.

  • 24 February 2017
  • 7 replies
  • 1 view

Badge +7

I'm new to the sharepoint nintex workflow environment so I am not very familiar with some of the features. I have a project that will get all the events that will happen on that week and send it to email notification. My problem is one of the requirements is the weekdays should be separated to the weekends event.

What I did is:

1. Calculate date - to get the span of the date that is needed to be extracted and store it in a variable "EndDate(Date)"

2. Query list - to query on the list and store it into a variable "collectionID(collection)"

3. For each - to loop through each item in "collectionID" and store it in "varEventID(List Item)"

4. Parallel action - 

    4.1. Set Variable - Store the event name for a single line text variable

    4.2. Set Variable - Store the start time for a single line text variable

    4.3. Set Variable - Store the end time for a single line text variable

5. Build String - to store value that i set and will be used for notification

6. Send notification.

what I need to do is to separate the week end events and week days.

Also, is there a way in nintex workflow to create a flexible table base on how many inputs have been gathered?

Any suggestion will be a great help thank you in advance!


7 replies

Userlevel 5
Badge +14

what I need to do is to separate the week end events and week days.

can you explain further what you mean with 'separate'?

do you want to send weekend event in separate mail?

do you just want to highlight them in mail in another color?

anything else?

Also, is there a way in nintex workflow to create a flexible table base on how many inputs have been gathered?

the same way as you now build simple string with build string action you can build HTML table like

<tr><td>Monday</td><td>event_start_time</td><td>event_end_time</td></tr>
Badge +7

Hi Marian,

In one email I need to have 2 tables. 1 table for weekend events and 1 table for weekdays event and after running my workflow the email content is like this

Event Title 1 - 2/24/2017 8:00:00 PM / 2/24/2017 9:00:00 PM

Event Title 2 - 2/25/2017 4:00:00 PM / 2/25/2017 7:00:00 PM

Event Title 3 - 2/26/2017 10:00:00 PM / 2/26/2017 11:00:00 PM

Event Title 4 - 2/27/2017 10:00:00 PM / 2/27/2017 11:00:00 PM

Event Title 5 - 2/28/2017 10:00:00 PM / 2/28/2017 11:00:00 PM

Event Title 6 - 3/1/2017 10:00:00 PM / 3/1/2017 11:00:00 PM

My expected result should be the date 2/25 to 2/26 should be on a different table given that they are weekends.

Event Title 2 - 2/25/2017 4:00:00 PM / 2/25/2017 7:00:00 PM

Event Title 3 - 2/26/2017 10:00:00 PM / 2/26/2017 11:00:00 PM

Event Title 1 - 2/24/2017 8:00:00 PM / 2/24/2017 9:00:00 PM

Event Title 4 - 2/27/2017 10:00:00 PM / 2/27/2017 11:00:00 PM

Event Title 5 - 2/28/2017 10:00:00 PM / 2/28/2017 11:00:00 PM

Event Title 6 - 3/1/2017 10:00:00 PM / 3/1/2017 11:00:00 PM

Also, Those output in email is only 3 variables (Title, Start date, and End date) so if I put it on a table it will only be getting 1 row for all those events. What I mean is it is possible to have each of the event to have 1 row. Also thank you for telling me that HTML is doable in nintex.

Userlevel 5
Badge +14

ok then I would suggest following

- use fn-FormatDate inline function to get day name abbreviation. function should look like

  fn-FormatDate(StartDate,'ddd')

- then check - if it falls to week day then append it to one variable/table, if it falls to weekend append it to another variable/table

having events in two variables/tables you can format notification as you like

Also, Those output in email is only 3 variables (Title, Start date, and End date) so if I put it on a table it will only be getting 1 row for all those events. What I mean is it is possible to have each of the event to have 1 row.

I somehow do not get what you mean with this.

doesn't my former example gives what you need? it should produce one table row per event

Badge +7

Sorry for not being clear. What I mean is that the loop gives me 1 table for every events and its dates. So if I have 5 events the loop I created will create 5 tables.

199953_pastedImage_1.png

What I mean is how can I create a 1 table that it's contents is all the events.

Userlevel 5
Badge +14

create within the loop only table rows as I've shown above.

enclose table rows by table (and possibly tbody) tag after the loop.

Badge +7

Hi Marian,

Thank you so much. I already finished the project happy.png.

Userlevel 5
Badge +14

great!

if you got a solution mark the question answered.

Reply