Cognito-forms – Is it possible to link one calendar to another inside the same form

cognito-forms

For example I am creating a form for a custom media production order for a radio station. I have figured out how to get the calendar to skip to three days ahead (the earliest a customer's audio could be ready) for the "Order Start Date" – the earliest day the order can start is three days from the form submission.

However, if the customer selects that they would like "pre approval" of their audio, a calendar pops up with the date they want their proof, and that then goes into the e-mail for our production guys. Thing is, the "order start date" then can't be until two days after pre-approval if the customer wants it. So if say, the customer says they want to pre-approve their audio, then selects a pre-approval date of 8/1 on the calendar that pops up when they click "yes" for pre-approval, I would like the "Order Start Date" to black out to 8/3, not just three days from when then form is submitted.

I'm trying to figure out the logic to get one calendar to call another calendar on the same form.

Is it possible?

Best Answer

I'm a developer with Cognito Forms.

Yes you can do reference another calendar, but it sounds like you have one Minimum value on your Order Start Date and you will then want to replace it with the new Minimum value that would be provided by the 'Pre-approval Date' when its showing.

To do this I created a simple from with just 3 fields.

A Yes/No field titled 'Pre-approve audio' that is always visible.
A Date field titled 'Order start date'that is always visible.
Then another Date field titled 'Pre-approval date' that is only visible when the Yes/No filed, 'Pre-approved audio' is set to yes.

The 'Order start date' then has the following code in the 'Minimum' range value.

=PreapproveAudio ? PreapprovalDate.AddDays(2) : DateTime.Today.AddDays(3)

This will set the date field to check the Yes/No field, and use one of the two minimum dates. If 'Yes' is selected the minimum value cant be before the date in the 'Pre-approval date' + 2 days. If 'No' is selected the minimum value cant be before today's date + 3 days.

I have included a link to my template so that you can copy this form into your Organization and take a look at how the calculations are working.

Linking Calendars template

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

I am a developer for Cognito Forms.

Since February 2015 the following functionality has been made available:

In this example, I am setting the range on the Start Date field to =DateTime.Today. It could have also been =DateTime.Today.AddDays(1) to be tomorrow or later. Calculations are very robust and should cover most scenarios you can dream up, but you can also just enter literal dates.

range field

I then set the range on the End Date to be at least three days after the Start Date, but no more than seven days. Here is the calculation for the End Date minimum:

setting end date minimum

And this is how the Start Date appears on the form, with the days before today disabled:

calendar with days disabled

And similarly for the End Date, with both minimum and maximum date restrictions based on the Start Date.

calendar with days after disabled

The date range for the End Date automatically updates based on changes to the Start Date, so if an End Date is specified and the Start Date is later changed, validation will catch this if the user does not fix it first.

end date validation

Please note that range validation applies to Date, Number and Currency fields, not just the dates included in this example.

Cognito-forms – Repeating section in Cognito Forms with variable costs

There are a couple of ways to handle this in Cognito Forms:

Include the camper registration fee of $60 for each camper as part of the repeating section. Then add a Price field for the multi-camper discount below the repeating section, using a calculation like =Campers.Count() > 1 ? (Campers.Count() - 1) * -30 : 0. You can hide this Price field or make it only appear when the discount is not zero. This would produce a receipt like:
```
Camper 1   
    James Philips        $60.00 
Camper 2   
    John Cartin          $60.00 
Camper 3 
    Parker Owens         $60.00
Multi-Camper Discount   ($60.00)
--------------------------------
Subtotal                $120.00
```
You could also charge $30 for each camper and have a separate $30 registration fee that applies to each application. I definitely prefer the first option since it clearly identifies the discount on the receipt.

Long term, it sounds like you would benefit from being able to use the Index of the item in the repeating section within calculations. We are looking at ways to make additional information like this available to calculations. In the mean time, hopefully these suggestions will meet your needs.

Best Answer

Related Solutions

Cognito-forms – Calendar calculation in Cognito Forms

Cognito-forms – Repeating section in Cognito Forms with variable costs

Related Topic