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

Question

Question

Count of collection rows <= current month and > current month

asked on November 7, 2021

Hello -

 

I have a form where we have a collection beginning with a drop-down of the Month/Year for a payment.  These payments can also extend into future months.  We have two fields at the end of the form summarizing the # of past months and # of future months in the request.  We would like a way to have our Past Months and Future months fields already totalled, instead of manually having to count and enter the # into those fields.

 

The drop-down for the dates are not in date format, but rather just the month abbreviation {dash} year.  Seems like something for Javascript?  Has anyone had to do something like this before and would share how they accomplished it?

Thanks everyone in advance and happy developing !

 

0 0

Replies

replied on November 8, 2021 Show version history

In the past I've used the SUMIF formula to calculate those fields from the table.

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

Sign in to reply to this post.