Disallow invalid Entry in forms

[Nikpowar97]

Is there any way I Can enter a +ve or -ve value based on the text property if a Flow member in a form.

I think a Save Data Event Handler can, but I will throw an error if the only after the form is saved.

What if the cell color will change (Just like in Excel) if the value enter on the form  should  +ve or -ve value based on the text property if a Flow member. 
is this achievable.

TIA,

Nik

[MarcusH · Accepted solution]

SaveDataEventHandler is not recommended for this as it executes everywhere. You can use it to abort a save and pop up an error but there are other options. You could potentially use a FormsEventHandler and that can be used to stop the save. Alternatively you can use formatting on the CV to indicate that the value entered is incorrect (eg change the background colour to Red). It does not stop the save though. The problem you have is the +ve/-ve indicator is in a text field against the Flow member. For that you will need to use an XFBR.

The format of the XFBR call will be like this: XFBR(BRRuleName, FunctionNameInBR, FlowMember). The XFBR returns the text member for the passed in FlowMember - the formatting below assumes the Text field contains POS or NEG. You then add this as the format instruction:

If CellAmount < 0 And (XFBR(BBRuleName, FunctionNameInBR, FlowMember) Contains POS) Then
    BackgroundColor = Red
Else If CellAmount > 0 And (XFBR(BBRuleName, FunctionNameInBR, FlowMember) Contains NEG) Then
    BackgroundColor = Red
Else
    BackgroundColor = White
End If

The problem is making it dynamic. If you are happy to hardcode the Flow member into every format it's not a problem. I haven't been able to access the POV members to pass through to the XFBR. The system variables do not seem to work all the time eg the variable MFFlow only works for a Member Filter (and I couldn't get that to work). You can access the Cube POV variables but that will vary from user to user. If you could identify which Flow members need to be +ve or -ve based on the name you could use RowE1MemberName instead of the XFBR.

I hope that helps.

Marcus

[manthangandhi]

Hi Nikhil,

I'm not sure but can you try using XFBR rules and within that write condition as required and attach it to the cell format of the cubeview. I could be wrong, but you can try with this if not done earlier.

Thanks

[MarcusH · Accepted solution]

SaveDataEventHandler is not recommended for this as it executes everywhere. You can use it to abort a save and pop up an error but there are other options. You could potentially use a FormsEventHandler and that can be used to stop the save. Alternatively you can use formatting on the CV to indicate that the value entered is incorrect (eg change the background colour to Red). It does not stop the save though. The problem you have is the +ve/-ve indicator is in a text field against the Flow member. For that you will need to use an XFBR.

The format of the XFBR call will be like this: XFBR(BRRuleName, FunctionNameInBR, FlowMember). The XFBR returns the text member for the passed in FlowMember - the formatting below assumes the Text field contains POS or NEG. You then add this as the format instruction:

If CellAmount < 0 And (XFBR(BBRuleName, FunctionNameInBR, FlowMember) Contains POS) Then
    BackgroundColor = Red
Else If CellAmount > 0 And (XFBR(BBRuleName, FunctionNameInBR, FlowMember) Contains NEG) Then
    BackgroundColor = Red
Else
    BackgroundColor = White
End If

The problem is making it dynamic. If you are happy to hardcode the Flow member into every format it's not a problem. I haven't been able to access the POV members to pass through to the XFBR. The system variables do not seem to work all the time eg the variable MFFlow only works for a Member Filter (and I couldn't get that to work). You can access the Cube POV variables but that will vary from user to user. If you could identify which Flow members need to be +ve or -ve based on the name you could use RowE1MemberName instead of the XFBR.

I hope that helps.

Marcus

[Nikpowar97]

This Marcus,

This is what we care currently doing but just wanted to check of is there any way the formatting can be done whole the user is inputting data before save. This is exactly what i am looking for

[DeanHarper · Accepted solution]

This is quite straightforward I think.  If you create a dynamic Ud8 member that checks if the value of the POV data intersection is in keeping with the +ve/-ve you expect based upon the text property.

 Return say a 1 if it is in keeping and a 2 if it is incorrect, then hide that column but use it as the basis for conditional formatting the row, or in the case of one of my clients we have nice graphical color blobs, because these are dynamic they flag as soon as the unexpected value is populated.