Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I have tabs for my info in the parent table - I've set up in one of the tabs to not have the "Add" button display if there are current open records that need to be closed before a new record can be added. However, I've noticed there is another button above the embedded report to also add records. How do I remove/hide this button with the arrow in the screen shot below?
Hi, There are a lot of instances where we need the users to be able to sort and group their reports, but we can't leave the report open for editing. I've opened a ticket to see if Quickbase can separate out the Sort & Group feature from the User Interface settings.If you're interested in this too - go "request actions" and subscribe to the ticketSort & Group #409577 - this is a link to the feedback:Request | Feedback (quickbase.com)
My pipeline fetches all records in JSON format using a Post request. Response is in {"key":"value"} format, where key indicates the field name, and value indicates the value of the field. The problem occurs with the fields with 'dblink' type. Specifically, it seems like the API is unable to retrieve the values of the fields with DBLink type and returns empty value. I'm wondering if there is a way to fetch the values of 'dblink' type fields?
Currently my pipeline:Does a JSON Fetch to retrieve a JSON responseDoes an Iterate over JSON recordsAfter the iterate I'd like to add a condition step that checks whether the # of JSON records is exactly 2 and then branch accordinglyMy iterate JSON step is Step 'd'. I'm trying to figure out the right syntax to use in my condition step.In the advanced expression of my condition step I've tried {{ d | count}}=2 {{ d | count}}==2 {{ d | length}}=2 {{ d | length}}==2 and all always resolve to 'True' even when the returned json only has 1 recordAny help is appreciated.
Whare are everyones thoughts on the new switch to Upgraded Dashboards?I had just spent a year making Dashboards (they are great), and now suddenly they upgraded the design (tabs on top and a bit of a different look).I like the new look, but I already built quite a few with the old look, and my users just got used to the tabs on the bottom. I am creating my last dashboard, and BOOM, it defaults and forces you to the new style (when creating a new dashboard).There is a cheat code (copy an old style dashboard), but this seems to be another example of Quickbase simply not listening to the end user any more. I do like the new design, and will likely eventually switch, but to force the issue immediately without warning, feels rough. It makes consistency in my apps very difficult.What do others think?
Good morning,I am currently running a pipeline that is supposed to trigger when the date modified field is changed, Now in most parts this works but for some reason there is certain times the pipeline will not trigger even though the date/time has changed.One solution I had was to create another step within the pipeline using a field of "Manual Date Modified" and timestamping it with {{time.now}}By doing this I was going to a new filter of if Manual Date Field is before Date Modified then trigger the pipeline, However, it will not let me select Date Modified as a subsequent step. This field is in built in field from Quickbase, Has anyone else ran into this issue previously? and if so were you able to fix it?Thanks.
Hello,I use QuickBase for IT Asset Management and need a way to search multiple Asset Records at once, to see their status and update in Grid Edit if required. I have a table called "Assets" containing a text field named "Asset ID". This field contains a unique Asset ID, (EX:D117380) which we use to identify the record.I have done some research but cannot make it work. So far, I have built a table called "Search" containing a Multi-Text field called "Search Multiple Assets Here:" I would like to paste any asset IDs here, click save, and then display the results in a Table or Summary below. I do have a table relationship, but not sure if it is linked correctly. I also tried doing this in Pipelines but could not get it to run properly.If anyone could help me find a way to do this, that would be HUGE!
Hello and happy Friday - I would like to have an add button hidden until a certain record in the app has met it's outcome, and then once that record is considered closed allow the add button to display again letting the user add a new record. Any assistance on how to do this or reference material that walks through the process of setting this up?Many thanks, LB
We would love to learn more about our members! Tell us a little bit about you.What is your name?What company are you with?What is your role there?What brought you to the Qrew board, specifically the Women's Qrew?What is one thing you are most looking forward to this summer?Feel free to include any other fun facts about yourself :)
Looking for a way to show a summary type list of items. In my application I have a Projects table and a Time Entries table. Projects can have many Time Entries.I also have a Team Members table. A Team Member can have multiple Time Entries.I'm trying to create a summary type report which would show the Current User a list of all Projects to which they have logged any time. I do not want to view each of the individual time entries, but just a list (non-repeating) of the project name.Example:Time Entries (table)Team MemberDateProjectBob Smith7/1/2024Project ABob Smith7/2/2024Project ABob Smith7/1/2024Project BBob Smith7/2/2024Project BSally Jones7/1/2024Project AReport would then Display:Bob SmithProject AProject BSally JonesProject A
I have a formula url field that I'd like to show nothing or be blank if fid 6 (Status) = In or if Out show as a red button that says "Clock Out". Below is the current formula url field that I'm trying to modify.var text URL = URLRoot() & "db/" & [_DBID_TIME_IN_OUT] & "?act=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_6=Out";var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();$URL& "&rdr=" & URLEncode($RefreshPage)I've been looking at various posts that use additional variables to set the formatting, but I'm not sure how to incorporate what I've found into the above.If Status = Out then use:var text red = "<a style=\" text-decoration: none; background: #ff0000; border-radius: 5px; color: #fff; display: inline-block; width: 150px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-seif; text-shadow: none; \">Clock Out"</a>";If Status - In then use:var t
Is it possible to set the default value for an address field? I'm not seeing the typical "default value" property so wondering if there is another way.Thanks
Good morning,In short, I have created a pipeline that triggers on an event inside 'record 1'. It then creates 'record 2'. 'Record 2' ends up being created/ owned by me, however, I would like to change that to the person who created/ owns 'Record 1'. I am open to all ideas and suggestions.Thank you for your time.Kind regards,Shane Miller------------------------------Shane Miller------------------------------
Hello,I currently use the new forms in QB, and I love the functionality to be able to easily add a record in that pop-up view when using an embedded report from another table. However, there is a limitation to this functionality of the parent record is not saved yet "adding a record". Is there a way I can let users add records to another table in an embedded report without the parent record being saved first? Or is there a way to trigger the save so that functionality can happen?
Good afternoon all....I have created a formula that check for the existence of a file.The premise is that if no file exists, create text that says no record, or if it does create a 'URL LINK' to the file. The following is what I have come up with but not working...If([COPY OF INDEMNITY]="","NO RELEASE","<a href=" & [RELEASE URL] & "CLICK HERE FOR RELEASE</a")If anyone can assist it would be appreciated.Cheers,Damien
We've been using a QB Table to track snap shots of business health. Once a week we log some numbers across different tables. This isnt exactly what we do - but as an example it could be:how many orders placedhow many orders deliveredhow many orders on holdhow many customers outstanding on paymenthow much billed receivedhow many customer feedback receivedetc etcand we do this for each "store" - let's assume we have 2 stores.Now here is my issue!I want to track PERCENTAGE CHANGE since last week. So it's the same table - but I want to compare, "orders placed" this week for this store, versus "orders placed" last week for the same store. I want to be a formula for a field which would show PERCENTAGE INCREASE OR DECREASE. ( and then we can get fancy and make charts, graphs, color code etc)Where I am having the issue is - how do I find the value of last weeks entry for this store?? let's assume each entry has a "week of" and a "store code" - so for example: 07-05
What is the best way to handle a division formula that is dividing by zero and returns an error? I would like the error to return a Zero.
I have a formula that creates a copy of the existing record that a user is currently working on and it works great. I then refresh the screen to present the screen of the newly created record. var text RefreshRecord=URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Clone Record ID#] $RefreshRecordAll is good when the user is "cloning" the latest record in the table because I have a formula field in the table that adds 1 to the current [Record #ID]Essentially ... [Clone Record ID#] = [Record ID#] + 1However, if the users decides to clone an earlier record in the table, it creates the new record just fine, but the [Clone Record ID#] is wrong because it's not referencing the "new" record, but rather the record right "after" the record the user chose to clone.So I want to change the field formula to something like [Clone Record ID#] = Max([Record ID#]) but I know it doesn't work that way in QuickBase. Please advise
Hello,I'm new here so please let me know if this is not an appropriate use of these discussions. The quickbase data coordinator is resigning from my company, and I am wondering if there are any resources for hiring temporary talent until the position can be replaced internally. Thanks
I have a user request to track software skills for team members.They want a list of items, for example software packages, in a drop-down list.But - they also want a rating for each skill, from 1-5. So for example, they don't want to just know that John has experience with "QuickBooks" and "Xero" - they want to say he has "QuickBooks - Level 1 experience," and "Xero - Level 5 experience." And of course, they want to then be able to get a report of all team members with, for example, Xero experience level 3 and above.The list of systems could have 20 or so items, and I'm thinking there must be a better way to implement this than to have 20x5 items in the dropdown. Is it possible to list the 20 software packages, then a separate 1-5 ratings field, and somehow combine them to get a complete list of software experience, with the correct ratings attached, for each person?
I need to export port a file which has over 400 fields and years of data. When I try to export I get the following error.is there a way to split the data into chunks? I still need all the data, and would like to split in yearly chunks. Is there a simple way to do this? I am a total novice at this.
Is it possible to utilize Pipelines to build a form, that is keying off of field answers to questions already on that record? So say there are 50 questions, and for each question that is answered 'No' to (radio style button), the 'No' answered questions can be then generated onto a new form, that acts as an audit checklist? My thought was to have the New Checklist form be kicked off by a button, which the Pipeline can be looking at. But can the Pipeline create a form? Or can/will this need to be done through a different manner?
I have an app where I rely heavily on roles and role permissions to view certain data and forms. Because of this I need to test as a role when developing new roles to ensure the users cant access other roles data. Is there a way to get these "test as role XXX" as a callable URL I can map to a button on the admin dashboard?I want to use the custom branding setting in the app to hide the Quickbase standard menu options for all users so they can't try and get to the My Apps page in our realm. Is the custom URL to test as a role possible?
I need to get up to speed on the structure of an existing QuickBase business app that has 40+ tables. Then, move it over time into a managed design cycle.Any suggestions on ways to do this? Or been here, done that?Thanks!KeithI'm coming from perspective of small business CTO wanting to bring our app into a managed development structure. Coding-wise, coming from Visual Studio and compiled code dev. I'm new to QuickBase. I confess to a feeling of frustration as I browsed the app in the QB design tools. Perhaps because of an expectation to be able to see the structure and dependencies of our app called out in a taxonomy of sorts. Or, be able to export the structure to bring into outside tools.Just noticed the QBL - it sounds promising.
Hello Mobile Qrew! I have a questions for you to answer: In your experience, what's better for the field to collect data: Phones or Tablets? Let us know the reason below! Let's start a discussion and share your thoughts with the group.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.