Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Event Sign-ups

Greg M
in Relationships

Featured Replies

I have 2 related databases that I use to allow people to sign up for weekend activities at my school. Signups is the database for public use. Each signup is one record, containing the person's name, and the activity they want to attend (selected from a dropdown menu.) Events is the admin database that has one activity per record, containing the event name, date, capacity, etc. There is also a portal to Signups that lists the names of those who have signed up. Here's my question: when a user goes into Signups, selects the activity they want, and click "Sign up" how can I have a script check to see that the maximum capacity for that activity hasn't been exceeded?

Version: v6.x

The Events records contain a repeating field of the participants with a Capacity field, correct? If so, just use a relationship between the activity id in Signups and Events.

If [Count(rel::Attendees) = rel::Capacity]

Show Message ["I'm sorry, but this activity is full."]

Halt Script

End If

  • Author

Nope, it doesn't use repeating fields. The Events database has a portal that displays names from the related records in the Signups database.

  • Author

Never mind, got it. Thanks!

Create an account or sign in to comment

https://fmforums.com/topic/21021-event-sign-ups/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.