Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi,I'm trying to update the record in a table in Bulk using API_ImportFromCSV. But in my case the Merge Field is a Formula Field. Whenever I call the API to update it's throwing an error saying "Trying to update non Unique Value to the filed marked as Unique", pointing to my merge field.Please suggest me how can resolve it.Thanks in Advance!!Thanks & RegardsChethan Shetty------------------------------Chethana Shetty------------------------------
Hello,New to Quickbase and was wondering if anyone could help me. I have a Kanban report in my application and I was wondering if you could make this report static (cannot be modifiable). I do not want users to move the cards around, but I just want them to just see the cards. Is this possible or is there another report like the Kanban Report that can do this?------------------------------Daniel Sim------------------------------
I can't seem to find the solution to my issue. I have two task tables: [(staff name)] and [Aggregate]. The staff person creates a record in [(staff name)] table, which then needs to be added to the [Aggregate] table, then hidden from the [(staff name)] table. I have tried so many different formulas and can't seem to find the right way to do it. I've been trying all week and have a deadline to get it done so our staff can start entering their tasks. Someone help!------------------------------Bethany Hudson------------------------------
I am currently trying to build a url button that saves and edits a record simultaneously. The issue I ran into at first was the record was not completely saved so QuickBase didn't recognize it as a result couldn't edit the record. Now I got the record to save however now its not editing. Providing my formula below - any help would be greatly appreciated. ThanksURLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&apptoken=XX3&dfid=10&_fid_3=" & URLEncode ([Record ID#])& "&z=" &URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=XXX"& "&_fid_134=1"&"&rdr=" &URLEncode (XXXXX a=showpage&pageid=12")------------------------------Wallace (DHS)------------------------------
Hi community,I have been wracking my brain trying to figure out why I am getting a broken link with my Google Map API Rich Text Field. Below is a picture of what shows and below that the code. I don't know what I am doing wrong :(, any help would be so amazing and I would be forever grateful:Code:var number zoom = ToNumber(If([GeotagMap_zoom]="", "", [GeotagMap_zoom]));"\n<img src='https://maps.googleapis.com/maps/api/js?key=MYAPIKEY&callback=initMap"&[Customer - ServiceAddress]&"&zoom="&$zoom&"&size=512x512 &maptype=roadmap\n\n&\n\nmarkers=size:med%7Ccolor:blue%7Clabel:G%7C" //size and type of map, color and label of pinOther code I Have tried:<img src='https://maps.googleapis.com/maps/api/staticmap?center=&key=MYAPIKEY"<img src='https://maps.google.com/maps/api/staticmap?center=&key=MYAPIKEY"MYAPIKEY is just filling in where my API key from google will be placed. My API key that I got from google does not have an
Hello,I have two date fields called 1) Entry Date 2) Ship Date. I want to create a numeric formula field that tells me how many days it took from the Entry Date to the Ship Date to track how long each order takes, any help would be great.Thanks,Derek------------------------------Derek Pipal------------------------------
This may seem like an odd question, is the current user when a pipeline or automation is running the person who created the automation or pipeline? I'm asking because I have an automation (soon to be converted to a pipeline) that is throwing an error when updating some records because there is an issue with the custom data rule in the table. I was thinking if the user when the automation or pipeline is updating the record I could add a condition to the custom data rule to fire only if the current user is not an admin.------------------------------Paul Peterson------------------------------
Does anyone else have constant issues with pipelines not refreshing, or not wanting to save changes, or simply having pipelines look blank when you go edit them?Any of these issues I usually just need to give it 10-15 minutes and it resolves, but it happens constantly. Wondering if my frustrations are with pipelines, or perhaps just my internet connection....------------------------------Mike Tamoush------------------------------
Is it possible to create a button that directs the user to a Dashboard that contains 3 child reports from the parent record? All the reports on the Dashboard would "ask the user" for the Record ID of the parent record. If yes, what might that button formula look like?------------------------------George Bramhall------------------------------
I have a Projects table with two dates (Start/End).I have a subcontractors child table (usually around 10 subcontractors per project).I want to trigger a Pipeline that creates entries in a 3rd table (which is a child to both). The entries will be - one entry per month per subcontractor between the two dates. For example, if start date is 1/1/21 and end date is 12/31/21, I want it to create entries for February, March, April, Etc (a date field on the entry can simply be dated 2/1/21, 3/1/21, and so on. Ill probably include the first and last month but that is moot, I can control that with >= formulas).The trick: If the dates are changed I want the Pipeline to add on any more months now needed (deleting is probably unnecessary as I can filter out unnecessary months on reports).The second trick: I cannot have my pipeline delete all the entries and recreate them if a date is changed. I need the Pipeline to search for what exists, and create the missing ones.Where I currently can do:I al
I am trying to use pipelines to set a "clock out time" of 4:30PM Eastern for all timecards that are still open at 9PM. I am setting up a pipeline to run at 9PM that searches all records where the Clock Out Time field isn't set and then putting a time in.I am trying to use:{{ (time.now|timezone('America/New_York')).date() + time.delta(hours=16, minutes=30) }}When I do that, I get 16:30 UTC, not UTC Eastern Time. I can just offset by 5 hours and use "hours=21' but that will run into problems when we start using daylight savings time again.How can I use today's date and 4:30PM regardless of what that is in UTC?------------------------------Edward Hefter www.Sutubra.com------------------------------
Hello,I've created a button that, when clicked, updates a date. I've used this button many times in a form, but I want to use it in a report and stay in the report once the date is updated. Here's my formula for redirecting back to the form:URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&apptoken=xxxxxxxxxxxxxxxxxxxx" &"&_fid_33=Now" &"&rdr=" & URLEncode(URLRoot()&"db/" & Dbid() & "?a=dr&dfid=12&rid="&[Record ID#])The above redirects me to the actual record. I would like to redirect back to the report (a=q&qid=19) but not quite sure how to do that. Any help with this would be appreciated.Thank you,Kim------------------------------Kim------------------------------
I have several Pipeline Automations that create a "task" whenever an employee adds an event to their calendar. Each person has their own table. I want them to be able to add that task, whenever they have finished editing all the fields, to an aggregate table that will show every staff member's completed tasks. At the same time, I want that task to be hidden from their individual table.I wasn't sure if this was better to do through a pipeline or through relationships and formulas. I think it only needs to be a formula.------------------------------Bethany Hudson------------------------------
I don't see a pipeline trigger option for add or update. Will update fire for new adds too or will I need a trigger for a new record and an updated record?------------------------------Paul Peterson------------------------------
Does anyone see anything obvious with this code that I may be missing? <h1 style="text-align: center;">Arcosa Marine</h1><p style="text-align: center;">Continuous Improvement Idea Submission</p><input type=hidden name=fform value=1><h1 style="text-align: center;"><br></h1><p></p><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Continuous Improvement Idea Submission</title><style type="text/css">body{font-family:Verdana, Arial, Helvetica, sans-serif;font-size:11px;}input{margin-left:10px; padding:5;}select{border:0; margin-left:10px; padding:5;}p, h1, form, h1, form, button{border:0; margin:0; padding:0;}.spacer{clear:both; height:1px;}/* ----------- Add Submission Form ----------- */.addrequestform{margin:0 auto;width:500px;padding:14px;}#stylized{border:solid 2px #b7ddf2;background:#EEEEEE;}#stylized h1 {font-size:11px;font-weight:bold;margin-bottom:8px;margin-top:8p
I am working on improving my company's Quickbase Contracts App. So in looking at the latest Contracts, sorting by latest 'Start Date' I am showing data sorted into monthly periods, which are sorting properly. But as you can see from the three contracts started in January 2022, they are not in descending order, with the middle one in between two other contracts with earlier dates. (see picture) I have verified descending starting dates.------------------------------Bob T.------------------------------
I am setting up a timekeeping system and want to use printed QR codes to clock in and out of specific tasks (the codes would be on the bin of material being worked on).I have a URL for clocking in and one for clocking out that works, and on the form I have the QR code that has the URL hide or show based on whether the current user is currently clocked in or out. I am trying to have a QR code that will determine which user is logged into the phone that is scanning the QR code, figure out if she is currently clocked in, and then use the appropriate URL.Any suggestions?Here is the URL to Clock in (using the "now" rather than "now()" in the URL is nice because I can print it on paper and it is always gives the current time): var text redirect = "&apptoken=XXXXXXX&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl());URLRoot() & "db/br4vigw5t/(_DBID_TIMECARDS)?a=API_AddRecord&_fid_6=" & [Record ID#]&"&_fid_8=Now&am
I am wanting to create a text field that looks at multiple check boxes to see which ones are checked. Text box would read: "Improve Safety, Improve Quality, Improve Efficiency"------------------------------Sarah Burres------------------------------
Hi all... I was searching this morning on the internet for a "how to" on creating exception reporting in QB. I came across several posts on using custom rules to validate data during input/imports. I have a need to validate data that is currently in tables within the QB app that was developed. This app has been in existence for a few months and it looks like the data that has been added by users is not always correct. I'm trying to find a way to evaluate all the data in various tables and identify exceptions to business rules. Ideally I'd like to have a report that does this validation daily so that the data remains clean. Any thoughts on how this can be accomplished?------------------------------Marcia Miller------------------------------
Hi hi,I'm wondering if there's any way to increase the font size in graph chart reports (pie chart, bar chart, etc)? The native/default font is far too small; and while I have XL Docs (and they're great), creating custom one-off excel exports for every pie chart we need feels really excessive when all I'm after is a larger font.(and note - yes I can just "zoom in" and "screen capture" the bigger sizes, but that's not always workable, and the ratio of font size to chart size is still unreasonable)Any tips or tricks would be tremendously appreciated!Thank you!------------------------------Jennifer Juhasz------------------------------
I've made an Expiration date field a dynamic search, but the only years it lets me choose from is 2023 and 2024. Yes, there are dates in the field back to 2008------------------------------Greg Rosenbloom------------------------------
Hi, I have a duration formula to calculate the number of days from First Production Date to First Payment date but I would like it to show how many days have passed as well.how would I write that? ------------------------------Renee Hansen------------------------------
I'm sorry if this was posted already. I have 2 tables - Project & Timesheets. Each table has a job# that will be in both tables, but when this app was built, the job# isn't marked as unique (even though it is), but QB won't let me mark it unique. I have a lot of time entries that I want the hours on the project table. Is there a way to create a relationship to link them?This is the Timesheet table. "True Job Number" Is from the timesheets. Project - Job Number2 comes from the Project table. I changed Project-Job Number2 to a formula to match True Job Number, but not sure if that will do anything. I manually linked the top 2Any help would be appreciated------------------------------Darren Martin------------------------------
I have a Formula Text field that is a combination of an integer and a URL. Ultimately what I'd like is to just get the text as I am reusing that value elsewhere is our application and don't want a linked URL. However when I review the field value it clearly presents as a URL. Is there a type conversion or something I can do to remove the URL/linking behavior? Screenshot for reference: TIA!------------------------------Jeremy LahnersLeadBaller------------------------------
I have a multiple choice field that has the traffic light status for a project (green, yellow, red), and I would like to have the selection display a traffic light image. It doesn't look like I can customize the display because it is multiple choice. Can I get this all into one field? Or do I need to do a field that will read the status and then display the image?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.