cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Need help for separating dates and creating a flexible table.

Jump to solution

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!

Labels: (2)
0 Kudos
Reply
7 Replies
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

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>
Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

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.

Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

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

Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

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.

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

0 Kudos
Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

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

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

0 Kudos
Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

Hi Marian,

Thank you so much. I already finished the project .

0 Kudos
Reply
Workflow Hero

Re: Need help for separating dates and creating a flexible table.

Jump to solution

great!

if you got a solution mark the question answered.

0 Kudos
Reply