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.

Help with Value List to Add Days to a textbox

Featured Replies

I have a HireDate field for each employee.

I have a Pay Class field structured as a Pop up Menu with the following list values:

1. A03

2. A01

3. A06

4. Facility

I also have 6 textboxes named the following:

1. Review Dates 1

2. Review Dates 2

3. Review Dates 3

4. Facility Reap

5. Facility P& T

6. Annual Review

Note: Review Dates 1, 2, 3 are date fields.

Question:

Please help!!!!! How do I do this?

If user clicks on A03 then Review Dates 1 field should be hiredate + 35 days

and Review Dates 2 field should be hireDate + 70 days

and Review Dates 3 field should be hireDate + 90 days note: results should be in date format

If user clicks on A01 or A06 then Review Dates 1 field should be HireDate + 90 days

And Review Dates 2 field should be HireDate + 180 days Notes: Results should be in date format

If user clicks on Facility then it will populate Facility Reap field with text of “March” and Facility P& T field with text of “June” and Annual Review with text of “December”

From the information you have provided it appears your "6 textboxes" should be calculations, for example:

Review Dates 1 (Unstored, calculation result is Date) = Case(Pay Class = "A03"; Hire Date + 35; Pay Class = "A01" or Pay Class = "A06"; Hire Date + 90)

Facility Reap (Unstored, calculation result is Text) = If(Pay Class = "Facility"; "March")

  • Author

Yes it worked. Thank you so so so so much.

Create an account or sign in to comment

Important Information

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

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.