Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a mailto: button in formula-rich text code that works fine and will launch and populate an email with text and fields from QB. It works fine, but it takes the user away from the original form with the button. I want it to open in a new browser window WITHOUT having to right click and select "open in new window."Is that possible?------------------------------Jeff Elliott------------------------------
We merged with a company that has a legacy application on a local physical server that has a MS SQL backend and an Access frontend. Does anyone know a third-party company that works on migrating these sorts of applications to QB? I see some services that move Access to QB (Juiced being one), but I am not sure what extra wrinkles are added with the MS SQL backend. Thanks. Ben------------------------------Ben Gillihan------------------------------
Something bad has happened in my Qbase.Duplicate records have been created! I have been messing around with pipelines which could have caused this problem.What is the best way to find duplicates in my [JOB NUMBER] field in my JOBS table?I can then go to the report and delete duplicates.thank you------------------------------BuildPro------------------------------
ScenarioOrig Date (date type) = 1/1/2022Moved to Date (date type) = 2/1/2022Current Date (Formula - date type) = BlankI need help writing out the formula for [Current Date] to reflect - IF [Moved to Date] Is Null then show [Orig Date] but If [Moved to Date] shows any date, reflect that date in [Current Date]. Hopefully this makes sense!Cheers,------------------------------Jeffery Torres------------------------------
Hello, I setup the connection correctly and don't have issues with a lot of other tables. However, certain tables I'm trying to setup as a connected table from another app is giving me the issue below when selecting the table and trying loading to the "Select Fields":Reading the QuickBase API_GetSchema response from https://h2oinnovation.quickbase.com/db/bg7ijapzy?act=API_GetSchema failed.XMLStreamException: ParseError at [row,col]:[65,24]Message: Invalid byte 1 of 1-byte UTF-8 sequence.I'm aware that the issues is due to special characters not being recognized, but after running the Mixed Encoding Scanner, it's showing me that there are 15,771 errors! The majority are simple apostrophes that were not showing as the mini diamond with a question mark like they are now. I know that the UTF-8 setting is supposed to be prevent this, but it's been on from the beginning (still is) and I'm still having the character's showing as unrecognized. So even if I did fix the existing e
Hi there,I am working on to automate the BOM's selection process by specifying the logics. I have tables with different equipment info and when someone place a request with input data to collect equipment the logic behind it should generate the template of equipment related and should export an excel file.How can we automate to export the excel file using pipelines any suggestions?Thanks,Ravi J------------------------------ravi kiran jaladi------------------------------
Setting the sceneI have Regions that have Locations that have Machines that have Tickets. I have cascading permissions set up so that depending on the region the user can see only his/her respective Locations/Machines/Tickets based on a User Permissions table setup. Using the Current User is person fields.Now for the problem.I have Managers who need to see certain tickets. Example: Only see their Teams Tickets or or only see the tickets that are assigned to people they manage (I have a manager field on the user table that specifies a users manager- but i cant get that info to the ticket). But the tickets are not assigned to a team. The tickets are assigned to an employee using a User field. How can I have that User Field determine a Team and then filter based on the Current User is 1 that Im already familiar with. I dont know how to get any user based information to the ticket because im not relating the ticket to the assigned employee, Im just choos
Hello, I have two tables [Client & Files] connected and I'm wondering if there's a way to check the Files table if certain "File Type" has been uploaded for that specific Client. For example, the Client record has a status field that can only be set to "Complete" if a "Profile Picture" has been uploaded. Thanks in advance!------------------------------frnmj------------------------------
I'm trying to get a field from one table to show up on a form from another table. I set up the relationship but it must not be right. The wording for the field shows up but not the content of the field.I want the Manager to show up in the Contacts Table. The Manager is entered in the Client Services Table.I made a table to table relationship with Client Services to ContactsSo i can get the Manager to show up in the fields to choose but nothing populates in it.So I can't figure out how to get this to populate. Thanks for any help.
hi,I inserted checkboxes into a form that are required fields. The user will be asked to select one or more of the checkboxes. I created a rule to have these checkbox fields become unrequired as soon as a box is checked (see rule below). When I try to save and close the form I receive the error message below. Can someone please help in trouble shooting this error? Is the 'required' field condition causing this error?Checkbox Fields:Form Error:Dynamic Form Rule:thank you,Sangeeta------------------------------Sangeeta Ram------------------------------
I feel like this should be easy but I'm drawing a blank. I have a situation where, when a child record (media) gets created via button, the user has to save the record after making their changes, then edit it again to update 1 last field. This is because that last field needs to be populated with a location path that contains the record ID of the child media record, which doesn't exist yet when they click the button to add the media. So it just creates a few extra clicks that shouldn't really be necessary. So I'm trying to tweak the button to create the media from the parent (request), then edit that same media record by populating a text field with "some string" & the newly created RID for this child media record. Lastly, after adding & editing the record, I'll have it redirect to the edit form of the media so the user can make their edits as necessary.------------------------------Harrison Smith------------------------------
I have a formula field that concatenates a few different fields into 1 value, one of which is the record ID. That's working fine. But when I try to set the "must be unique" checkbox on the formula text field I get the following error:You cannot create a field that references the Record ID field and that requires unique values. Please change your formula to not reference the Record ID field or uncheck the unique checkbox.My question is... why? A record ID by definition is unique, so why can't I require a formula field that includes the Record ID to be unique? The logic seems faulty to me, but I assume there's a good reason for it. And is there a way around this, perhaps with custom data rules? ------------------------------Harrison Smith------------------------------
Hello, I would like to set an "active" status on a record using a checkbox field. I only want a single record in the table to be active. Does anyone know how to do this? I'd like to create a new record, set the checkbox, and have any previous record be unset. Or at least throw a warning when the checkbox is set that there is another "active" record already.------------------------------Mike Brady------------------------------
I've been exploring the NIST Privacy Framework Manager app from the sample apps library. It is excellent, except it requires downloading three import files before deleting the sample data so you can recreate the NIST functions, categories, and subcategories. Unfortunately, these files do not seem to copy over. When I click on the links to download them, I get the following error message: 404 error File metadata not found Check the Quickbase service page for more information. Please contact support if you need help. Same error with images used in some of the reporting. Is it expected behavior for attachments to not copy over when you use "get this app" from the sample-apps library? Would anyone have copies of the CSV import files that are supposed to be used with this sample app?
We are trying to build a method by which a user can click the edit button on any record in a certain table and be redirected to a form that is set by a formula.So far we have built in the default form for that table an iframe which links to a code page in which there is javascript that opens a link to the form that is set by the formula field in a new tab and closes the previous tab. Unfortunately once the user gets to the form and tries to save the form, it gets stuck on the saving screen.Any idea what is causing it to get stuck on the save screen?------------------------------Justin Ferris------------------------------
I have a report that needs to show the following: [Strategy Code] [Project Title] [Activities]There are different [Project Type]s, so it includes certain project titles more than once with the related activities for that type. Is there a way to show just one project name and combine the related activities to that one field?------------------------------Bethany Hudson------------------------------
Hello,I need to create a copy field to copy a job record (called template - JOB NUMBER= TPL.0000) to create a "new" job (record) with new job number=1234.KBThe original job record MUST stay as JOB NUMBER=TPL.0000Please advise------------------------------BuildPro------------------------------
I want all my records to be on one page. It'll make life easier when scrolling through all the information.
I have a app that shows who the current user is based on a State selected.In order to make sure I record the correct user at the time the record is created. I have created another field let's say user at time of creation. When a new record is created I want the user in the user field to update the user in the user at time of creation field.I put a form rule that says if User at time of creation is null, update user at time of creation with user in user field. However it is not working.Any ideas?------------------------------Carol Mcconnell------------------------------
I have the following many-to-many scenario: an event can have multiple participants and a participant can have many events.I set up three tables:1. Participants2. Events3. Participant-Event Join1 and 2 each have a one to many relationship with 3. I have another tables for Requests. I need to be able to select multiple participants on the request form and have certain fields from the participants table displayed in an embedded report on the Request form.I also want to display all events a participant has participated in on the participant form and all participants who participated in an event on the event form. How do I go about doing this? Do I need to add a one to many relation ship between the Requests table and the Join table? E.g. have the join table join three other tables?------------------------------Paul EASTON------------------------------
Looking for a formula of some sort that calculates an age if it falls within a range - for a pie chart. I dont want all of the ages to be displayed in the pie but something like 20-30, 31-41, 42-50, 51-60, 61 and over------------------------------Ermias Bean------------------------------
App A has a join table field for projects and organizations to allow multiple organizations to be added in an embedded form within App A. In each each join table in each AppProject Field: Relates back to the "projects" table in the respective appOrganization Field: App A (source of truth), App B - uses a connected table from App AWould like App B to use populate the field correctly when its information is imported to App A in a daily automation. Projects from App B are imported over to App A daily - should I create a relationship in App B to the the project table in App A or use the one in App B. The related project needs to match up in both Apps to make the import process work?------------------------------Lashell Thomas------------------------------
Was really hoping to find a list of all URL actions. Stuff like "?a=er&rid=" or "?a=er&dfid=XX&rid=".Anyone found a list?------------------------------John Ross------------------------------
Hello,I have over 30 reports that need a certain filter added to each report. Is there an easy way to do this vs. manually entering filter in each report?thank you------------------------------BuildPro------------------------------
Is there a global or app setting to open all links in a new tab or window? When clicking on a link in a Text-Multi-Line field, the link opens in the same page resulting in navigating away from the original record. Is there a workaround for this? I feel like there should be a global setting to control this behavior.------------------------------Paymon Eskandanian------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.