Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have an out of office table. I need to check that new records don't overlap with existing records. Any way to do this natively?The most recent post on this I could find was from 2017, and it pointed to an AJAX solution, not a native one. ------------------------------Nathaniel Cahill------------------------------
Is it possible to run a formula query on a table in a different app? At present the tables are not related and I would prefer not to relate them if possible.------------------------------Matt Hardy------------------------------
I have a parent table "Controls" used for SOC 2 compliance. I have a child table "Evidences" listing all evidences that are used during audits, with a special numbering system. Each Control can have many Evidences used for that Control, and some Evidences are used across multiple Controls.My goal is to be able to assign 1 or more Evidences to each Control, and have the Evidence fields display in the parent Control record.I thought I could setup an embedded report within the Controls form where we can select Evidences to be listed within the embedded report in the Control, but I'm not finding any option to select from existing records in a child table. We don't need to add new Evidence records from within the Control from, we can do that directly in Evidences table.I would like to select each Evidence by its special number, and have the other evidence fields autopopulate into the embedded report.Is this possible and how would I do it? Thank you!Parent Control form:Child table:----------
I have a report that is formatted with line breaks and I need to export it to a txt file. I can not use a csv or tsv because it wraps each record in quotes. How can I export directly to a txt file?
I have a rich text field to display an alert icon based on whether a field is in 'Overdue' status. I'd like to hover over the alert and see a field's value so the user knows why the record is in alert status.I have seen a few similar posts on here but haven't found the right solution...any ideas? Thanks!------------------------------Data Collaborative------------------------------
Hi, Has anyone found a workaround if users are in a new Table Report and have the filter(not quick filter) on to be able to scroll to the right without reverting back the beginning of the report. QB has said to clear cache and incognito window, but that has never worked. Just wanted to be able to provide a solution to users if they use those filters versus quick filters?Thanks,Ryan------------------------------Ryan Locke------------------------------
Has anyone had success with using automations to copy data from one field to another within the same record? Is this function even possible within automations?ThanksSheila------------------------------Thanks,Sheila ------------------------------
I've got a URL formula field that needs to open a draft email with the names [Combined Text Email] and subject [Meeting Date] filled in. So far I've gotten the open email part but can't seem to get the rest right. Here is my formula: var text Email = "MailTo:" &([Combined Text Email]); var text Subject = &(ToText([Meeting Date])) &"?Subject=" & "($Subject)"; var text URL = "<a href='https://mail.google.com/mail/u/0/#inbox?compose=DfGhPkmsgkdqdlggxFvglVRkZfcTHWhDXKQCcvMpFWgcvJwfvqpmJnlSrZSPjWFGxGpXhLsdMmJvpJzlxmXGPBWlJlWPCkgbXhKxmtsCqdDmhmTpzpjtsxxB'>Email Contacts</a>"; $URL & "&rdr=" & URLEncode($Subject) & URLEncode($Email)------------------------------Bethany Hudson------------------------------
If I want the following to happen:Record A is modified, then modify Record B.Record A is deleted, then delete record B.Will this have to be done in 2 pipelines, or any way to do it in one?------------------------------Mike Tamoush------------------------------
Hello, I understand reminders are not able to be sent to email field recipients but only User or List-User field recipients. I need the ability to send a reminder to a non-user and wonder if there is any work around for this? I have a public form that people sign up for a service and would like to send out a reminder a set number of days before a date field value. This only occurs once the service request was fully approved so it would only go to approved recipients. Do we see this capability added or a modified method of doing this happening in the near future? Since the email field recipient can receive notifications I know I could send a reminder to myself which could require triggering a field to send such an email but I'm trying to minimize touch on an approved entry.------------------------------Greg Hancock------------------------------
Do Pipelines trigger from Grid Edit? I have a pipeline that when a check box is checked it should trigger a pipeline. I have tried triggering this from clicking Save and clicking Apply Changes, but neither seem to trigger. Any thoughts?------------------------------Laura Linssenllinssen@jjkeller.com------------------------------
Is there a way to send multiple attachments from QB at 1 time without them in a table format? We have Juiced techs QB courier, and are able to send single attachments as PDF's, but I cannot seem to figure out if I can set it up for multiple attachments via Courier. I need to be able to select several PDF's from one account and email them together....just wondering if anyone has a simple solution rather than spending a ton of money on yet another add-on.....------------------------------Kelly Lyons------------------------------
I have an App where we are importing standardized data from another source regularly and I have 3 parent tables where the key field is a text field that matches fields in the child table. I am trying to streamline where the User just has import a spreadsheet once and it will look to see if the values in the 3 fields match the key fields are in the Parent table and if not create a Parent Record and since they Key field is that text field they will link if there is a matching Parent Record. The imports will always have values so it will never have an issue where there isn't a value specified for either 3 of those fields. I created a Pipeline in the child table triggered whenever records are added, I added a query to step A where in my child table I added lookup fields for the actual Record ID numbers for all 3 fields from the parent tables and set the query to be triggered when records are added and the Record ID is not set, because the actual key field is that text field that already ha
In a Summary Report, I am trying to make the 'Report formula' columns display with a comma added every three digits. ex: $1,234,321.00 instead of $1234321.00The 'Report formula' is summarizing a Numeric - currency field as Formula - Numeric. The Numeric - currency field's properties is formatted to include these commas. The commas appear when I look at an individual record. But the 'Report formula' column does not display them on the Summary Report.I have tried: ToFormattedText([Number - currency field], "comma_dot") but it receives an "expecting number" error. If add ToNumber at the beginning of that formula, it displays the value without the commas. Changing the 'Report formula' to a Formula - Text means I can't summarize the total. I can only count distinct values.Any ideas as to how I can add the commas?#Formulasandfunctions#reportsandcharts------------------------------Stephen Jackson------------------------------
I have a child table that contains a user-list field. I want to summarize the user selected from the user-list field in the parent table. I tried things that normally worked with standard user fields and it didn't work. How can i create the summary so it appears as a user in the parent table?------------------------------MICHAEL SARGENT------------------------------
I have a button that sits on a report that is on a user page that creates pop up to a special form that also has a button that that acts on a checkbox and then refreshes the page.Here is my formula that sits on the pop up form:var text Update = URLRoot() &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_1046=1";var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();If([Ready for Dispositions]=false,$Update& "&rdr=" & URLEncode($RefreshPage))What do I need to add to my formula to close the pop up after the button is clicked?------------------------------George Bramhall------------------------------
Trying to search for records which match a specific date pulled from a previous step (a).The below advance query is not finding any records.help{6.EX.'a.research_week_date'}------------------------------George Romanowski------------------------------
Hi! In the Multiple Record Version for notifications, is there an HTML way to embed a QB (Quickbase) Report? And if not a QB Report than a button that opens a report? The report would need to be one that leads to just the records that were changed. Thanks! Renee------------------------------Renee Hansen------------------------------
HiHas anyone experienced this weird phenomenon of the "next" and "previous" working in the opposite direction? I have a report and I'm clicking through records in edit view to add data. When I click 'Save and next' instead of moving to the next record on the list, it moves backwards to the previous record. If I click "Previous" it moves forward. It is very annoying since every time I update a record and click "Save and next" I have to then click "previous" twice to get to the next record. It is a large report (8000+ records) and I'm clicking through records on page 6 of the report. It happened yesterday and is happening again today with the same report. Maybe QB just doesn't like to handle so many records. It's just weird and concerns me.------------------------------Kim G------------------------------
Ok so I am confused on moving files to Box.com We are moving files fine to it. But our Quickbase is filling up its 10gig file attachment space like every few days.So, I could just delete the photos from Quickbase as its in box so what. BUT how can i make a link to the box.com folder in the record so its easy to go to the related photos. If that makes sense. everything I try doesn't seem to work.------------------------------Ali Mohsenian------------------------------
Hello,Does anyone have any videos, or training on how to customize the Action Link Template in the "Multiple Record Version" in the Email Notifications?------------------------------Renee Hansen------------------------------
I need to calculate hours that are considered OT or Premium vs Standard Hours based on a end-user in and out time.I am asking the end-user to enter their in and out time as part of the form. If the in time is before 7 AM EST then those hours from the designated start to 7 AM would be Premium. In the reverse any time worked past 5 PM would be premium. Example: In Time: 6 AMOut Time: 6 PMRegular Hours: 10Premium Hours: 2How do I make these calculations?------------------------------Joshua Case------------------------------
The reference field in my child table should populate with the parent table key field, but instead its pulling in data from a different random field from the parent table form.Parent table has a form to log corporate threats/risks. Within each threat record, is an embedded report of incidents (from child table) with ability to add incidents. Each threat can have multiple incidents. Related Threat field (reference field) in child table should populate with Record ID# from parent record, but instead is populating with value from Responsible Department field in parent table.Setup is below. Any help greatly appreciated. NOTE: I'm a Quickbase newbie and have no programming experience. Thank you!child report within parent record:Add new child record:From parent record:Report field settings within parent table:Related threat field settings in child table:------------------------------Diane Sinawi------------------------------
Hello everyone,I am trying to make an API Call that, when triggered, will add an apartment record with the same values of the current one with the sole difference of the Monthly Rent be negative - for example.You guys can help me to discover what i have been doing wrong?Example:API_AddRecord<qdbapi><usertoken>######</usertoken><field fid="6">[Unit #]</field><field fid="9">[# of Bathrooms]</field><field fid="10">[Monthly Rent]*-1</field></qdbapi>------------------------------Pedro Sampaio------------------------------
Trying to create a multi select drop down html to use in a form. I did the wizard which created this: <tr><td class=m>Impact</td> <td class=m><select name=_fid_214 ><option>Improve Safety</option> <option>Improve Quality</option> <option>Improve Efficiency/ Reduce LH</option> <option>Reduce Maintenance and Repair Cost</option> <option>Reduce Scrap or Material Cost</option> <option>Promotes Environmental, Social, Governance (ESG)</option> <option>Less Physically Demanding</option> <option>Other</option> This only allows the user to select one and they need to be allowed to select multiple. Help!------------------------------Sarah Burres------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.