Require table columns to be completed but only when the table is used

Follow

Natalie Williams

21 August 2012 11:22

It is currently possible to require table columns to be completed.  However, this assumes that the table in its entirety is required.

There are cases where a table may not be required at all, but if it is required, and only then, certain fields must be entered.

This is tricky to explain so I shall give you an example:

A scheme that insures a number of different items, is made up of several tables: Item1, Item 2, Item3 ........

IF Item1 is required and a price (for example) is selected in the table, then ALL the other information fields for that table would become required.  for example, Name, Date of purchase.......

But if Item1 is not needed none of the filed should be required.

Perhaps the ability to add a Trigger to columns in tables may do it.

This is getting increasingly important for us and there is a particular scheme that cannot really function correctly without it.  If there is a way around this I would love to hear any suggestions.

4

• 

  Permanently deleted user 30 August 2012 13:51

  This would be a massive help for us too

  0

  Comment actions Permalink
• 

  Permanently deleted user 30 August 2012 14:14

  I agree

  0

  Comment actions Permalink
• 

  Chris 03 September 2012 10:11

  Hi There,

  Good news! just as an update to you on this, we are planning to address this in a future release :)

  kind regards
  Chris

  0

  Comment actions Permalink

Please sign in to leave a comment.