ContributionsMost RecentMost LikesSolutionsRe: January 2023 Quickbase Gantt Plugin - automatic table setup Anyone figured out how to have the current plugin setup and then build on top of it? I have added and configured the plugin to an existing app/tables, however was wondering if I could take it to the next level, which would be having multiple "projects" on the Gantt at once? ------------------------------ Ryan Whitener ------------------------------ Re: Downloading File Attachments with Mobile app.Any luck with this? ------------------------------ Ryan Whitener ------------------------------ Re: Calendar Report QuestionsAlex, did you end up embedding a form in a form? If so, how did it look? ------------------------------ Ryan Whitener ------------------------------ Many to Many Relationship to a Many Relationship?So I am not sure how to fully label the item I am working through, so I will do my best to describe it. I have a Jobs table (great grandparent) to a Packages table (grandparent) to a Breakers table (parent) to a Coordination (child). The particular case I am trying to wrap my head around is: Within the Package table, there is a field called "equipment type", one option is "panel" and another is a "transformer". Easy enough right, So now we have (2) records in the Package table. Well when "equipment type" is equal to "panel" a "breakers'" report table is accessible to that individual to begin listing the breakers within that panel. Still simple enough. Now we get complicated. I want to map out/describe where they breakers go. So I created this "Coordination" table and related it back to both the Package table AND the Breaker table. The reason being is I wanted to select a breaker and relate it to a separate piece of equipment. Example. (Package Table)Panel MP2 has a breaker named XXX (Breaker Table) which provides power to XFMR 2 (Package Table). Now writing it out, I am wonder if I over complicated it and should just have (2) relationships between the Package Table and Breaker Table. The only extra piece to that is having it filter based on the Related Job I would be working in. So I can't select a "Panel" from the wrong job. ------------------------------ Ryan Whitener ------------------------------ Re: Making a Rich Text Formula Field into a ButtonAwesome. Thank you Blake! Just what I was looking for. ------------------------------ Ryan Whitener ------------------------------ Making a Rich Text Formula Field into a ButtonI am not very fluent in coding, even at the basic level. I found on a different post the formula below for a "Save and Keep Working" field to appear in the middle of a form but can't figure out how to make it appear like a button. "<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</div>" A button similar to the "add record" buttons that are automatically created Thanks in advance! ------------------------------ Ryan Whitener ------------------------------ Making a Rich Text Formula Field into a ButtonI am not very fluent in coding, even at the basic level. I found on a different post the formula below for a "Save and Keep Working" field to appear in the middle of a form but can't figure out how to make it appear like a button. "<div style='Vibrant Success' onclick=$('#footerSaveAndKeepWorkingMenuOption').click();>Save and Keep Working</div>" A button similar to the "add record" buttons that are automatically created Thanks in advance! ------------------------------ Ryan Whitener ------------------------------ Formula Checkbox based on User Field PresentI am trying to write a formula checkbox formula that would be checked when a user field has a user listed. I tried a couple different formulas but couldn't get it to work. I think I am missing something.... [Employee-Previous Supervisor] is my user field 1st try-Case([Employee - Previous Supervisor],null,false,true) 2nd try- If([Employee - Previous Supervisor]<>null,false,true) What am I missing. Do I need to covert my user field to something else? Thanks, ------------------------------ Ryan Whitener ------------------------------ Formula Checkbox based on User Field PresentI am trying to write a formula checkbox formula that would be checked when a user field has a user listed. I tried a couple different formulas but couldn't get it to work. I think I am missing something.... [Employee-Previous Supervisor] is my user field 1st try-Case([Employee - Previous Supervisor],null,false,true) 2nd try- If([Employee - Previous Supervisor]<>null,false,true) What am I missing. Do I need to covert my user field to something else? Thanks, ------------------------------ Ryan Whitener ------------------------------ Re: If formula for multiple text choice fieldsJust finished it Thanks Evan and QB Coach.