You are viewing limited content. For full access, please sign in.

Question

Question

Draft Copy of Form

asked on August 7, 2019

We have a fairly complicated form going live and there are some concerns regarding the saved copies of drafts. This form is several pages long and requires a level of detail from the applicant that they will most certainly not be able to complete it in one sitting.  We have enabled the option of saving a draft of the form, however, the concern is that if there are any changes to the form itself while an applicant has the form saved as a draft, it will allow them to complete the form but then error upon submission and completely wipe clean everything they had completed.

While we will try to limit the number of changes we make to the form once it is live to a "scheduled update", there are two times during the year that a "late deadline" date field will have to be changed (at which time the charges would include a late fee).  I have a few questions about that:

 

1)  The late fee would always be the same date, the only reason why we have to change it is because the of the year. Is there a way to say that if the date was between 10/2 - 11/15 and 3/2 - 4/15 (regardless of the year) that there is an extra $200 charged?  This would prevent us from having to change that date field twice a year.

2)   Is there any way for the applicants to print or download their saved draft so they don't run the risk of losing all of the information they have entered? Our application (for a state bar exam) is 13 pages long. It is very concerning that they could get all the way through their form without it erroring until it fails on submission and then loses everything? 

I'm happy to provide more info on how the date fields and late fees are currently set up, if it's helpful. 

Thanks for your help! 

0 0

Answer

SELECTED ANSWER
replied on August 8, 2019

Hi Jenni, the answer is yes to your question.

Using a populated Date field it is possible to test if the dates fall inside of the range you speak about. 

Using the following Formula I am testing a date field (Named SubDate) to see if it falls between 10/2/ to 10/15 of the current year or 11/2 and 11/15 of the current year. My response is True or False which could be used a trigger of it could be a number value used in a calculation such as 0 or 200 which would be used to calculate fees. Please note if you are going to be returning a number to use in a calculation, to use a Number field for this formula.

=IF(AND(SubDate>DATE(YEAR(NOW()),10,2),SubDate<DATE(YEAR(NOW()),10,15)),"TRUE",IF(AND(SubDate>DATE(YEAR(NOW()),11,2),SubDate<DATE(YEAR(NOW()),11,15)),"TRUE","FALSE"))

 

FYI,

Year(NOW()) grabs the current year from your system date,

DATE is created (Year, Month,day) in case you want to edit it.

If you wanted True or False to instead be Numeric values, True would be 200, False would be 0

Hope this helps and happy testing

0 0
replied on August 9, 2019

Hi Steve, 

It is erroring stating there is an invalid variable in the formula. Can you see anything off? It looks pretty straight forward from here. 

Also, if I wanted to test it and use August, do I use 08 or 8?

Thanks for your help! 

0 0
replied on August 9, 2019 Show version history

Hi Jenni, either works on my system but I am running 10.4.1.

I would recommend just using the single digit.

 

What is you Date Fields Variable Name?

What type of field did you put the formula into (Single Line, Number)?

Please provide a copy of what you put in your form.

0 0
replied on August 9, 2019

Oh Wait! I think I know what I did!  stand by ... :)

0 0
replied on August 9, 2019

Works like a charm, thank you SO MUCH!  Have a great weekend!

0 0

Replies

replied on August 9, 2019

Thank you for the response!  I will test that out!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.