Stephen, Here is something from a previous implementation
You will require a temporary character field on the form 1, 3 active links and an active link guide. The first active link (exec order 0) will be used to set the temporary character field with the qualification '<field>' = $\NULL$. The set fields action will look like "'"+$<Column_from_table>$+"'" + " = $\NULL$". You could expand your form 2 to hold the qualification/conditions if needed. This way it will always be a data change if you are turning the field to optional at a later time. The second active link (Exec order 5) will have a Run If qualification of EXTERNAL(<temporary character field>). The Run If Action can throw the error message. You can use the Column in the message to indicate which individual field needs to be populated. Create an active link guide which calls these 2 active links. The third active link is to call the guide on submit or modify. Make sure you select the table loop and the table field that holds all the field names. If you are using an older version o fARS, then you need to write the workflow for walking the table field. If you are on ARS 6.x or higher, you can of course use filters with server side table fields if you prefer. Let me know if you need any clarifications. Regards, Saby --- Stephen Earl <[EMAIL PROTECTED]> wrote: > I have 2 forms.... data form and form containing a > list of required > fields for the data form, lets call the form 1 > (data) and form 2 > (required fields) > > Form 2 contains 2 fields 'form name' and 'field > name' on form 1 we > have a table field containing 2 columns from form 2 > showing records > where form name equals the form name of form 1 > > What I want to achieve is an AL guide that runs > across the table and > checks the field name listed in the table and tests > for it being NULL > however it appears there isn't a way with remedy > workflow to achieve > this 'simple' operation. > > so basically what I have is a field name in another > field and I want > to test if that field's content is null or not, > should be simple > appears it isn't unless I'm missing something REALLY > obvious.... > > All help and suggestions welcomed :-) > > Stephen > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
