Forum Widgets
Recent Discussions
Using one field to collect data multiple times.
In quickbase, I have a field for user and datetime. There are several project status like pending, submitted, review,approved and denied. Everytime in the status field change I want to record who did the change and date time. I want to use the two buttons. submitted by and submitted datetime field to track the audit history or logs. I did try with a pipeline but there is no data being recorded. Anyone done this before?Using one field to collect data multiple times.
In quickbase, I have a field for user and datetime. There are several project status like pending, submitted, review,approved and denied. Everytime in the status field change I want to record who did the change and date time. I want to use the two buttons. submitted by and submitted datetime field to track the audit history or logs. I did try with a pipeline but there is no data being recorded. Anyone done this before?How to add Tabs (Pages) to only a specific section of a form?
Hi everyone, I’m trying to organize a form using Tabs (Pages), but I’m running into some confusion with how Quickbase handles them.Previously, I was able to add new sections below existing ones without issues. However, when I try to add a new Page (Tab), Quickbase automatically moves all my existing fields into Page 1 and puts the new fields on Page 2. The tabs also always appear at the very top of the form. What I actually want is to have tabs (or a tab-like experience) applied to only a specific section lower down in the form, without wrapping the entire form into multiple pages. Is there a way to achieve this? Or what is the recommended approach — using multiple Pages, Sections with rules, or a completely different method? Any advice or best practices would be greatly appreciated! Thanks in advance.
New Forms Deisgner - Tab (Page) Title Colors
In legacy forms, there was a way to color each tab title within a form (snip 1). The resulting form could look something like snip 2. Using the new forms designer, I have not found a way to color each tab/page (snip 3). Is this no longer an option or am I just not seeing how to do it? Snip 1 Snip 2 Snip 3 Thanks....Aaron ------------------------------ Aaron B [email protected] ------------------------------
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.
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?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
