Editable Conditions

Editable conditions are incompatible with the DataCorrection PowerTools feature.

Allow editing records only when a condition is met

Set conditions to allow or deny users the ability to edit a row in WriteBackExtreme, if this condition isn’t met then the logged in user will not be able to edit the comment. For example if the status of the row is ‘Current’ then that row can be editable, all rows that do not have a current status will be uneditable, or if you wish to have comments only about ‘Phones’ this is also possible. Conditions for editing can be based on either a data source from your dashboard, or on existing records within the underlaying WriteBackExtreme schema.

Allow adding records only when a condition is met

There may be situations where you want to restrict the ability of your users to add new records in WriteBackExtreme. For example, you only want your users to be able to add a comment to data within the current fiscal period, or based on the total amount of sales related to a selected mark.

Set your condition using the editor in the “worksheet-schema | general” tab in the WriteBackExtreme configuration screen. In this example, we will limit the adding of records to any mark with SUM(Sales) above 250000. This will allow your users to only add comments on marks where SUM(Sales) exceeds US$250.000.

As seen in the example below, the “add record” button (the pink + plus sign) is disabled when a mark is selected that does not match the condition setup previously (SUM(Sales) must exceed US$250.000).

Allow add when in Datacorrect

The Allow add when feature behaves slightly differently in a data correction schema. Any rule added to Allow add when only controls the + button at the top and does not affect the ability to select a mark that doesn’t yet exist in the schema. If you also want to restrict record creation when selecting such a mark, you need to add a corresponding rule under Allow edit when.

When selecting multiple marks, the first mark will be used to determine if a row is editable or not.