Forum Widgets
Recent Discussions
Color Code Fields
I have looked everywhere and tried everything I can find but no luck. I want to background color a field if the values are the same. For instance, if a field for "Job 2345" has the number 523 in the ID field and "Job 1234" has the same 523 number in the ID field, color the background so they're identifiable. And hopefully grouped together so all jobs with field ID 523 can have the same crew assigned. Thoughts?
Using pipelines to log the date/time including the seconds of a record change
I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second. I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds. I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record. I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this. Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?
Text Field with Current Year
Hello, I'm trying to create a text field called "Reporting Year" where users can only enter numerical values for a year (i.e., 2023). Also, I need the field to be auto-populated with the current year (i.e., 2025); if the users wants to change this, they can do so. I haven't been able to completely figure this out on my own, so I appreciate any help on this. Thanks in advance!Creating a pie chart in a grandparent table
I’m in PR and we use QB for managing our media requests. If a reporter reaches out with an inquiry we log it in a media requests table. Media requests has a parent table of reporters (reporters can have multiple requests). Each reporter has a media outlet (think CNN or ABC News) parent (a media outlet can have many reporters. One of the things we track is the coverage of the media requests generates and score it with a multiple choice field on the media request entry (positive, negative, or neutral). So I have a pie chart that show the breakdown of the coverage with those options. I can pull that report into the reporter table on place it on the reporter form and it filters it down showing the score for that reporter across all their requests. What I want to do is pull that data into media outlets so I can see the score for that media outlet across all their reporters and the reporters requests. I want a similar pie chart on the media outlet form. What’s the best way to go about this?Enter the App Builders Qrew Raffle!
Ready for a chance to win and boost your Quickbase skills? The App Builder Qrew is hosting a raffle giveaway—simply download Mark Shnier’s app from the Quickbase Exchange and show proof (a screenshot or confirmation in the thread or email elavielle@quickbase.com) to be entered for a chance to win prizes. Link to the app in the exchange: https://www.quickbase.com/db/main?a=UniversalLink&entityId=qbredir&asset=user-focus-examples Mark’s app is a powerful tool that’s helped many builders streamline their workflows and solve real-world challenges. The raffle contest will be open until Tuesday April 22nd. Don’t miss out—download the app, share your proof in this thread, and enter the raffle today!
Help connecting Table to Table Relationships
Hi, I have 4 tables Site table - houses all site info including site ID# which is the unique identifier to be used to relate/connect all tables. Risk table - houses all the risks. 1 site can have many risks Milestone table - Each risk can have many milestones Site Risk Register - Joining table that has all the risks and milestones relating to each site on one table I'm struggling to figure out how to connect these tables. I figured all tables need to have that site id# field in order to connect. So I created a one to many relationship with the Site table and the other 3 tables so all 3 tables have a site id# lookup field. Then I created more relationships. One Site Risk Register has many Risks, One Site Risk register has many Milestones and then I also made One risk table has many milestones. I added dummy data in the tables but it is not reflecting in the Risk Register join table. Can I get help on what I did wrong and how to properly set up these table relationships
Document Generation - Filename
I started playing with the Document Generation in Quickbase this week which is amazing! I am curious to know if there is a way to set the filename of a Document that is generated in a custom email notification from a Quickbase application? I know that when you use the Generate Document code to create the document for a record in the application, it does allow you to set the title/name of the document specifically. However, using the same option as a part of the custom email notification sends the notification with the PDF attached and named Document 1, rather than any name you specify in the code that is attached the Formula URL field.
Copy Records pipeline, records are being skipped
Hi there! I am trying to turn away from using connected tables and into using pipelines to bring my data from one app to another. I am using the bulk copy records action in pipelines to do so! It is a super simple pipeline but whenever run it my table does not get update with the records. I do not receive any errors on the pipeline itself but the table remains empty.... Help! Thank you :)
