cancel
Showing results for 
Search instead for 
Did you mean: 
alice_oneill
Nintex Newbie

Working out the weekday on a Nintex form

Jump to solution

Hi, is there any way to calculate the day of the week and put it in a field on a Nintex form? I need to display certain fields depending on the week day on which a form was created.

Labels: (1)
Tags (1)
Reply
9 Replies
fhunth
Nintex Newbie

Re: Working out the weekday on a Nintex form

Jump to solution

Let SharePoint do that work, add a calculated field on your list

Reply
alice_oneill
Nintex Newbie

Re: Working out the weekday on a Nintex form

Jump to solution

But I want it to be available on a newly created form, and that doesn't work. So I'm stumped.

Reply
Automation Master
Automation Master

Re: Working out the weekday on a Nintex form

Jump to solution

Hi Alice,

if JavaScript is an option you can use the custom javascript section of your form.

var d = new Date();
var weekday = new Array(7);
weekday[0] =  "Sunday";
weekday[1] = "Monday";
weekday[2] = "Tuesday";
weekday[3] = "Wednesday";
weekday[4] = "Thursday";
weekday[5] = "Friday";
weekday[6] = "Saturday";

var n = weekday[d.getDay()];

 

Reference: JavaScript getDay() Method 

Afterwards you only need to populate "n" to your control.

Cheers

Philipp

Reply
alice_oneill
Nintex Newbie

Re: Working out the weekday on a Nintex form

Jump to solution

That is a very good idea. The only problem is that I can't work out how to write that value back to a field on my form! Do you know how to do that? I'm completely puzzled by it.

Thanks.

Alice.

Reply
Automation Master
Automation Master

Re: Working out the weekday on a Nintex form

Jump to solution

Hey Alice,

thath shouldn't be a big problem:

  1. Drag a single line textbox onto your form where you want to display the value
  2. Configure the control ("Advanced" tab)
    1. Store Client ID in JavaScript variable = Yes
    2. Client ID JavaScript variable name = some simple string

Query that control from your JS code and set the value. Something like that should do the trick:

NWF$("#" + weekdaytxt).val(n)

Best Regards

Philipp

Reply
Automation Master
Automation Master

Re: Working out the weekday on a Nintex form

Jump to solution

Just note that this won't work on mobile -- but if you don't need mobile, this is a great way to do it!

Reply
Highlighted
alice_oneill
Nintex Newbie

Re: Working out the weekday on a Nintex form

Jump to solution

Thank you Philipp, that's really helpful.

0 Kudos
Reply
Automation Master
Automation Master

Re: Working out the weekday on a Nintex form

Jump to solution

You can do this directly on the form and then save the value you want into a sharepoint column.

You see Wednesday on this form. It is a calculated control that is connected to a SharePoint column. So the value that is in the New Form will be saved to SharePoint.

Just drop a calculated control on the form, set the connected to dropdown, and add the formula.

I used the formatDate formula on the Common context Current Date

formatDate(Current Date, "dddd")

"dddd" provides the name of the day of the week.

See the blog Date and Time Format Strings - Quick Reference Guide  for more options on formatting. You can do "dd" for 04 being 4/4/18 today and "ddd" for Wed

Reply
alice_oneill
Nintex Newbie

Re: Working out the weekday on a Nintex form

Jump to solution

Wow this is also really helpful - thank you Andrew

0 Kudos
Reply