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.

conditional auto enter field

smith
in Script Workspace and Script Triggers

Featured Replies

I have a report card database for 6 schools - the Report Card (RC) ID is slightly different for each school - A-RC0506-1, C-RC0506-1, etc. (The first letter of the RC ID is based on the first letter of the respective school.)

How do I set conditions in an "Add a New Record" script that auto enters the RC ID based on the last record for that specific school?

For example, the Day School has 403 records, each RC ID increases by 1, so the last record is D-RC0506-403. How do I write the new record request for adding a new student for the Day School comes in at D-0506-404? Is it defined in the RC field as a calculated field, or is it defined at the "New Record Request" level? And what are the steps? Thanks.

Create separate fields for School ID and Student Number.

Create a self-join relationship called 'School' = School ID::School ID.

When you create a new record (using a script, I hope) make sure you have entered the School ID then add the following

Set Field(Student Number, max(School::Student Number) + 1)

Create an account or sign in to comment

https://fmforums.com/topic/37854-conditional-auto-enter-field/
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.