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.

Auto Enter another field value.

Featured Replies

How would I calculate a field so that it enters another field value if it is empty?

I know this is simple, but I have never done this. Is it under auto enter or validation?

So what you want is a second field that has it's value set depending on whether or not the first field is empty? That's not too difficult. Just have the 2nd field be a calculation with an if statement in it. A double set of quotes equals empty.

field2=if(field1="", "it's empty", "it's full")

  • Author

Actually, I want the second field to display what is in the first field if nothing has been entered into the second.

How about this: If a certain checkbox is clicked, then the second field displays what is in the first field?

  • Author

Or to make it more complicated:

there are three fields with a checkbox over them.

If the checkbox is checked over one, it sets a fourth field to that value and removes any other checks.

And if none are checked, then the fourth field uses the first value.

Does that make any sense?

And if none are checked, then the fourth field uses the first value.

Does that make any sense?

If none are checked, there is no value in the first field. confused.gif

If you want to get the first value of a value list if none is checked, here is one solution.

Create a concanated field for value 1,2 and 3 c_concanate = Field1 & " " &Field2 & " " &Field3

With value list checkbox Yes No

c_field4 = Case(IsEmpty(c_concanate), Left(ValueListItem(Status(CurrentFile), "yourvaluelistname"), 3*), Case( not IsEmpty(Field 1),Field 1, Case( not IsEmpty(Field 2), Field 2, Case( not IsEmpty(Field 3), Field 3))))

*3 for Yes

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.