Forms Next Month Date Auto Populate

asked on April 14

Hello everyone,

I have a process, can anyone help?

here's the details,

I created a form that includes a dropdown list for Calibration Frequency. This dropdown lets the user select how often the calibration should be done — like Monthly, Quarterly, Annually, or every few years.

Alongside that, there's a field called Date of Last Calibration where the user can input the most recent calibration date.

Now, what I want to do is this:
When a user selects a frequency and enters the last calibrated date, the form should automatically calculate and populate the next calibration due date based on that information.

For example:

If someone selects “Monthly” and enters March 1, 2025, then the Calibration Due Date should automatically show April 1, 2025.
If they choose “Every 2 years” with the same last calibrated date, the due date should show March 1, 2027.

How can I set this up using only a calculation or formula, without using JavaScript?

0 0

replied on April 14

I think the best way way to achieve this would be to assign month values to the labels of the Calibration Frequency field and then use this value in a formula using the "ADD_MONTH" function.

This formula would then be applied to the Calibration Due Date field:

=ADD_MONTHS(Date_Last_Calibrated, Calibration_Frequency)

There is also the "EDATE" function which pretty much does the same thing so take your pick!

3 0

replied on April 14

I tried following your instructions but there's an calculation error.

0 0

replied on April 15 • Show version history

I can't tell but is this a table or collection? If so, it will have to be index.

Try this:

=ADD_MONTHS(INDEX(CollectionName.Date_Last_Calibrated,ROW()), INDEX(CollectionName.Calibration_Frequency,ROW()))

Make sure you change CollectionName according to your actual collectionName

1 0

replied on April 15

As Carlos says it does look like you need to incorporate an index to the formula as it appears to be a table. In which case something like this should work, just replace the variable names:

=ADD_MONTHS(INDEX(tblDateCal.vLastCalDate,ROW()), INDEX(tblDateCal.vCalFreq,ROW()))

0 0

Question

Question

Forms Next Month Date Auto Populate

Replies

Sign in to reply to this post.