Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have 3 tables - Projects, Tasks, and Task Bids. In the parent table, Projects, I have an embedded Tasks table that is editable on the Projects record so managers can just fill in the tasks they need completed. On that embedded Tasks table I have a list-user field where they can assign up to 20 contractors. When I save the Project (which will also save the Tasks) how can I build a pipeline to create separate Task Bid records for each contractor on the list-user field?
Hello Everyone,I am looking to see if there is a solution for uploading files and having them auto populate records on a join table that links my sales order units with document files. I would like to know if it is possible to have the file attachment text contain the necessary info for a pipeline to read and perform the needed tasks. here is what i am currently trying.using file manager plugin i upload docs through sales order table(projects table)then it uploads to its documents tabletesting a pipeline that can read unit# on the attached file once it is uploaded however i seem to get an issue when pipeline goes to create the records in the docs join table, the error message is below so at the moment i cant even tell if it can read the unit# and create a link for each unit per attachment.Validation error: Incorrect template "{{b.id}}{{b.related_sales_order}}". ValueError: invalid literal for int() with base 10: 'id'
I am trying to write a simple pipeline that once a record is saved to the Transactions table a pipeline runs to modify the transaction name and add to end " - " and the year the record was created.I can use the record created field but that is inclusive of the full date and time and I am only looking for the year.Thanks, Eric
Hi,I basically imported the following YAML. And everything is looking ok until it comes to the Body of the “Save File to a Table” Where I am getting a “This field contains invalid jinja references” error. Thank you so much for helping! Below is the Body (image also below):{"to": "bts4ydgrs","data": [{"340": {"value": {"fileName": "{{a.json.fileName}}","data": "{{a.json.data}}"}}}],"fieldsToReturn": []}}}]}"fieldsToReturn": []}The Below is the YAML I imported: # Doc Gen Testing## Account slugs:# - quickbase[CHANGE ME]: Realm Default Account <None># - microsoft-outlook[CHANGE ME]:# <None>---- META: name: Doc Gen Testing- ACTION quickbase[CHANGE ME] quickbase_api make -> a: inputs: method: GET url: https://api.quickbase.com/v1/docTemplates/1/generate?tableId=DBID_CHANGE_ME&format=pdf&pageSize=Letter&filename=Invoice&margin=1 &n
Hello!I am building my second app and trying to tie it into my first -- it feels like it wants to be separate because the users who will primarily use this app are from another department, but there is a lot of collaborative/universal information in my existing app I'd like to be able to share between the two apps, though there's too much in my initial app that the other department should not have access to, so creating a whole separate space for them and feeding in the pieces I do want shared access to feels like the best way, rather than bring them into my existing app and cull back their access.To that -- A) does that logic track properly? And B) Do they need a relationship to every table I watn them to access, including grandparent tables? I wanted them to see some grandparent info, and I notice when I run tests using them as a user, that since they're not in that other app, they only see throughput from the table-to-table access, and anything that's generating off a grandparent ta
I have a field that captures the time an event occurred, it is a Time of Day field type. These are examples of the output 8:13 am, 12:28 pm.I would like to create a field that lumps times into 1/2 hour intervals. For example, If the Time of Day is =>8:00 am and =<8:29 am then the interval would be captured as 8:00 - 8:30. If Time of Day is =>8:30 am and =<8:59am then the interval would be 8:30 - 9:00, etc. Nothing I've tried seems to work as I repeatedly run into sytax errors. Does anyone have suggestions?ThanksSheila
On the old style forms, I could show child records and say "allow edit". Then, when I clicked edit on the parent, it opened the child record grid edit table for me to add many new records. They all carried down and created a parent relationship.In the new forms, it doesn't do that. I can hit Grid Edit and it pops up a new window which lets me add records, but the parent relationship isn't auto created. I'd have to go carry down that field. Both the pop out and needing to carry down that relationship are a huge pain. Is there a work around?
I have made a form with EOTI abilities but when I copy the link to the from in a web browser I am prompted for a login. What am I missing?
I have a tasks table, but I want to allow users to enter simple tasks or complex tasks. One form for simple tasks and another for complex tasks.This works for complex tasks and is the default form for all roles.URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_145=" & URLEncode ([Project Number])& "&z=" & Rurl()I am trying this one for simple tasks, but it still loads the complex tasks form (ID=11) even though the URL says form ID 16.URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_GenAddRecordForm&_fid_16=" & URLEncode ([Project Number])& "&z=" & Rurl()Also, this latter one is not loading the related project like the first one does. There has to be a simple way to load form 16 even though it is not the default for all roles.
Good morning!I have a dashboard I built with a field called CLOSED DATE. I set this date as searchable and then as a dynamic filter. It works as is, but the date range in the filter is pretty large. 2018-2025. Is there a way to set a default date range that isn't dictated by additional filters? I set filter rules to be from Jan 1 2025 - Dec 31 2025 and that is the new default for the filter, but I can't select anything outside these dates. I would love to set the default to 2025, but have the ability change this to later or earlier if needed. Any suggestions are appreciated!
User id/Group id is displayed in brackets for all user field (Originator/Executor etc) when we export reports from quickbase.Exported columns contains values as "First Name <abcxs.hjyp>"Need just the name to be exported.Any solution?
Hello,I was wondering is there a way to create a copy of a Dashboard I have in one app and move it to another new app I created. Example: In App 1, I have a page/dashboard named "Clinical Admin Dashboard" with various widgets and images. I would like to copy and use that same dashboard as a template in App 2 so I may revise and update it for the new app. Is there a way to do this?Please let me know what suggestions you may have. Thanks in advance!
I have a field [Types]. there can be A, B, C, D, E, or F.I need a summary report about these [Types] but the output needs to show, A, B, C+D, and exclude E and F. I'm using filters to exclude E and F.So I'm trying to use the Report Formula to create a new field [Performance] and using an If statement to say:if( [Type]="A","A", [Type]="B","B", [Type]="C","G", [Type]="D","G") The hope was that by renaming C and D to G, it would add those counts together when I add this Report Formula to the Column Group. but its only adding "C" not "D". Is this possible and I just have the wrong formula, or am I just going about this all the wrong way?Thanks,A
I have a table that contains payment transactions. The fields in the table that I need in my report include Vendor Name, CardTokenNumber, PaymentStatus. I did not design this table and the issue I'm having is that there is a record for each CardTokenNumber (unique value but not unique in the table) and if the payment is successful, the PaymentStatus will be TRUE and there will only be 1 record in the table for the CardTokenNumber. If a payment fails, the 1st record's PaymentStatus will be FALSE and another record for the CardTokenNumber is added to the table for the payment to be tried again. Records will be added for the CardTokenNumber until the payment is successful at which point the last record added for the CardTokenNumber will be TRUE or eventually it will be determined that the payment cannot be made and the last record for the CardTokenNumber will be FALSE.I need to generate a report that shows the success rate (regardless of how many attempts there are
I am trying to create a rule on a form that will compare the entries for multi-choice fields and if a choice is already selected, then it is not available for the current field selection. This way, a choice is not selected twice.These are 5 ranking fields ( 1 - 5) - all with the same picklist. For ranking field 2, I want the rule to compare fields 1,3,4 and 5 and only display the picklist for 2 with the remaining available options.Greatly appreciate any and all help and suggestions for doing this.Thanks, Monica
I saw this YAML on another discussion board but it throws a jinja error in the Body of the HTTP request that says "This field contains invalid jinja references"# Doc Gen Testing # # Account slugs: # - quickbase[CHANGE ME]: Realm Default Account <None> # - microsoft-outlook[CHANGE ME]: # <None> --- - META: name: Doc Gen Testing - ACTION quickbase[CHANGE ME] quickbase_api make -> a: inputs: method: GET url: https://api.quickbase.com/v1/docTemplates/1/generate?tableId=DBID_CHANGE_ME&format=pdf&pageSize=Letter&filename=Invoice&margin=1 1 1 1&unit=in&orientation=portrait&recordId=1 name: Generate Doc - ACTION quickbase[CHANGE ME] quickbase_api make -> b: inputs: body: "{\n \"to\": \"CHANGE_ME_TABLE_ID\",\n \"data\": [\n {\n \"6\"\ : {\n \"value\": {\n \"fileName\": \"{{a.json.fileName}}\"\ ,\n \"data\": \"{{a.json.data}}\"\n
Is it possible to have fields built in a table be used as individual options based off selections in another table?For example - would it be possible to have a table that houses the item and options and additional options based on the option selected and then relate this have this table relate to another table to display and allow the user to select only certain options and additional options?I've tried to visualize this in a spreadsheet...in the example below if the user selects pink from the options in the proxy field it won't provide any additional options, however if they select green then they will be able to select additional options and so on...Goaloptionsadditional optionsPick a color?Pink GreenBlue Purple OrangePick another color?Black RedWhite Pink TealHopefully this makes sense...- LB
Hi Mobile Qrew! Thank you to all who were able to attend Wednesday’s Mobile Qrew Meet Up. Here’s what we discussed: Jenny Gomez, Technical Support Engineer, started off the meeting with a deep dive into data tables including what is it, how it’s different from lookup tables, advantages, and limitations. FastField's data tables provide a more dynamic and efficient solution compared to lookup lists, with real-time updates, individual row modifications, and integration with external data sources like Google Sheets and QuickBase. Next, she shared four different ways you can use data tables in FastField. Data tables can be created from scratch, from an Excel/CSV file, or by connecting to a Google Sheet or QuickBase table. The process involves configuring columns, setting up keys, and naming the table, and more. During our meeting, we spent a lot of time discussing various formulas, settings, and potential solutions to consider when connecting, syncing, and reporting on connected data table
Hi All,I have multiple report link tables in a form (using the older form layout). The way my form works, is the user will fill in each cell in the report link table to update the records for child tables to the current form. I have some formula fields in the same page that is meant to update when filling in the report tables. However, this becomes very tedious because currently the user will have to fill in the report tables then click "save & close", then return back to the previous page to save the inputed data, and update the formula calculations. Is there a way to include a save & refresh button that will save the data inputted in the reports, and keep the user in the same page? The way it is now, if I use a custom save & refresh button it saves data inputted in the form fields, but not the data inputted in the reports.Any help is much appreciated!
I have a text field in one table that I need to use to populate a multi-select text field in another table via Pipelines. The text field contains a semi-colon-delimited list of people, including their name and title separated by a comma (Person 1, AA; Person 2, BB). This format is required for our purposes and cannot be changed.I have already created a multi-select formula helper field in my original table using the Split() function to translate these values to the correct format prior to using Pipelines to copy them to the other table. In my original table, the formula multi-select values appear correctly:Person 1, AAPerson 2, BBHowever, once Pipelines copies the value, it seems to be exploding and recreating the multi-select options and now also considering the commas to be a delimiter, so my resulting values look like:Person 1AAPerson 2BBI assume this is a bug and not intended behavior so I will submit a support ticket, but in the meantime, does anyone have a workaround for how to g
Hi,The use case for my application is for users to track their testing results - there is a parent table for requests and a child table for activities (i.e., test results). I am wanting to create a field within the Parent table that lists all of the people who have submitted an activity for the parent request. Any ideas?
Hello,What is the best method to create a report based on a user's role? I created a table which contains a list of users, their ID, and their role. I tried to establish a table to table relationship with the Projects table and User List table. But, the User List table fields are blank on the Projects table default report. I tried to import the User List data into the Projects table, but this option failed to work for me.
I have configured a QuickBase Pipeline to trigger when a new record is created in a specific ServiceNow table. While the pipeline is triggering and executing Poller events as expected. But it is not retrieving data from ServiceNow into QuickBase.I would appreciate any guidance or recommendations on resolving this issue. Thank you for your assistance.
Hello,I have a URL Formula field I created that I'm trying to use as a Delete button on one of my tables, but I keep getting this "A formula cannot end with an assignment to a variable declaration." error message when I try saving it.The formula I am using is this:var text Delete = URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord&apptoken=*XXXXXXX*=" & [Record ID#];Does anybody know what I should change? Please let me know.
I am messing around a bit here looking to create a dashboard to summarize some specific information. I am starting with a report. My fields are as follows: Market Type (subject), Probability (in percent 0,1, 10,20,70,90), Expected Revenue (in dollars), Status (open or closed), Region (for filtering later)Example Data: Football, 10%, $1000, Open, EastBaseball, 90%, $500, Open, WestFootball, 30%, $700, Open, SouthSoccer, 10%, $600, Open, South I am trying to summarize this in such a way that it looks like the following:Market Type 0 1 10 30 70 90 Grand TotalFootball $1000 $700 &nbs
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.