Hi,

We recently changed the default setting to allow formula's to remain downstream. Previously the default was for formulas to be changed to static fields. Your old workflow's should retain the original setting. You can turn on/off this behavior by clicking on the block tools dropdown and checking/unchecking "Preserve formula fields". There is no way to change this setting for all blocks at the moment. What does everyone think? Should we make the default for formulas to persisist or should it be that formulas are changed to static values?

Chris many thanks for your quick answer. Very happy to hear that old DM files should still work and we can turn on/off the functionality. Few things however:

1. We have tried the "Preserve formula in output" field but seems not be working or we use it incorrect. Situation: Field Organiser 1 had Date field field and a formula field that retrieves the Weeknumber from the Date field with the 'Dateunit' formula. Field Organiser 2 has both fields as well, but the Date field must be deleted and the Week field must remain. What should be the settings in terms of the "Preserve formula in output" field.

2. Two days ago we had a bug we could solve, but we coudn't understand its origin. Now we can as it was caused by this functionality. It does however mean that old files do not always work on the old setting as you mentioned in your post. Situation: Two fields 'Company name' and 'Address1'. Because of not having a proper ID field we created an ID by combining these two fields in a formula field (not pretty we know, but sufficient for that particular dataset). Address1 was renamed to 'Address' in the same block and the formula field recognised the renamed fieldname. This was the bug, as the formula field now expects the old fieldname (Address1). I am sure we have more fields of this kind and that is a serious risk for us as we are not sure.

3. I would appreciate a button to turn it off/on for all blocks

4. I prefer having the old situation, so having static values in blocks downstream for the formula fields.

Thanks

Hi,

We have now changed the default behaviour of formula fields being converted to static fields by default in DataManager.

We are in the process of generating a new release with this change. In the meantime please use build b666.

Hi. Omniscope b675 is now available on the server. This release contains the fix described above.

thanks Chris. This helps us a lot. Thanks for the flexibility Visokio!!

Hi. We will be implementing the following changes in the next few days:

- If a block has formula fields, the number of formulas will be indicated in the block description, eg: 10 fields (5), 50 records. The number in brackets (which will also be blue) indicates the number of formula fields).

- We will be adding an option in the view tools dropdown to turn on/off "Preserve formulas" for ALL blocks in the workflow.

- We will be implementing non-intrusive messages that inform you when you have created a formula that is being converted to static values.

The changes described above have now been made. These will all be available in tonight's Omniscope 2.6 release.

In trying to create a formula in the Field Organizer, I noted that I cannot use Variables. is this a bug, or by design? I see that I can use the variables in tables, but not when created through the field organizer block. thoughts?

You can. However you must define the variables outside of the formula editor.

In the Field Organiser block, click Tools at the bottom, and Edit Variables.

You will be able to define the constraints of the variables (min, max etc.) and the initial & default value. Then, when the data has been loaded into Omniscope, variable sliders and input boxes will allow you to change the variable value on a given tab.

There is no "Tools" option in the "field Organiser" block. I am on Build 650. Is that the issue?

Yes. 2.6 left 'Alpha' in August. You should upgrade as soon as possible.
http://www.visokio.com/download

Done. Thanks.