Setting range limits on numeric field entries
Hello everyone, I am new to quickbase app development. I have a data entry form for users to fill out that contains numeric fields for Days Hours and Weeks. I would like a way to limit the entry for those fields. I.E the maximum entry for the hours field would be 23, maximum number for days field would be 6. Is there a way using a traditional numeric entry field or a formula to prevent a user from entering a number that falls outside of a desired range? #numeric field ------------------------------ Ashleigh Wansbrough ------------------------------
Grid Edit overriding Form Rules
Hi All, I have a form rule that basically shuts down all fields on a record once it has been checked, making it view only to the end user. Unfortunately, we have users that like to update and/or copy their records in Grid Edit, and as we all know, Grid Edit overrides form rules. Without excluding these checked records from a Grid Edit report, are there any workarounds for displaying records in Grid Edit but keeping them view only? ------------------------------ Urs. ------------------------------Limiting the number of child records that can be created
I have a child table that a user is only meant to be able to make 1 record for each parent. Is there a way to limit the user's ability to create more than 1 child record? ------------------------------ Chris Swirtz ------------------------------
Restrict data entry in numeric field to be less than a certain value
Without using a Multi-Choice text field, is there any way to limit the values entered by user to be whole numbers between 0-11. We have users who are entering total inches into a field that is meant for "remaining" inches (20 ft, 5 in some users are entering 245 in the inches field). I could set up rules that display message if entered incorrectly but some users use Grid Edit and not the Form. Or check if Ft is left blank but I am looking for something that prevents the error in the first place versus QCing data later. ------------------------------ Ruby Kapil rubykapil@wi-finity.com Wi-Finity, Inc ------------------------------Custom Data Rules and Lookup/Summary fields
Is there anyway to get around the limitations with custom data rules and summary and lookup fields? For example I have a Task table that has the projected number of hours a task should take. I then have an assignment table where actual assignment hours are billed against the projected. I was trying to have the system restrict users from assigning any hours that went over the projected hours. However the issue I am running into is since the projected hours is a lookup from the task table, the custom data rules are not firing correctly. Wondering if anyone else has run into this problem and figured out a work around? ------------------------------ Wallace (DHS) ------------------------------
Preventing date selection for dates before the current date
Hi, I have a date field that our users are selecting dates that are in the past and it should always be in the future/today. I didn't see any settings to prevent this from happening. Is there a formula or a setting to prevent a past date for just one field? Thanks! ------------------------------ Catelyn Atkinson ------------------------------
stop a new record creation based on a field value
How can I stop a user from entering a new vacation request if he doesn't have any available? I have employee directory in one table Vacation requests in another table In employee directory I have fields for Total Hours eligible Vacation Time remaining and a lookup from vacation request table called total time requested In vacation requests I have a summary field of # of vacation request (total time) Time requested and lookup fields for total time eligible, total time remaining The the vacation request table, I want to stop the user from entering another request for paid time off if his eligible time is zero. He can still request unpaid time that would need to be approved. ------------------------------ Rhonda Parriet ------------------------------
