JimHarrison
Qrew Champion
Joined 7 years ago
User Profile
User Widgets
Contributions
Clearing a merge field?
Wondering if anyone has ever cleared a merge field in a child table? Based upon reference below, we can UPSERT to a child table using a merge field as the surrogate key and the relationship is made (the related parent record id# values are filled in on the child record). Now I am trying to break the relationship so the related value is empty after upsert using the merge field. I have tried 0, "", nil, null and nothing happens. Any ideas are appreciated. Reference below: Link related data by importing into lookup fields Builders now have an easier way to import records with related data or link related data in integrations. Now, any lookup field marked unique on the parent table can be used to match instead of reference fields. RESTful Upsert Records—Users can UPSERT data to lookup fields marked unique in the data array in Record Upsert. https://helpv2.quickbase.com/hc/en-us/articles/31900230487700-Quickbase-November-2024-Release-NotesOctober 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, October, 22nd 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll talk about Empower Pro, current projects, new changes and challenges and what we are dressing as for Halloween. Anyone can show off work and cheer each other on. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation.September 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, September 24th, 3PM PST at Harder Mechanical Contractors and also on Teams. This month we will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation.Setting Default Report Row Colors based on Date Modified
I just spent several hours trying to come up with a creative solution to a problem. We want a record where the Date Modified is on or before a specific Date to have a different color, in this case grey. Easy we thought, this should work. - It doesn't. If(ToDate([Date Modified])=ToDate(6/22/21),"#666666","") Tried to add a formula check box field to get an idea what was happening. Check box field namd [Date Formula]: Part(ToText([Date Modified]),1, " ") this works when used in the color formula. Then in the Default report in the Color formula: - kinda seems to work but not really. If([Date Formula],"#666666","") Tried this one and no luck If(Part(ToText([Date Modified]),1, " ") < "06-22-23","#666666","") I asked ChatGPT and this came out: If([Date Modified] <= ToTimestamp(Date(2021, 6, 23)),true,false) So I was trying my best to convert Date Modified to a Date and failing. Instead by converting the static date I wanted to use as my filter to a Timestamp everything fell into place. Leaving this here because I couldn't find anything similar. Please let me know if there is a solution already in this forum and I will link it here.August 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, August 27th, 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned. We will also check in on moving Pipelines and setting up a separate Notification. Additional performance improvements will be shared. Finally a look at Grid Reports for those who don't have beta. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation.July 2025 Qrew Meetup Event
Portland Qrew is meeting Wednesday, July 23rd, at 3PM PST at Harder Mechanical Contractors and also on Teams. This month we'll look at DocGen lessons learned and alternative solutions. We will also check in on moving Pipelines and setting up a separate Notification. We will talk about current projects, new changes and challenges. Anyone can show off work and cheer each other on to higher heights. We ask attendees to bring problems to solve and then work together to provide a solution. Anyone willing to share is welcome to have a problem solved by a team of very nice people who all love helping. Afterwards I suspect we will go out somewhere and welcome recommendations. If you would like to join remotely email jharrison@harder.com directly and he will send you a Teams invitation. Near Laurel Hill, OR
Groups
Portland (OR) Qrew
Come meet up with members of the Portland, Oregon Qrew here!
