ReneeHansen1
Qrew Cadet
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: List fields based on checkbox
Yes, the ultimate goal is to have ONLY THE YEARS FOR FUNDING listed if that ask year is checked. I put in that formula, but I'm getting an an error that says expecting text but found number. the "first year" et al fields are numeric. I tried wrapping in in To Text but that didn't work. should I change my year fields that are numeric to text just for this? i don't think it'll mess anything.Re: List fields based on checkbox
Hi - I still need help if anyone has the answer. Here's a better screenshot. The funding years are 2025, and 2026. I need a formula that reads "First year ask is Yes, return 2025 from the field [First Year], if "Second year ask is Yes, return 2026 from the [Second Year] field. My Numberic formula is only returning 2025, and my Text formula is returning all 5 years. Numeric Formula: var bool yone= [First Year Ask]=true; var bool ytwo= [First Year Ask]=true; var bool ythree= [First Year Ask]=true; var bool yfour= [First Year Ask]=true; var bool yfive= [First Year Ask]=true; If($yone,[Year 1], $ytwo,[Year 2], $ythree,[Year 3], $yfour,[Year 4], $yfive,[Year 5]) My Text formula: var bool yone= [First Year Ask]=true; var bool ytwo= [First Year Ask]=true; var bool ythree= [First Year Ask]=true; var bool yfour= [First Year Ask]=true; var bool yfive= [First Year Ask]=true; List(",",ToText([Year 1]),ToText([Year 2]),ToText([Year 3]),ToText([Year 4]),ToText([Year 5])) The only reason i have two is because I'm trying to figure out which is the right way. Thanks! ReneeFeature Request for QB
I requested a feature: Request | Feedback (quickbase.com) - here's the ticket if you'd like to thumbs up and follow. The request is to have an option to require a section in the new forms, instead of applying "required" to each field. If we can require the whole section, that might make things simple.Sort & Group separate from UI
Hi, There are a lot of instances where we need the users to be able to sort and group their reports, but we can't leave the report open for editing. I've opened a ticket to see if Quickbase can separate out the Sort & Group feature from the User Interface settings. If you're interested in this too - go "request actions" and subscribe to the ticket Sort & Group #409577 - this is a link to the feedback: Request | Feedback (quickbase.com)Re: Report Formula for Header fields
Hi Mark, I also am not great at explaining, so no worries, I appreciate any help you have. You're always so patient and helpful with everyone. let me give a better screenshot. I'm using a regular table report instead of a summary report because they need to see each record and it's data like this: Each business case will have a different set of 5 years they're working with, and that's based on the IC date. For instance this one - the IC date is in 2024. the first year is 2024, second third and so on you can see there. But another business case - such as this example - has it's first year in 2025. Would each business case need it's own report? Is there a way to do that with regular table reports?List fields based on checkbox
Hi, I need a formula field that will list some Years if the corresponding Year checkbox is checked. I'm not sure if this screenshot size is ok or not - it looks super tiny when pasting it. In the field "Funding Years", if the corresponding Year has a checkbox: First year Ask is checked, then List the First Year in the Funding Years. If ANY combination of those "Year ask" checkboxes are checked, then I want to list that Year in the "funding years". I've tried all the formulas I can try, I keep getting a mismatch of boolean and number errors, or all of the years populate. My formula right now is: var bool one = [First Year Ask] = true; var bool two = [Second Year Ask] = true; var bool three = [Third Year Ask] = true; var bool four = [Fourth Year Ask] = true; If( $one or $two or $three or $four, List(", ", ToText([Year 1]), ToText([Year 2]), ToText([Year 3]),ToText([Year 4]))) I tried putting "or" in there, but it doesn't seem to take it.
Groups
App Builder Qrew
Are you a builder? This Qrew is for you. Come discuss all topics builder focused here.Women's Qrew
For builders who identify as women to connect and learn from each other.
