1

How to Use Constraints

Hi all,

Been struggling to understand how to utilise the Constraint field when i have 2 tables linked together.

Table 1 is Staff details which contains everything about a certain staff member, including their position.

Table 2 is a daily running log.

I have a field that is reference from daily running log to staff details in a drop down box view.

How do i use the constraint section to only show staff who's position is "Managers"

4 replies

null
    • Cloud DevOps Fullstack Engineer
    • Martin_Mueller
    • 1 yr ago
    • Reported - view

    I think a better use would be the "Readable if" function. Here is one example 

    Anlagenbauer = user() or userRole() = "admin"

    Where Anlagenbauer is a user field.

    • Fred
    • 1 yr ago
    • Reported - view

    It took me awhile to get a feel for constraints as well.

    When you open the constraints window you see “a (Log)” and “b (Staff)” on the left side. Depending on the kind of field position is, Text, Choice, or Dynamic Choice, will depend on how you try solve it.

    text:
b.position = "Manager"

choice:
b.position = 1 or text(b.position) = "Manager"

dynamic choice:
b.dChoice = 3 <- record number that has "Manager"
      • Admin.11
      • 1 yr ago
      • Reported - view

      Fred Thanks for your help.

      the position field is choice field.

      the Position i would like to show in the combo box that is linked is "Skipper" or 1.

      Ive tried: b.Position = 1 but it is still showing all staff regardless of their position.

      • Admin.11
      • 1 yr ago
      • Reported - view

      Fred Literally just worked it out. had to use

      a.'Pre-Start Skipper'.Position = 1

      which is log clicking on the linked combo box and then clicking on position = 1

Login to reply

Content aside

  • 1 Likes
  • 1 yr agoLast active
  • 4Replies
  • 323Views
  • 3 Following