Limit registrations per date - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Limit registrations per date

Last post 04-10-2019 08:37 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 04-02-2019 09:14 AM

    Limit registrations per date

    Hi All, I have a list in which preferred date is a choice column with 15th April, 25 April, 30 april. I have to restrict users to submit the entries upto 50 not more than per date. Let's say there are already fifty entries for 15 April, we should not allow user to submit the entry and show message saying that there are already fifty entries can't be more that, please select other date. Regards, Raman
    Ramanjjilu Naidu
    Filed under:
  • 04-10-2019 08:37 AM In reply to

    Re: Limit registrations per date

    I guess what I would do is on the submit rules run a query to get back all the rows that match on date, and then use the count function to determine if this should be allowed to submit. If you have trouble with the date format for the query put the query and data fields on the form with a button to run the query, for test purposes, and try a variety of formats - you may need to include time: 2019-04-15T00:00:00 for example.
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.