Grid vs Add Field Wizard with Sync Rules

[bthess]

All:

I have a syn rule that I thought was not functioning properly.  To test this I added a grid to my program and low and behold the sync rule works.  My question is do sync rules work when you add individual fields to a program or are they only setup for grids?

Brady

[YiLiu]

The synch rule is tighten with data tables. The synch rule works when the data tables it associated with have certain data changes.

For instance, you defined a rule A, and table b, and c. you associated rule A with table c only. Now, you add table b to the form f1 which table b will be displayed as a grid b, and you add table c to the form f2 which table c will be displayed as a grid c. If you update the grid b  and run the synch rule A, nothing will happen as grid b == table b and table b is not associated with synch rule A. While if you update the grid c on form f2 and run the synch rule A, the table c will be updated accordingly.

For individual fields, if they are on the  subforms of form f2, like update, new form, and the fields are associated with data fields in the table c, run synch rule A will update the table c; Otherwise, the changing fields value wont trigger any data change on table c, and run synch rule A will happen nothing.

[Rob Nicol]

Here's another way to look at it...

Sync rules are independent of the UI. They are used to update data tables.  Now if you have some UI elements bound to the data table that is updated via a sync rule, then those UI elements are updated on the fly. It sounds like this is what you've done with a grid.

It may sound like you don't need a grid, but the grid is the only way to select a row from a data table. If you don't want the grid in your UI, you can jump to a form under the grid using lua scripting.

Rob

[karthik.rudra]

hi guys..

here i am facing a problem in handling grids..
i want to display a particular form for a particular row (row action) selected in the grid..
plz help me out..

[Rob Nicol]

If you do not want to display the grid first to select a row, then it can be done via lua scripting:
http://dragonrad.com/foswiki/bin/view/Help/FAQS#DetailFormWithoutGrid

Otherwise, you can use a ShowScreen Action and simply pick the form from the drop down list.

Rob