Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,I created new table to table relationship and one new column (last column) has been added with the link. How can I remove it ? How can I avoid it from getting added while creating relationship?------------------------------Mrunali Kadam------------------------------
This one has been giving me trouble for about a week now. What I am trying to do is create a button that will open a print (I have a field that extracts the URL of a file attachment field), check a box that says the print has been opened, and reload the page while still in edit. The desired workflow would look like this: user adds a child record and before they fill anything out, they have to open a print. When the print has been opened, it will check a box that verifies that they opened the print. Without manually refreshing the page, they should then be able to fill out the child form and save and close. After several failed attempts, here's the current code I'm working with that sort of works: If([Customer Print URL (Lookup):]="", URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&_fid_203=1" & "&rdr=" & URLEncode(URL
How do you get a count of the records processed by a 'search' step within a pipeline.I would like to add this count to a 'create record' step at the end of the pipeline.------------------------------George Romanowski------------------------------
I've one embedded report. I wanted to hide 1 column and add 1 column but now sure how to filter/organize columns and change display.Please advise. ------------------------------Mrunali Kadam------------------------------
I'm probably missing something simple, but haven't been able to find the right sequence of events to make this pipeline work as needed. Hopefully someone can point me in the right direction.There are three tables involved in this pipeline. We can call them Orders, Invoices and Invoice Data. The pipeline is triggered by a checkbox field, Generate Invoice. This will typically be checked in grid edit and can be a single order or 100s of orders that will be combined into a single invoice. Once the checkbox(es) is(are) checked, the pipeline will start and create a new invoice record, prepare a bulk upsert in the invoice data table, search the orders table for the orders, In the loop: add a row to the upsert, remove uncheck the checkbox for generate invoice, end of loop, commit the upsert.The problems with that flow are it is creating a new invoice for each row in the invoice data upsert and I have not been able to find a way to pull the invoice number from the
Do the edit and view eyeball and pencil png exist somewhere? I want my user to be able to view and edit a record, but I want the record to open to a specific form. My users are very used to clicking on the eyeball and pencil so I thought I could probably get close to creating it by creating buttons with those images. Not sure how it will look or work, but thought I would give it a try!Unless anyone else has good ideas on how to be sure my user lands on the correct form when viewing a record.------------------------------Mike Tamoush------------------------------
So I am trying to match up and check work/allocations by checking Grower/Supplier Tag Details against the "Product ID" section above. Currently running into a large formula problem and wondering if there's a better option. I am using "T" to test, so that's the end destination. Eventually there will be 10 Ts, one for each Product ID. on T1, the goal is to test F, G,H,I to see if they equal A. Any that do should have their corresponding values J,K,L, or M added up and subtracted against Nrinse and repeat for T2, "" they equal B. "" subtracted against Oetc. My problem is a problem of if thens simply being to long to complete for all of the potential scenarios. If I'm correct, the scenarios would be 10 factorial.------------------------------Davis Ward------------------------------
In my report, I've this questions section. I added questions but its not getting added over here. I do see entries in the respective table. I'm not sure what is missing. Please advise. Add Question button opens this page ->------------------------------Mrunali Kadam------------------------------
Hello: I am trying to create a view that shows whether staff are placed at each location each day of the week. It would be preferential to see the date vs. Mon, Tues, etc... I have 3 tables: Staff, Location, Schedule. Staff is a list of employees. Locations are a list of locations. Schedule is where I assign Staff to a Location on a Date, with a Start Time and End Time. I also have a formula field to calculate Total # of Hours. I have a table to table relationship between all tables, so I'm able to pull in a summary field from Schedule into Locations to see the Total # Hours, however, I need to see whether a location has coverage on each date. Total # Hours won't work since it will be cumulative. I'm not sure how to achieve this through summary field or report. All help is appreciated.Thanks! ------------------------------Quincy Adam------------------------------
I have a situation where I'd like to automatically create sequential [invoice] numbers in a parent table based a [new,] unique value in a child table. If I was interested in approaching this using QB System Variable(s) and/or Javascript/Formula-RTF (I am a novice in both), how would I go about this?Thanks in advance------------------------------Ken HillyerI support people who cure cancerAlliance for Clinical Trials in Oncology FoundationBoston, MA------------------------------
I have two applications. the table in app 1 is connected to app 2.The key field in the table in app 2 is an input field in app 1.If I change the value in the input field in app 1, will that mess up the connection for app 2 or will the data automatically refresh app 2?------------------------------Rhonda Parriet------------------------------
I'm trying to wrap my head around something I haven't set up before.I need to automate the creation of 365 records, when a single record is created.So when a staff record is created, I need to create a years worth of Daily Notes for that staff member. Notes are a different table. Each note will have the date, and a place for the note. So if a staff member is created on May 1st, I need to have notes for May 1st, May 2nd, etc. All the way till April 30th of the following year. Leap year would need to be considered here as well.Any suggestions on the beat way to go about this? I'm thinking I need a seperate table to act as a template for each day?? Thanks for any suggestions.------------------------------Dana Hauser------------------------------
I have a report of the format https://xxx.quickbase.com/db/xxxxxxxxx?a=q&qid=xx. I would like to consume this using the REST API, but only select the relevant records using a query. I noticed that you can supply a query using the web ui of the form https://xxx.quickbase.com/db/xxxxxxxxx?a=q&qid=xx&query={xxx} and it shows the result of the report returning only the rows selected by the query. However, if I try to access a similar url via the REST API, for example https://api.quickbase.com/v1/reports/xx/run?tableId=xxxxxxxxx&query={xxx}, I get the following error:-HTTP request parsing failed with error: "Malformed URI: /api/reports/xx/run?tableId=xxxxxxxxx&query={xxx}"I have checked and I am not sending "&" so that is probably being converted from the server side.Is this a possibility, or am I going to have to instead send a series of separate table queries and construct the final result?------------------------------Chris Hills---------------------------
I need to pull out the text string which in the example below is "MVP623037 (Load ID)" however it is not always in the same place in the field. It could be the first string, second or last string between commas for example. How can I pull this out? Am I also able to only pull out the "MVP623037" in that string via formula? 1381207285 (PRO), MVP623037 (Load ID), MVP623037 (BOL) ------------------------------Alycn Bjergo-Justen------------------------------
We use Kanban view to track cars we are working on, like tasks. We have the Kanban columns set to who is working on the car. (task)we also have a field that lets us pick what the task is. (Tech, QC, Pick-up, Delivery)Is there a way for the Kanban movement (drag and drop) to change other fields.Like one the car is dragged to ready for delivery the current task automatically changes to "Deliver" vs having to go in and change it. ------------------------------Ali Mohsenian------------------------------
Hello, I am looking for a code that will tell me how many years have passed from a certain date. For example, we have a field for an employee's Start Date. I would like another field to calculate how many years they have been working here based on today's date. Any help would be appreciated! Thanks, Meagan ------------------------------Meagan McOlin------------------------------
I'm currently using field level permissions on several of my fields to hide them from regular users in the app. In addition to this, i have tables that are also hidden from these same users.In order to calculate the values that I need the regular users to see, i need to reference fields that they don't have access to as well as some of these other table's fields (in the same app) to calculate the final value that they see. Unfortunately, no matter what I try, i can't seem to get it to work and the regular users only see blank or $0 values in the formula fields. I've tried setting "Override sub-field access" for all of the fields referenced but nothing seems to work. Any help would be appreciated.------------------------------Brett Brett------------------------------
Save and Close Button
Is there a reference available that details all of the HTML that is acceptable to use in a formula rich text field?------------------------------Adam Keever------------------------------
Something changed this week that has broken certain Summary Fields at a customer. This is very strange If the relationship has only date based Summary fields, they no longer calculate and will produce a value of zero. If the relationship has dated based and numerically based summary fields, then the date based summary fields will calculate. I made a video that shows the problem:https://rumble.com/vie8z7-summary-field-demo.htmlSince I was able to reproduce the problem on a different realm, I assume that issue is platform wide. If your customers dashboards are now showing zeros when last week there was data, this might be the issue. This has been submitted to Customer Support and I am waiting to hear what they say.------------------------------Don LarsonPaasporter------------------------------
I'm trying to do kind of a fun thing for my team's ticketing set up. We have a report of tickets that haven't been assigned/worked on yet, sorted by priority. Typically, a member of my team would click on the report to find their next ticket to work on. But I want to find a way to add a button on a home page dashboard that randomly selects and displays one of the records from that report, and that team member would then work on that ticket. I'll name the button "Spin the wheel of punishment" or something like that. I haven't been able to figure this out, maybe something to do with the MOD function? Ideally, there would be a way to display to display the random record on the home page itself, but if it has to click through to a report that just shows that 1 record, that's fine too I suppose. ------------------------------Harrison Smith------------------------------
This is a registered user with the role/permission to see this data. When I emmulate the user, I can manually go to this report and view it.Why can I not add this user to the subscription?------------------------------Alycn Bjergo-Justen------------------------------
Good afternoon,I'm trying to find a way to do a check box formula to make a check box be checked if a date is past due. So I have a certification table that has the employee certification and expiration dates and I am wanting some sort of visual check box to check if one of them is past due. Im wanting it to look at all the dates also. see screen shot below ------------------------------Matthew Jones------------------------------
Is there a way on a pipeline to send a FINISHED status to a form? so you can visually see that its done? I have some pipelines that are handling 1000 to 10000 records and it would be very convenient to know WHEN its complete instead of constantly checking back.------------------------------Amanda Bloomrose------------------------------
When doing an API_EditRecord in a Rich Text format, we would like to know how to end it, with a outside website and not an internal website. We would be happy to use a url field if it will work also.?Right now here is our working code that redirects to our Quickbasevar text URL=URLRoot() & "db/"& Dbid()& "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&usertoken=XXXXXXXXXXXXXXXXXXXXXXXXXXX" &"&_fid_27=Approve";"&rdr="&URLEncode(URLRoot());"<a href=" & $URL & "\" " & $stylebtn & " >Click to Approve</a>"------------------------------Michael Knecht------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.