Hi want to write a formula to show and hide fields on a form which is in Table 3.
Table 1 has one to many relation ship with Table 3. (not sure if it even matters)
Table 2 has one to many relation ship with Table 3(not sure if it even matters)
So few questions on this?
- Do i write this formula in Table3 - Advance Settings > Build custom data rules for this table: > in this field?
- How do i control where these fields will show up on the form and alignment ?
- How do i hide all fields initially, just remove them from the form ?
- Also Table3_Form_Field1 = will be selected by the user when they create a new record in Table3 so is this going to work dynamically or i need to use the dynamic form rules only instead?
- If the formula will do the job then, Is this the right formula structure?
