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>
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.
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
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.
create within the loop only table rows as I've shown above.
enclose table rows by table (and possibly tbody) tag after the loop.
Hi Marian,
Thank you so much. I already finished the project 
.
great!
if you got a solution mark the question answered.
