Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Leaving this here for you. Ran into a problem where when I printed the Doc, it showed this crazy error. {"message":"Bad Request","description":"This document template has field markers that require a Record ID."}What does that mean? If you look at the two URL's of the Print button below, the second is cut off. var text fileName = "template";https://api.quickbase.com/v1/docTemplates/1/generate?&tableId=bkp8cwnzs&realm=hardermech.quickbase.com&format=pdf&pageSize=Letter&filename=template&margin=0.25%200.25%200.25%200.25&unit=in&orientation=portrait&recordId=3364var text fileName = [Override Template Name];https://api.quickbase.com/v1/docTemplates/1/generate?&tableId=bkp8cwnzs&realm=hardermech.quickbase.com&format=pdf&pageSize=Letter&filename=512604-19254.Oregon.Summit this one is missing all this stuff at the end: "&margin=0.25%200.25%200.25%200.25&unit=in&orientation=portrait&recordId=3364"H
I'm creating a reoccurring notification with a PDF attachment. The attached file name is only showing as "document-1". The pdf is created through the document template and I'm able to already save it with a specific file name. How do I change the file when it's sent out as a PDF attachment with the notification?
It appears that there is a limit of 500 elements on a form. Is there a way to see a list of all elements on a form like there was on the legacy form? If not, is there a way to get a tally of elements on any given form?
To overcome 100 value limitation, I created "Agent" table to capture all drop-down values and used it as reference in Company's Employee field as below. It has approximately 600 values.But when I save the record, I encountered 100 limit error (The field with ID '45' would have more than 100 choices:)I tried switching the Employee's field Input type to From list, cleared values and back to From another field. But it didnt work.Is there an alternate solution for this? Please guide.
Has anyone else run into this issue?We created a new style form for desktop and applied it to mobile as well.On desktop, when a user saves a new record by selecting the "Save" option (not Save and new or any of the other available options), they will re-direct as normal.But on mobile, when the user clicks the native save button that follows them down the form, the record saves, a "record saved" message briefly shows at the top of the screen, and then the user remains on the Add Record page with all of the information they just recorded. If you do not notice the message that flashes on and disappears from the screen, it appears as though no action occurred, which naturally makes a User want to click the save button again. This is causing many duplicate records to be created and causing confusion for users as they are unsure with what to do next.We created a work-around by adding a Rich Text field that will complete the save action and redirect the user as intended, but we are unabl
Friends,I have a multi-select text field whose source is a table. The table has nearly 10,000 rows. When the user clicks on the field to select the choices, it takes forever to load all the rows. Even the browser asks if we want to wait to close the window. Is there any way the speed can be improved? I check the field properties; there is not even an option to filter based on the value of some other field. Any ideas?
I have a quickbase app that I created for my users. I use the sandbox feature for version control etc.My users are asking for complex reports to be created that they can use. But I am unable to create them in the Live version of the app. I can create personal reports but not shared reports.It used to be that you can always (in fact quickbase used to recommend) shared reports in the live version. But not anymore.How do I do this?
I'm on the Qcrew meetup for cascading permissions, and it reminds me how much I detest the (necessary) zillions of tables we might create, and how they are potentially confusing for an end user. I know we can hide tables, but they're also a lot to look at as an administrator.Would Quickbase ever consider a sort of self-designed table organization structure -- wherein users can organize tables in nests that make sense for the user, like a folder structure (of course, some tables are children under multiple parents) -- or maybe even offer a dynamic structure offering? The sheer number of tables can be incredibly overwhelming as apps get more complex.
I want a pipeline to do the following:Go to a table in an application ASearch for records meeting a certain criteria in that table (specifically, the number of records that were completed in the previous month)Count the number of records foundGo to application BCreate a record in a table in application BPut the count of the records found in application A in a field on the form (fields: 1 application A name, 2 is count of records found, 3 date the pipeline ran)I want the pipeline to run this monthly on a scheduled date. Can someone kindly tell me the steps I would need to include in the pipeline to make this work? High-level is all I'm looking for. Thank you!
I am trying to improve pipeline performance and need guidance on the best approach please.When approx 1000 records are created from csv import using ImportExport action in TABLE A, the pipeline should look for TABLE B ID based on a text field in TABLE A and relate. Attached sample pipeline.When records are imported, the pipeline runs, but noticed the traffic warning. Bulk upsert may not work as each pipeline trigger is on single record update.
I created a multi-select text field which should use values from another table's text field. On the record page, when I select value and save, it displays below error message. I removed values but still the same - switched input type "From list" (cleared values) back to "From another field". Please help. The field with ID '45' would have more than 100 choices:
Hi all,I have a drop down field with choices for a 'job status'. I've recently refined the list of choices, and I want to know if there's a way to force a user to have to select one of these new choices next time they update the job record.Currently, they can leave the existing status in place and save the record anyway, with the choice highlighting in red in the report. Is there a way to do this?Thanks in advance.
Hi All, I Have 6 yrs of experience in quickbase development, Optimization, Automations and integrations I have integrated different applications like asana, salesforce, GCP and procore with quickbase.I have implemented few integrations to fetch the data from Google forms/Google sheets and to update the data in Quickbase table with quickbase APIs.mailto:vkamala.upw@gmail.com Regards, Kamal.
Hi,What is the proper work around to allow duplicate entries with a field being marked as "Must Be Unique"? Thanks!
I am trying to view a thumbnail of a PDF in a report or from file attachment. I have used the image preview in the Quicbase excahnge and have modified it to my corerct fields but I am unable to see the thumbnails. Any hlep is appreciated.https://ciclops.quickbase.com/nav/main/action/exchange/qb/library/image-previewMy Formula - Rich Text fieldIf( [Tear Sheet]<> "" , "<span style='width:400px; display:inline-block;'> <img style='max-height:400px; max-width:400px' src='" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID# - Company] & "/e75/v0' /></span>")
Hello!What drives the drop-down menu in the "change owner" email list in notifications and subscriptions? My list comprises of me (only person with app edit permissions), and my system office's realm manager (I think that's what their role is anyway).I need a middle-ground to change subscription ownership to my team members - including those who otherwise have full app access, just not app edit permissions - as well as a new role coming on board that will have more limited access, but will be crafting their own notifications.Thanks!
I have multi-line text fields with unlimited length. In table reports I'd like them to function like social media comments where long strings of text are revealed by clicking the ellipsis ('...'). Wondering if this can be done in a Formula-Rich Text field.Currently my field displays the text up to the 30th space character followed by an ellipsis; the full text displays in the hover-over bubble. This works but I'd prefer the simplicity of click-to-reveal.My current Formula-Rich Text field is as follows:var text TitleText = SearchAndReplace([Text Field], "\"", "'");If(Part([Text Field], 30, " ") != "", "<p title=\"" & $TitleText & "\">" & Part([Text Field], 1, " ") & " " &Part([Text Field], 2, " ") & " " &Part([Text Field], 3, " ") & " " &Part([Text Field], 4, " ") & " " &Part([Text Field], 5, " ") & " " &Part([Text Field], 6, " ") & " " &Part([Text Field], 7, " ") & " " &Part([Text Field], 8, " ") &
Hey Y'all. I have a question on how the Body works in the HTTP Pipelines Channel. Before I begin I have everything working and set up correctly (Was able to do it in Postman and was able to do GET Requests in Pipelines) I cannot figure out how to insert my body in HTTP node. I have tried a lot of things to get this to work. I double checked the encoding but maybe there is another option I need to use? I think my problem lies in the to__json Jinja function (If i even need to use it) Any tips are appreciated!! This body I was able to use in Postman and it worked!
I have a Start date and end date I am using the Weekdaysub(end date), (Start Date). but i want to add a IF statement like say to add saturdays to the mix.so if I was to set the date from 5/25/2025 and end on 5/30/2025 but if the saturdays check box was clicked it would also add the saturdays between those dates and return 6 (Monday-Saturday) and if the saturdays was not checked it would return 5 (Monday - Friday)
Greetings, everyone!I'm at my wits end trying to get a redirect to properly fire in a Formula URL button. I'm using the URL as a "Submit" button that changes the phase of the record, then I want the app to redirect to a report. All I can get is a redirect to the app homepage which is not intuitive and undersirable.Here is the URL Formula:var text submitURL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_34=Items&apptoken=<token hidden>";var text redirectURL = URLRoot() & "db/" & Dbid() & "/a=q&qid=7";$submitURL & "&rdr=" & URLEncode($redirectURL)Can someone help me figure out what's wrong with this implentation?Thank you!
Hi, I want to find the count of how many Sundays are there in a month basis on which i would like to find out No of Days in a month - No of Sundays.I have created a daily data entry form in which the user will enter the date. I would like to find out how many sundays will occur in that given month for which the date is entered.For Example if the user enters the date as 15.03.2020 then March 2020 has 31 days and 5 Sundays so 31-5=26 should be my end result.Is there a way thru which the same can be achieved?RegardsGunsham------------------------------Gunsham Lakhiani------------------------------
Team,I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value. [SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO].I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected.I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in.[QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form?What I tried:I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change).Tr
I begin with one trigger step and in the next step I need to filter records to match date time fields in both tables.My workaround is the native "is on date" filter but it would be best if I could include the timestamp portions of the field. Is there a way to format jinja to accomplish this? I've tried several variations but here is an example of one. {% if a.pull_date == b.pull_date %}{{"TRUE"}}{% else %}{{"FALSE"}}{% endif %}
I have a two table application and was wondering if there is a way to limit the amount of Child Records that can be added based on the selection of a Drop Down field? When a user opens the form the first thing they are asked is the level of a dealer. Once that vaue is selected is it possible to have a rule that says if dealer level field is say "Gold" "X" amount of child records can be added. Once that limit is met a message is diplayed telling the user the max amount of records has been met or the "Add Another Record" button goes inactive.
I'm building a new Table [Daily Time Cards], now trying to calculate for overtime. I built formula fields for week and year number, with the idea that I would query the same table for [Related Team Member] those number fields and only render total hours logged for the week, not on the same Record ID (or blank, since could be the case initially).Example: A user logging time submitted 38 hours previously this week in prior saved time cards. On Friday they have 4 hours to log.The highlighted field should summarize to 38The formula for the new timecard should calculate 2 hours at regular time, and 2 hours OTI attempted to make this field work with a formula Query, then tried doing a self to self relationship. I think the FQ is the way to go, but I get an error "Expecting Records list but found text list" on GetFieldValues.SumValues( GetFieldValues( GetRecords( "{Related Team Member.EX.'" & [Related Team Member] & "'}" &
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.