Forum Widgets
Recent Discussions
URL for current time in Time of Day field
Hey all, Trying to deal with stamping a Time of Day field with the current time when clicking a button. I know about how "now" functions to do this properly when using a Date/Time field, but it doesn't seem to translate properly into Time of Day fields. It errors if I just try to use "now" in the field assignment and returns nothing if I ToTimeofDay("now"). I can't use Now() because this caches the time the page loads and that won't work for how this process needs to function. What's my best option to get this handled?
Numeric Fields Show Separator After 4 Places
Curious to get other's thoughts. We have not enabled the new Grid Reports in our primary application. We have one application used by a small group that does have new Grid Reports enabled. This application (with Grid Reports enabled) has summarized data from our primary application. I was updating the data today and noticed the totals have the comma separator after 4 places. So, 100000 is displayed as 10,0000. When last updated, I'm pretty sure the comma separator was after 3 places. I see in the field properties a select of Show separator after 4 places or Show separator after 3 places. This appears to be a new option with the default of 4 places. For all the numeric fields, I'll need to manually change to 3 places. I could not find anything in the release notes about this option. Has anyone seen anything related to this? Is there any way to change the default to 3 places? I have a feeling this is going to be overlooked quite a bit when adding new numeric fields.How to Sort Specific Options in Drop Down List
Hey everyone, is it possible to sort 7 or 8 specific records to the top of a drop down list? For context, there are 120 records in this drop down list, so they don't all show due to drop down list length limitations. They have to be searched for. However, I'd like to have the most commonly selected options put at the top of the list for quick selection without searching, but I can't change the naming scheme of the items for reporting purposes to do it the easy way. The drop down list is pulled from a relationship, not manual entry of all 120 items for the list. To summarize, this is for utility poles. They all have their own class, species, and size. All of the pole info is in its own table. I used the concatenate formula to combine all 3 details (size/class/species) into one field for the delivery table, so the employees can pick the pole the delivered that day. I just want the commonly delivered poles shown at the top of this list. Is this possible? The built-in AI says no, so I thought I'd give this a shot. Thank you!Form requirement nuanced trade-offs with proper relational structures
I have two related questions! Someone suggested using grid edit reports on my forms for a more all-in-one parent-child editable comprehensive form. That's not working at least on my end -- has anyone had grid reports be available within a form? I'm reorganizing another section of my app for a division that hasn't moved over to my current setup yet. In their legacy setup, there is currently a one-form-fits-all, which requires many things based upon the service level they rendered. We're moving to a "Clients", "Cases", and "Service Calls" -- which means I no longer can require things at the Client or Case level based upon the extent of the service call..... is this just a trade off I have to make? I'm concerned people might not go back into the parent record and update with additional information as it's received in this new setup (and hence why the grid edit would honestly be a fabulous option -- bring the Service Call record right onto the master record and edit it all from there).Pipeline Filters using AND and OR
I have a pipeline which has a search step from a list of students. In the filter I want to include the names I want and not the entire list. SchoolName is xxx AND Student Name contains John OR Student name contains Michael OR Student Name contains Joan OR .......they are 24 how can I approach this using using advance filters
Project Status Spotlights
Hi, I am using a Project Status multiple choice dropdown field with the following options: Green - On Track Yellow - At Risk Red - Off Track Blue - Complete Purple - On Hold Black - Canceled Silver - Closed I'd like to incorporate the Project Spotlight formula featured in Exchange so that the status displays in it corresponding color (while also keeping the text separate). I'm struggling with where to insert the formula and how to modify the formula to recognize my custom status values and colors noted above. I appreciate the help!Accessing previous field values after an import mapping failure
I have a bulk event-triggered pipeline firing whenever records are modified, leading to an Import to Quickbase step. The import stores current and previous field values on another table. Working on error handling for this import, I would like to log the attributes of the intended "change record" it was attempting to create, i.e. current and previous field values of the source record. If the error was an "import error" this is easy: I can access any of the target field values inside the `import_error.record` container. But if the error was a "mapping error" then it seems only the source's current fields are accessible through the `mapping_error.item` container, with apparently no metadata like previous field values. I don't think I can reference the original record in this context because it's a completely different object with a different index (since the import failures are obviously a subset of the original record set). So this leaves me without a way to store previous field values if there is a mapping error that I can see, unless I restructure the pipeline to process the records serially, which I'd prefer not to do if I can avoid it as the trigger event can potentially be quite large (thousands of changes at a time). Am I missing something? Or should I just not concern myself with auto-handling mapping errors in production, because the data types should never be allowed to change in the first place? Should I just make sure to throw a bright red alert if it does ever happen?
QuickBase Reports Help
Hi all, new to QuickBase but not new to database tools. I'm trying to build a specific report within QuickBase. In Tableau it's called a Bowling Sheet. A non-propriety example looks like this: https://www.allaboutlean.com/wp-content/uploads/2025/01/Bowler-Chart-Example3.png Ive been able to get sort of close in QuickBase by using the Summary Report, and I can group columns by Month to achieve the same result, but my issue is that it's giving me a COUNT of the data that's being reported instead of the actual value of that data. I'm sure it's something stupid/easy that I'm overlooking, but I'm stumped. Any help would be appreciated.
Is there a better way? Report filter where user list includes current user
The way I solve the following issue, doesn't feel like the best way. It seems like there should be a simpler solution. On my reports, often have scenarios where I have a user list field, and simply want a filter: If the [User List] includes the current user. This is not an option, so I end up making a formula list user field, that is: Touserlist(User()) Then my filter is: If the [User List] includes the users in the field [Current User List]. Is there an easier way? ------------------------------ Mike Tamoush ------------------------------
