ContributionsMost RecentMost LikesSolutionsRe: Creation of new QB Actions and Webhooks will be locked as of June 30, 2024 Will there be a migration tool provided like Automations migration to Pipelines? Quickbase Developer Opportunity SGS Position announcement We are hiring a person with significant QuickBase experience as an Environmental Protection Specialist at the DC Government Department of Energy and Environment. This position is full-time with benefits, based in DC, has the option to work remotely 2 days per week (with lots of flexibility), and the salary range is $85-$109K. Work with the Green Infrastructure Incentives and Assessment Branch (GIIAB) to develop and refine QuickBase features in the agency's Surface and Groundwater System (SGS), https://doee.dc.gov/sgs, supporting stormwater, watershed protection, and water quality programs. Key responsibilities: 1. Develop new QuickBase applications and enhancements to existing applications. 2. Analyze program objectives to recommend system design to improve program operations. 3. Work with program staff to identify and draft development requirements. 4. Write complex formulas in QuickBase, Excel, or other data management systems. 5. Test and troubleshoot new features. 6. Design and run complex reports that draw information from related applications. 7. Troubleshoot and resolve internal and external help requests. 8. Draft system documentation and user guides. 9. Provide training for applications and procedures. While we are looking for someone who is already experienced with QuickBase, we are happy to help them learn about the environmental programs we work on. Experience with HTML, JavaScript, and APIs is a plus! We hope to find someone who is interested in protecting the environment and is excited to help us engage with program staff and users to continually improve and evolve our system. You must submit your application at careers.dc.gov by July 29, 2022. Select "View All Jobs" and search for 17865 (the job ID). If you have questions, please contact sherry.schwechten@dc.gov. Re: Formula checkbox from report filters Mark, All is good. Thanks for your help! Brian Re: Formula checkbox from report filters Mark, Here is a sample of reconciled records that formula is not filtering out. Appears that the formula is having a difficult time processing dates inthese lines: If([RiverSmart Homes] and (IsNull([Audit Date]) or [Audit Date] < [Date re-audit requested]) and not [Test account] and [Site Owner - Public User] and (not [RSR auto-enroll] or [RSR Auto-Enroll Application Date] < [Date re-audit requested]) and ([Remove from waitlist]=0 or not IsNull([Date re-audit requested])) and (not [RSH Import] or not IsNull([Date re-audit requested])),true,false) Re: Formula checkbox from report filters Mark, My difference in filtering the formula in a test reportis 45 records more than the report with the filter sample provided. This result is a whole lot better than I was ever able to generate. I am going to do some data reconciliation and find the differences. Here's the code. If you see something, let me know. If([RiverSmart Homes] and (IsNull([Audit Date]) or [Audit Date] < [Date re-audit requested]) and not [Test account] and [Site Owner - Public User] and (not [RSR auto-enroll] or [RSR Auto-Enroll Application Date] < [Date re-audit requested]) and ([Remove from waitlist]=0 or not IsNull([Date re-audit requested])) and (not [RSH Import] or not IsNull([Date re-audit requested])),true,false) On a personal note, I have been an independentQB developerfor about 17 years now. I can't tell you the number of times you have saved my bacon and provided guidance with your solutions to QB Community posts. Just want to say thank you. Brian Formula checkbox from report filters Thank you all for considering my post. I am trying to create a checkbox formula that mirrors this set of report filters: I am having a Dickens of a time to get the same results as the report displays. Create a new report where [Formula Checkbox] = true and delivers the same results as these filters. I need to pass the Formula check box back to other table(s). Many thanks. Re: Duration with stop points Katie, Here is one approach It seems you want to be able to do something with the duration(days) when the service goes ON HOLD to when they come off ON HOLD. Must be that you do NOT want to include those days in the ultimate calculation of how long it took to complete Stage 4? If so, then try this... Create a new Child Relationship to this table. Call it [Stage 4 Pause Records] ADD these fields to your table: Date Field – [ON HOLD DATE] Date Field – [OFF HOLD DATE] Formula Date Field - Value is Today() Formula Duration Field – [Running Count] in [Days] (Today() - [ON HOLD DATE]) Formula Duration Field – [ON_OFF HOLD] in [Days] ([OFF HOLD DATE] - [ON HOLD DATE]) Formula Duration Field – [ACTUAL DAYS] in [Days] If IsNull([ON_OFF HOLD], [Running Count], [ON_OFF HOLD] This is the field that you will summarize back to the Parent Record Leave your current Parent table Duration Formula in place. I assume it just goes from Stage 4 create trigger to Stage 4 complete trigger. All the days. ADD these fields to your table: Formula Date Field - Value is Today() Date Field – [ON HOLD DATE] Date Field – [OFF HOLD DATE] Report Link Field – [Record ID#] to [Record ID#] to the same table. (For use in ACTIONS) [Summary Field - # of Actual Days] from new Relationship Formula Duration Field – [STAGE 4 DURATION DAYS] in [Days] [Your Current Stage Duration field] - [Summary Field - # of Actual Days] This gives you the number of Stage 4 days excluding those days ON HOLD. You will need Parent Record triggers to automatically update the [ON HOLD DATE] and [OFF HOLD DATE]. The update to these fields will be to copy the value in the [Today()] field into these values based upon the triggers you set or currently have in place. Stage 4 goes "ON HOLD" copy Today() to [ON HOLD DATE] Stage 4 goes "OFF HOLD" copy Today() to [OFF HOLD DATE] These will trigger the Actions / Automations below Create Actions or Automations to do the following with triggers from Parent Record) When [ON HOLD DATE] changes ADD a record to the [Stage 4 Pause Records] Import [Record ID#] to [Related Parent] Import [ON HOLD DATE] When [OFF HOLD DATE] changes EDIT the Related [Stage 4 Pause Records] record. Change the value in [Stage 4 Pause Records] [OFF HOLD DATE] field to the value from your [Parent Table] [OFF HOLD DATE] field Updating the [OFF HOLD DATE] essentially closes this record. If the Stage 4 process needs to go ON HOLD again, you change the [ON HOLD Date] and new Child Record is created, and the process starts all over again. The [Summary Field - # of Actual Days] will keep track of all the starts and stops and keep the Formula Duration Field – [STAGE 4 DURATION DAYS] in [Days] always accurate. ------------------------------ Brian Cameron ------------------------------ Re: Access to older Community PostsThanks, Austin...I can use this as a work around until they fix the issue. Much appreciated! ------------------------------ Brian Cameron ------------------------------ Re: Access to older Community PostsThis is the error message: ------------------------------ Brian Cameron ------------------------------ Access to older Community PostsIs anyone else getting system error messages when trying to open up older posts? I was looking at one from 2017 and when I clicked on the post I got "Sorry...some thing is wrong followed by a very long error code "that has been logged". Are older posts archived and no longer available? ------------------------------ Brian Cameron ------------------------------