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 a table which has over 1,500 fields. My questions is, once a single checkbox is checked, is there a way to setup some type of IOL that will make all of the fields (except for a handful) to read-only? I was hoping there was a way to edit the form rules so that I could make fields encompassed by section headings to read-only - much like you can with "show" and "hide" when selecting a section heading. This would be a great addition to QuickBase!Bonus: If I could allow 2 user-types to override this rule and edit all fields no matter what, that would be perfect - but simply a bonus and not 100% necessary for my purposes.Thank you in advance------------------------------Shane Miller------------------------------
Can some one please help where we can find Quickbase version ?
GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}and{7.EX.'" & [Load # - Description] & "'}",[_DBID_PRICE_HISTORY]),19)Can anyone tell me what is wrong with this query, I am not getting any results and I know that there are some.In addition when if I query for either of the 2 filters individually I do get results, eg:GetFieldValues(GetRecords("{17.EX.'" & [Consignee - Related Consumer] & "'}",[_DBID_PRICE_HISTORY]),19)------------------------------George Bramhall------------------------------
Hi,I'm building a pipeline and am struggling with an if statement.What I want it to do is look at the prior month and round up to the nearest quarter for that prior month. Ex: Today would round to 202303 whereas July 15, 2023 would round to 202306.Here is what I have so far. I've troubleshooted my set variables and those function as expected. It's when I get to the if statement where it isn't happy:{% set Reporting_MM = "{:%m}".format(time.now - time.delta(months=1)) %}{% set Reporting_YYYY = "{:%Y}".format(time.now - time.delta(months=1)) %}{% set MARCH = Reporting_YYYY ~ '03' %}{% set JUNE = Reporting_YYYY ~ '06' %}{% set SEPTEMBER = Reporting_YYYY ~ '09' %}{% set DECEMBER= Reporting_YYYY ~ '12' %}{% if Reporting_MM in [ '01', '02', '03'] %}{{ MARCH }}{% elif Reporting_MM in [ '04', '05', '06'] %}{{ JUNE }}{% elif Reporting_MM in [ '07', '08', '09'] %}{{ SEPTEMBER }}{% elif Reporting_MM in [ '10', '11', '12'] %}{{ DECEMBER }}{% else %}{{ ERROR }}{% endif %}---------------------------
I assumed the placeholder would remain in red and it did not :-( Did not think it through. I also did not realize it until a few days after the fact so there is no copy to pull from. I do have the initial data import file to attempt to import and match but this past year is missing from my initial data. Would that need to be updated manually or is there a history somewhere I can go back and correct?------------------------------Jillian P------------------------------
Hello, I use QuickBase for Case Management which requires me to keep notes in the "Notes" tab for all of my interactions. Sometimes I will have a note that I have to add to multiple people. Is there a way to add a single note to multiple people at once? or do I have to open each profile and add the note in individually?------------------------------Joseph Olson------------------------------
When filtering reports using 'Ask the user', what types of fields will become a multiple choice for the user, versus the user needing to type in their choice? Obviously a mutiple choice field. I was going to experiement with others but was wondering if anyone knows the full list.------------------------------Mike Tamoush------------------------------
I am running into an issue with using shared values from one field to another.I have a field on App One, Table A, called, Facility. It's Text - Multiple Choice. It uses From List to display the options. The checkbox is selected to use the values as a source in other fields. The app chosen is the same app, App One. On Table B, the field Facility Assigned, is setup for input type From another field. App: App One, Field: Table A: Facility. I changed the values in Table A: Facility, but values in Table B: Facility Assigned is showing the original values prior to my change. It looks like Table B: Facility Assigned only pulls values that are already selected for a record from the original field. So if Facility1 and Facility2 are selected on records, then the Field only pulls those, doesn't matter if I remove those values from the original field or add new ones, if they're not selected to a record, it doesn't list them. ------------------------------Kaitlyn Stanley----------------------------
I created a copy of an app as a "demonstration/test". In it, I enabled a button to Copy Master & Detail Records. It worked perfectly in the "demonstration/test" environment, but not in the live app and I'm not sure what I need to look to so that I can correct it.From what I can tell, all relationships look to be the same. One thing that was weird was when Choosing a Table in the Copy Master & Detail Records, one table was available in one, but not available in the other. I have a table called ACME (parent). That's related to another table called ACME Registrations (child). I want to copy an ACME and include all their registrations. It worked in the test. When I set it up in the test, the ACME Registrations table was not available to select. But the button worked perfectly.When I set it up in the live application, ACME Registrations was an option to select. The button was still created, but when I hit it, I get the
I want to compare the last name of the USER to the last name of another field. Thank you------------------------------Barbara Alvarez------------------------------
Please help what does this mean ?Error Details:CopyMasterDetail does not allow looping relationshipsI have now almost deleted all my relationships but I still get this
I have a table that populates every day a person is scheduled from form entries.The goal is to show a report on the schedule entry form, so that when a person's name is selected from the dropdown it shows a report of their currently scheduled dates on the form.This is help prevent double booking.The embedded report filtered for:1) Filtered by the person's name selected from a dropdownI know how to display data from the child table, but I'm stuck on the report.This entry form is in the same table as the scheduled datesCan this be done or will the form need to be saved before any information is populated?Thanks!------------------------------J. Striker------------------------------
I'm adding two fields, one field is having Date and Timestamp and another field is Duration of days. the output I want is Date/Time.Output field type is Date/TimeToDate([Request Received Date]) + Days([TAT]) Using above formula I'm getting the output in Date format, But I required in Date/ Timestamp------------------------------manohar vankireddy------------------------------
Hi, I have a multi text field having the record ID of next task on my list of tasks in a tableI need to pick this record ID to be used in Formula URL in order to change the Task Status field of the target record. Is it feasible?URLRoot()&"db/"&[TARGET TABLE ALIAS]"&"?a=API_EditRecord&rid="& [multi-text summary field] &"&apptoken=*******************&_fid_57= In Progress"------------------------------Neha Raghav------------------------------
Trying to change the value of a multiple choice field using formula URL for a different Record ID getting following error This XML file does not appear to have any style information associated with it. The document tree is shown below. <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>215</rid> <num_fields_changed>0</num_fields_changed> <update_id>1675336884376</update_id> </qdbapi> URLRoot()&"db/"&[_DBID_TASKS]&"?a=API_EditRecord&rid="& [Successor Task Record ID] &"&apptoken=***********************&_fid_57= In Progress"------------------------------Neha Raghav------------------------------
HiI have a table for our Project Team and that consist of 3 Roles: PM, DE, BA. There are about 100 entries on this table, with fields for Name, Email, RoleIn my main Application table, I'd like to have the user assign a PM to the Project Manager field, a DE to the Data Engineer field and a BA to the Business Analyst field. I can use a relationship to bring the entire Project Team table eam listing into each multiple choice dropdown field, but is there a way to only display the Role=PM in the Project Manager dropdown field, only Role=DE to the Data Engineer dropdown field, etc?Thanks------------------------------Jonathan Albert------------------------------
Is anyone having trouble with Quickbooks invoice pipelines?I had been using the solution here which had been working correctly in the pipeline since 2020. Now I am getting this error every time I run it: Validation error: Incorrect template "{{b.amount}}". ValueError: invalid literal for int() with base 10: 'amount'. If i try to remove the 'amount' field then I just get the same error for a different field.Quickbase support has not been helpful at this point. Thoughts?------------------------------Jessica Feauto------------------------------
Hi All,I've got a table in my QB App that is identical to a Sharepoint List I have in Sharepoint. I'd like to know if its possible to have a pipeline that will sync the data in these two systems so that if a row is added or changed in Sharepoint, it will reflect in my QB table, and likewise, if data is added or changed in QB, it will reflect in the Sharepoint List.Is this possible, and if so do anyone have a how-to I can refer to?Thanks in advance,-Troy------------------------------Troy MacPherson------------------------------
We have a table with a bit over 9,000 records and 184 fields. Table size is 4.8 MB, with 150 MB of attached files, and the statistics screen says it is less than 1% full.Recently, we have been getting the error "Formula Query Execution took too long" when attempting to load the List All report for this table. The table lists vehicle assignments, and we sometimes need to look back at assignment histories, so I would prefer not to delete any records.Why would we be getting this error, and is there anything I can do to prevent it?------------------------------Amy Christensen------------------------------
An old thread showed this trick to show more than the default 200 rows on a page of a report&qrppg=500 (add to end of URL)This does not work on the new report style. Does anyone know if there is any trick to show more than 200 rows on a table report in the new style?------------------------------Mike Tamoush------------------------------
Anyone now how deactivated users might be getting added back to my app? We have a table whose key field is user and this table is a parent table to 15 child tables. Obviously the related field in each of these 15 table relationships are also user type. I think I have erased all cases where these deactive users are populating these related fields in the 15 child tables., but we are still getting users added back on. Are there any other reasons why these deactive users might be getting added back on our user list?------------------------------George Bramhall------------------------------
Hi,I am getting error message "Quickbase reported an error: No error" while selecting a table in the quickbase pipeline. For other tables the pipeline is working fine, not sure what is wrong here.I have checked the role permission for this table and there is nothing odd there.Please suggest any solution or work around.Thanks------------------------------Ravi Avhad------------------------------
Table 1 fields are Project Name and Site IDTable 2 fields are MS1 Date and MS2 DateTable 3 fields are Pole Name and CostHow do I create the relationships for Table 3 to produce a report with the following info:Project Name, Site ID, Cost, MS1 DateTables 1 and 2 have a 1 to 1 relationshipTables 2 and 3 have a 1 to many relationshipAny help is greatly appreciated!------------------------------Mike S------------------------------
When a field is added to a report that points to a parent record QuickBase makes it a hyperlink so the parent record can be opened from the report. How can the hyperlink for these parent records be deactivated?Business Objective: I am making specific reports available to a role where the report contents need to be visible, but they should not be able to open the linked record in a form.I looked in the report configuration where I thought there was a switch to turn off hyperlinks, but I could not find it. Then I looked in the form parameters for the table to see if I could eliminate a form from the role, but leaving it blank or "no access" were not options. I looked in the role security configuration, but nothing related to form access. I could not deactivate table access because the users in the role do need to see the data in various reports and children reports where there is context to the value(s).------------------------------Scott ShimerSouthwest Air
In Form have two 'Text MultiChoice' suppose User select first Text MultiChoice as "A" Then in second Text MultiChoice should shows A related values in the Text MultiChoice. How we can do this ?------------------------------manohar vankireddy------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.