Can I use a dynamic form rule to change value in lookup field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have our projects classified into master projects (stored in a table called Master Projects) which is related one-to-many to our projects table with the field Master Project Name. On our project intake form (on the projects/child table), we have a field called "Project Type." I placed the "Master Project Name" field (lookup field) on the form at the bottom.

I have a dynamic form rule set that when Project Type is equal to "Type A" to set Master Project Name to "A". However, it isn't working. What am I doing wrong?

Photo of Jason

Jason

  • 152 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,658 Points 50k badge 2x thumb
Try changing the rule to

when Project Type is equal to "Type A" to set Related Master Project to .....
Photo of Jason

Jason

  • 152 Points 100 badge 2x thumb
This worked once I made sure that "Everyone on the Internet" could also view all records from the Master Projects table. Thank you!