I
ionacaerex
Guest
I would like some direction on how best to implement the following requirement in Rollbase. I have a list of rules that are defined by the user in a Rollbase file. Each entry will hold a rule for each field in the rollbase database. Typically the user can then enter the field name, the upper and lower limits acceptable e.g Income is greater than or less than set values. I then need my logic to loop through the entire rule set, validating each field value and checking if the rule applies i.e. the held value for income is greater than or less than the upper and lower values held in the rule file e.g. For the Rollbase income field holding a value of $5,500, a check will be required against the minimum value (say $8,000) and the maximum value (say $10,000). For each case I would then like to create an outcome record - this will be a simple text message e.g. 'Income is Below minimum acceptable amount of $8,000' I am wondering how best to implement this in Rollbase - is triggers the best approach, or maybe some custom SQL code on a trigger. I want to avoid custom programming and keep the solution in Rollbase as long as it can perform satisfactorily. FYI - we may have say 100-200 of these rules that need to be run concurrently. Thanks in advance. Any help much appreciated PS - While reasonably proficient in Rollbase, I am a non-technical user in relation to script etc.
Continue reading...
Continue reading...