ContributionsMost RecentMost LikesSolutionsRe: Automation Error based on RulesAre there any hidden interdependencies between data validation rules and automations? ------------------------------ Brandon Owens ------------------------------ Automation Error based on RulesHello, I keep getting an error in a validation, I know what the error is but I don't understand where the error is getting derived from. I am able to perform the same updates manually without error but am unable to have the same update run automatically with automation. I disabled the table rules and the change is made without issues. I don't understand why I am able to make the same update without error while the automation errors out. Thank you in advance! ------------------------------ Brandon Owens ------------------------------ QuickBase Security RolesHello, I wanted to get some clarification on how QuickBase gives users access that are in multiple security roles. I understand that roles that are higher on the list of roles will trump the role lower down on the list but is there any other terms? For example, I have two roles. One is called the Schedule Manager and the other is called the Document Manager. The Schedule Manager role has access to the Schedule table only. The Document Manager role has access to the Document table only. On the list of roles, the Schedule Manager is above the Document Manager role. It would make sense that if a user had access to the roles listed, wouldn't they have access to both tables? Today, the user only has access to one table even if user is in both roles. Thank you, Brandon ------------------------------ Brandon Owens ------------------------------ If and List FunctionHello, I have a code below that works fine but the request was made to make the errors show one at a time. If you read the code, it has three separate error messages. If the user is entering a large set of data in grid edit, it could show all three errors at the same time. My question is, is there a way to show one error at a time until the user entering the data fixes the issue and then the system moves onto the next error? Does that make sense? I thought about employing an if statement instead of the list statement but QB errors on me. (These are data validation rules) var Text checkInventoriedItem = If([Device Type - Make and Model] <> "" and Contains([Peripheral Plan], "Add new"), "If assessing an inventoried item, choice in this field must be No change."); var Text checkPeripheralTypTBD = If((([Peripheral Plan] = "Replace" or [Peripheral Plan] = "Add new") and [Peripheral Type to be Deployed] = ""), "Or if you are adding a new peripheral than Peripheral to be deployed-replaced must be provided."); var Text checkPeripheralTypNCTBD = If(([Peripheral Plan] = "No Change" and [Peripheral Type] = ""), "If you are adding an inventoried peripheral than Peripheral type must be provided."); List(",", $checkInventoriedItem, $checkPeripheralTypTBD, $checkPeripheralTypNCTBD) Thank you!! ------------------------------ Brandon Owens ------------------------------ Re: Table level rules to make field requiredThank you! I am guessing that making a field required is not available? This is a good option to use if that is the case. Thank you for your time!! ------------------------------ Brandon Owens ------------------------------ Table level rules to make field requiredHello, I am attempting to make a field required based on the entry of another field, please see below for the example code. if(([workstation plan]="replace")or([workstation plan]="add new"),NOT isnull([workstation to be deployed-replaced])) What this is trying to say, if "workstation plan" is replace OR add new, make "workstation to be deployed-replaced" required. This rule is at the table level but I have not been able to get it to work. Any help on this would be great! ------------------------------ Brandon Owens ------------------------------