Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm sure there's a way to achieve what I'm trying to do here, but me and my basic Quickbase skills are at a loss. My app includes: Request records, which need to be approved by multiple users in various roles. There is a separate field for each approval type, the editing of which is restricted to users who have been assigned the approver role for that specific approval. Approver records - basically a table of all the approvers and which type of approval they can give. There may be more than one person who can give each type of approval. Currently each approver can only give one type of approval, although that may change (and in the past I've needed one person to be able to give more than one approval type). I'm trying to create a report that will only display records in an 'open' status that do not yet have an approval of the type that the current user is set up for. So for each record in the table, I want to filter to only show records that are open AND where the approva
Override sub-field access I like this field setting: Use the access permissions above even if they are less restrictive than those of the sub-fields Sub-fields are the fields used to calculate this field's value However, I'm trying to achieve a similar thing between tables, not just for fields within a table. Is there any way I can have a user view child table data that is based on lookups from a parent table, even though the user doesn't have permission to view the parent? I would similarly like to have one for summary fields too. Something like this imaginary field setting for a lookup field: Use the access permissions above for this lookup field even if the user does not have permission to view the parent data within the parent table. Here's my specific example. I have a table of Orders and a table of Supplier Inventory. The Supplier Inventory is viewable by all, whereas I have restricted viewer access on the Orders table to only those users that are involved in
When I execute API_DoQuery in the Code Page I get the following XML results, when detail_note is empty. However, $(this).find("detail_note").text() returns 8 159 True www.yahoo.com 1689364909773 which are the values of the fields below. Does anyone have a suggestion on how check if a field is empty? <qdbapi> <action>API_DoQuery</action> <errcode>0</errcode> <errtext>No error</errtext> <dbinfo> <name>PDA Supporting Documents</name> <desc/> </dbinfo> <variables> </variables> <chdbids> </chdbids> <record> <detail_note/> <support_document/> <record_id_>8</record_id_> <related_pda_support_document___pda_record_id>159</related_pda_support_document___pda_record_id> <iscurrentuserrecordowner>True</iscurrentuserrecordowner> <support_url>www.yahoo.com</support_url> <update_id>168
Recently, a lot of users including myself are seeing 'No Data Available' on our gauge dashboard widgets. Refreshing will sometimes solve, sometimes not. If you refresh enough it seems to work, or closing the browser down and reopening has worked. Is anyone else suddenly experiencing this? ------------------------------Mike Tamoush------------------------------
I have a table that I need to export and save to sharepoint as a csv file. I'll need to do it once a month. Is there a way to do this via pipelines without having to export to file to a shared drive and then upload it to sharepoint? Thanks.------------------------------Carol Mcconnell------------------------------
I have a formula Field that shows up correctly on the form, but on the report I get this in place of what should show up:<TR Anyone know why or how to fix it?------------------------------Ender Taylor------------------------------
I'm trying to find a way to use a formula field to remove double quotes from a text field. So far I've tried the search and replace function and the part function, however because double quotes are how they identify what characters you want to remove, I haven't been able to figure out a way to make this work. ------------------------------Jordan Litwin------------------------------
I'm new to Quickbase so sorry if this has an obvious answer. I'm automating a shipping request email, and I've run into a head-scratcher. I'm calling a numeric field 'Shipping weight' from the 'Products' table with this: GetFieldValues(GetRecords("{8.EX.'"&[Quote/Order Part #]&"'}", [_DBID_Products]), 22) But when I try and multiply that with the numeric field 'Qty Quote/Order', it refuses to compile with the error "the operator '*' can't be applied on types textlist, number". It's eyebrow raising that you can't multiply a number LOL. I've tried wrapping the call in 'ToNumber' but it did not like that either. The full expression is: If ([Qty Quote/Order] > 1, GetFieldValues(GetRecords("{8.EX.'"&[Quote/Order Part #]&"'}", [_DBID_Products]), 22) * [Qty Quote/Order], GetFieldValues(GetRecords("{8.EX.'"&[Quote/Order Part #]&"'}", [_DBID_Products]), 22)) What am I missing? Thanks in advance for helping out a noob!------------------------------Adam Waring---------
Is there a way to make the Goal Line for Bar Chart reports dynamic based on a summary value, instead of a fixed number?------------------------------Dan Park------------------------------
I am trying to highlight a row if the Checkbox field "Confirmed Sent" is false/No. We have 2 ways to send out invoices, send now or sent via email. I have 2 fields that are checkboxes, the first is "Send Now" and the other is "Sent via Email?". I created the 3rd "Confirmed Sent" which looks at both these fields to confirm the invoice has been sent either way. Now I want to highlight any row where "Confirmed Sent" is not yes/true. I tried using the IsNull function in the report settings with no luck: If(IsNull([Confirmed Sent], "yellow")) I also tried creating a formula field to do the same but I keep getting syntax errors. Any ideas??? ------------------------------Kelly Lyons------------------------------
Hello! Really new to QB and I have been tasked with learning how to auto-populate. Here is what I have going: One table has products that are incoming from a customer. These products are checked in and then sent to one of three testing labs. The testing labs each have their own tables. I need to be able to fill out the product information in the incoming product table then it automatically send that information to the correct table for the testing lab. I was told I need a pipeline but I do not think that is the case? Any help would be appreciated! ------------------------------Shawn Clarke------------------------------
More context here Discussions I was able to use a pipeline to create child records after manually adding fields to parent but the requirements have changed and I now need to create both the parent and child from one csv file. My current thought process is that I need two separate csv files and somehow get the record id after the first step in the pipeline and add that value into the other csv column with the recordid header all within pipelines but I am not sure how to approach this. ------------------------------Chris Baker------------------------------
Does anyone know a way to display child records directly on the new form builder? The report link just gives the link to click and I see no way to display the records. I know I can add it as a report, but that looks very clunky. Also I build a lot of forms where I allow the user to edit the child records directly on the parent and I don't see that as an option anymore either. Kind of bummed to see this because I am loving all of the new options but I won't be able to use it if I can't display the child records. ------------------------------Amber Goodman------------------------------
Sorry team I sorted my issue but didnt know how to remove this. ------------------------------Jessica Matenga------------------------------
I love the Quickbase Code Page Samples App, with all it's pausing and refreshing. However, there's no sample codes for adding a new record, pausing and going to the saved record. Anyone out there know how to make a button when adding a record that will pause for 2 seconds before showing the new record? Here's the Code Page Samples intro: https://community.quickbase.com/blogs/graham-leto2/2021/03/02/code-page-samples------------------------------Matt Stephens------------------------------
Hello all, Context: I am a new hire patching holes in an existing QB system. Situation: Currently, we have a table that holds all job records that we have taken on. This table uses formulas to create a Rich Text field that will contain high level information about the job. List("/n","<span style=\"color: #3A55A5\"><b> Name: </b></span>" &[Customer Database - First Name]&" "&[Customer Database - Last Name], "<span style=\"color: #3A55A5\"><b>Job Number:</b></span>" &[Job Number #], "<span style=\"color: #3A55A5\"><b>Loss Date:</b></span>" &[Loss Date], "<span style=\"color: #3A55A5\"><b>Job Address: </b></span>" &[Job Address: Street 1], [Job Address: City]&", "&[Job Address: State/Region]&" "& [Job Address: Postal Code]) On the table, these values populate no problem. When there is a new job added an email is sent out containing t
I'm trying to create a table on QuickBase utilizing the NetSuite Service connection that already exists, however I keep getting the same error, "Token Based Authentication Error Occurred". Attached an image. When I input all the credentials needed, it takes me to the NetSuite page, allows me to login, and requests me to 'allow' or 'deny' access to the specific role. Once all that is complete, the error then occurs. My connection on the NetSuite side has been established and everything is functioning properly on that end, however the error that keeps popping up shows up as a QuickBase URL. Any idea how to encounter this issue?------------------------------Ziyad Elabady------------------------------
Need help with only tracking items in a certain period contains(([Invoice (A)],current month), "6 - Project Complete (Current Month)") Something like this------------------------------Nicole Cabral------------------------------
Hi there, We use QuickBooks Online for our invoicing system. We have a pipeline that sends the invoice data from QuickBase over to QuickBooks Online to create an invoice. I'd like to provide the current invoice balance to my team, so they can see if a project has been paid. I tried sending over the payment data via Zapier, because I couldn't figure out how to do it via a pipeline. But now I'm finding that it isn't accurate if a customer pays multiple invoices with one check. Does anyone out there have any experience solving this problem? Thanks! Scott------------------------------Scott Cote------------------------------
Hi everyone, So in my world we have a concept of Production and Staging. In production, changes are done using the Sandbox, while new pipelines are built in staging (since pipelines can't be used in the sandbox). Main issue I've run into , that cause me some headaches: I can't take my schema changes from the production app sandbox and duplicate them in staging. I have to manually make the same schema changes in 2 apps to maintain consistency during development to ensure people can test the changes End to end. Developing pipelines in the "staging" app, and moving to a production pipeline (that works against the production app!) requires a deep audit of the pipeline, since the staging and production apps aren't identical in field ids (sometimes) , and the account slugs / table ids between Production and Staging are different. Generally easy to change via the YAMLs, so far less of a headache then #1 I've experimented with a couple things, but feel I am missing a k
I have a large table with many records. The roles are not allowed to grid edit on this table, however, I need them to have access to grid edit ONE report from the many that are on this table. Is there a way to set this up? I have gone through trying to Override Role settings through report, and it does nothing. I have tried to change the permission through the form, no cigar. Before I try to find a back-end solution, is there any way to override role permissions for one specific report?
Is anyone having trouble saving child records using the new forms? When I try adding a child record to a NEW (not yet saved) parent, the "Add Child" button saves the parent record and sends me to the child record form where I can enter the record details, but when I click save, instead of being redirected to the original parent, I land in a form to create a new parent record. The URL still has the &z=" & Rurl() redirect language included, and because this only happens when using the new forms, I suspect it is a bug. Can anyone confirm?------------------------------Eleonora Ruffini------------------------------
Please fix this formula. Thank you If([Projected Start Date]>Today()+3,"red","white")------------------------------BuildPro------------------------------
I want to run a pipeline that does three steps vi api request: a.Run import opon trigger b.Search some records and delete them or delete via api a certain search qid. Need step a to have finished: c. Run a different import. I have a couple of coded solutions that use this kind of approach. I did that via code using javascript "promises" but i want to keep things with native quickbase tools. I have read some posts but not a definite solution. Someone suggested to introduce a pause between a and b using clock. That will work in 99% of the cases but i am afraid of those 1%. Is there a way to read the output of the api request? maybe when you read no error, you continue with next steps. Thanks on advance ------------------------------eduardo valdes------------------------------
Okay via a pipeline, thanks to Chayce Duncan, I was able to implement the below logic. What this does is sends a report to our foreman every day at 6pm, if they have not approved a time entry. I have recently discovered that we have 30+ foreman. This of course would require us to make 30+ reports and pipelines customized to each one of them. My question now is will it be possible to take a report with all of the foreman on it and somehow dynamically filter with a single pipeline. For example the report will have the following foreman who have not made time approvals: Chuck Frank Dan and at 6 pm each day I want to email only the the foreman's unapproved time entries to the respective foreman, so I do not want Chuck to get Frank's and etc. If someone could walk me through that logic I would greatly appreciate it. ------------------------------William Hunter------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.