Flowfield validate

(0) Share

Report

Posted on by lynix_x

255

Hey All,

I have a flow field in customer table, that calculate a value from another table(table b for example). is it possible to set a default value for the flowflied , if value is blank in tableB.

*This post is locked for comments

All responses (6)

Answers (0)

Suggested answer

RockwithNav 6,562 on at

Like (0)

Report

RE: Flowfield validate

Se technically thats not possible but theres another way around.

Make this a Flowfield.

Now in your Page take a free text variable and write code OnAfterGetRecord where you check your condition first like if its Blank then make it blank OR else use CALCFORMULA to calculate and put that Flowfield Value.

P.S - It will have a great impact on lower down the performance of the system so use it if its deadly needed.
Suggested answer

CDsilva 4,184 on at

Like (0)

Report

RE: Flowfield validate

No, you cannot do that.
Suggested answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Flowfield validate

No, you cannot do that. The value of flowfield depends on other table value based upon your CalcFormulae
Andrey Baludin 3,941 on at

Like (0)

Report

RE: Flowfield validate

Unfortunately i don't know any possibilities to do that.
lynix_x 255 on at

Like (0)

Report

RE: Flowfield validate

Thanks Andrey,

what if it is a text i want to show as default. Does it have properties for it?
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: Flowfield validate

Hi!

You can only make it blank instead of 0. Set BlankZero property of your flowfield to Yes.

Also you can blank positive or negative values with BlankNumber property.