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.
Let SharePoint do that work, add a calculated field on your list
But I want it to be available on a newly created form, and that doesn't work. So I'm stumped.
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
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.
Hey Alice,
thath shouldn't be a big problem:
- Drag a single line textbox onto your form where you want to display the value
- Configure the control ("Advanced" tab)
- Store Client ID in JavaScript variable = Yes
- 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
Just note that this won't work on mobile -- but if you don't need mobile, this is a great way to do it!
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
Thank you Philipp, that's really helpful.
Wow this is also really helpful - thank you Andrew
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.