Re: Setting a value in a repeating table based on a combination of fields

Hilary Stoupa — Thu, 07 Apr 2011 15:00:52 GMT

Here's a blog post that explains how you can manually modify your manifest.xsf to use a filter on the target of a rule. qRules has a SetValue command (among tons of other cool stuff) that can also do this.

Setting a value in a repeating table based on a combination of fields

karenmyoung — Tue, 05 Apr 2011 22:28:56 GMT

Hi,

I've read (and used, thank you!) several posts about how to set a value in the current row based on a preceding-sibling, but what I need to do is set a value based on a set of field values in a subsequent row. Each row has a test id, software version number, various sizing details, a submit date, and a status. When I enter new sizing details for a given software version and hit the "submit" button, a rule sets the submit date on the new row to now(). The status of this row should be set to "current" (either through default value or rule). Once I have submitted a new set of sizing data (submit date is not null), the previous rows for this particular version need a status of "obsolete". So, if a given row's software version = the software version of a row with a later date, this row's status needs to be changed to "obsolete"

Can this be done using default value or a rule (i.e. without code)?

Karen

General

Re: Setting a value in a repeating table based on a combination of fields

Setting a value in a repeating table based on a combination of fields