Newbie Questions

Re: Formula for Next Day of the Week

dblakester — Wed, 27 Apr 2016 14:06:32 GMT

Thank you very much for all your help! It will make a world of difference in my form.

Re: Formula for Next Day of the Week

wilkies0106aw — Tue, 26 Apr 2016 09:11:07 GMT

Not the prettiest, I'm sure there is an all in one rule, but cracked it.

Add a field called CurrentTime with the default value - substring-after(now(), "T")

Then on field 2 with the rule called Tuesday before 11 add the following condition field2=0 and CurrentTime is less than 11:00:00

Set field3=field1

Re: Formula for Next Day of the Week

dblakester — Mon, 25 Apr 2016 23:53:12 GMT

Thank you very much for you efforts and response. I'll keep looking for your solution for the 1100 cut-off time and look forward to incorporating your solutions into my form. I've attached a copy of my form that I'm trying to incorporate your solution into. The "CCB Meeting" cell is where I'm looking for the date to show when the form is opened before it is submitted. Thanks again for all your help! Dennis

Re: Formula for Next Day of the Week

wilkies0106aw — Mon, 25 Apr 2016 16:19:12 GMT

Attached certainly is the basics of the form for each Tuesday. The only piece I've not been able to test is being on a Tuesday before 11. If I'm in the office hopefully I can test tomorrow, but this should get you going.

Formula for Next Day of the Week

dblakester — Thu, 21 Apr 2016 05:21:21 GMT

I'm sure there is a way to do this but I'm too new to figure it out. My Change Request form is filled out by the requestor, and I need the meeting date field to display the next meeting, which are always on Tuesday's at 1300. On the morning of the meeting, I have a cut-off time of 1100 so I need any forms filled out after 1100 on Tuesday to display next Tuesday's date. Hopefully, this explanation makes sense. Thank you for any help!