ContributionsMost RecentMost LikesSolutionsCreate a formula duration over 5 years Hello, I am trying to figure this out How to calculate a duration for each year based on a varying start date? The start date can be at any month of the year (just calculating months, not days) and the project will last over the next 5 years. Example: IF the Start date is September 2024, there's 4 full months for the first year. And if they're needed for ([Months Needed] is for 12 or 18 or 60 months, then how would I find the duration of the next year, and the next? Would each year need it's own duration field? Like Year 1 duration, Year 2 duration, etc? I'll have these fields [YEAR 1], [YEAR 2], [YEAR 3], [YEAR 4], [YEAR 5]. [Start Date] [Months Needed] Re: Pipeline to remove file attachments I had this problem with a build I did. I ended up using Sharepoint to store the file, that way we didn't use document space on Quickbase. Then I made a URL button to "view the document" so you could pull it up from sharepoint straight from QB. Re: An API(?) button to copy fields from the form, to other fields Thanks Mike! I'll give this a try! An API(?) button to copy fields from the form, to other fields Hi, so I am having the user choose what type of employee they need to hire. if they're hiring a contractor, they'll also have a choice to an a full time position to convert that contractor later in time. I'm thinking - if they want the contractor data (Department, Level, Role) the same for the Full time position - I'd like to to have them click a button "same for Full time position" that will push that data over to the new fields for the full time detail. This would all be on the same record and form. Thanks! SolvedFormula Help I need to calculate a couple of things for the cost of a resource The first year costs, but each "start date" is different. and the year end needs to be 12-31-[whatever year the start date year is]. I have requested start date, # of months they're needed. So for instance if a resource is requested to start on April 1, 2024, and they're needed for 60 months, and they're monthly costs are $1,000 What is the end date, if they start on April 1st and are needed for 60 days? What is the cost for that first year if they start on April 1st and go to the end of the year (of whatever their start year was) Thanks! I also need a formula for ------------------------------ Renee Hansen ------------------------------ Hide Tables, but keep view as "all records" I want to remove some tables from the menu bar at the top, because I want to force usage through one table. Is there a way to Hide the tables from the menu, but keep the visibility of the data for the user? ------------------------------ Renee Hansen ------------------------------ Embed a Report in Grid Edit Mode hi, I'm using the "new" form - I want to have an embedded report appear in Grid Edit mode, instead of the user clicking grid edit and the embedded report opens in a new window. Is there a way to do that? Thanks! Renee ------------------------------ Renee Hansen ------------------------------ Conditional & Cascading Drop Downs I don't know why this is so confusing to me but for now it is! In this help article: How to add Cascading Dropdowns – Quickbase Help You can add a 3rd conditional field. Can you add more than that? If i wanted to add a 4th or 5th? Is that possible in the same way you add the 3rd field or is it different? ------------------------------ Renee Hansen ------------------------------ Re: Field selections based on other fields I actually need to add a 4th layer to this. I have a connected table to all of the positions. I want the Positions narrowed down to what is available, based on the other choices they've made in Department, then Role, then Level. I'm not sure how I need to arrange those relationships. They'll be entering this on a "Main Table" or "project table" in that table they'll enter all the details and then start the selections. The objective the entire time is to find a position that matches the criteria (dept, role, level = positions available). ------------------------------ Renee Hansen ------------------------------ Re: Field selections based on other fields Thank You Both! I'm going to give that a try! ------------------------------ Renee Hansen ------------------------------