ContributionsMost RecentMost LikesSolutionsRe: Calculating number of days between two date fields Ok, I feel dumb... I swore I tried those very formulas and it didn't work, turns out it was because I accidently added one of the date fields as a text field and didn't realize it. Once I fixed that formula worked just fine, thanks! Calculating number of days between two date fields This is probably a super easy question but I am rusty and nothing I am trying is working and all the discussions I am finding are asking for more complicated formulas. I simply need to calculate the number of days between 2 date fields on a record? SolvedRe: Why Quickbase? Why? So I watched the training video and I see now how to put 2 fields side by side in the same column. I just wasn't positioning them right when I tried it before, didn't realize I needed to place them right on top of each other. But the other thing I didn't see on the training video either was the ability to make the field headings be to the side of the field instead of the on top of the field like we could before. I know before it was controlled at the section level but I didn't see that option before. Having the field names on top of each field causes the form to be stretched way longer than it would be otherwise. and fields that only need to be a few characters wide are now stretched the entire width of the column. Why Quickbase? Why? One of the few things I ever said that Quickbase lacked was design capabilites, particularly in form design, and when I saw that they were making changes to that I was pumped. Now that I have used it a bit, I am scratching my head... Although I do love some of the options they have added, why would you take away things like being able to have the field label on the side or on top? And the addition of columns was great! But why take way the ability to have a couple small fields still be able to be on the same line within those columns? I'm trying to mimic a form that is currently in Excel and the section that currently only occupies only about a 3rd of the page, a user will have to scroll down to finish entering all the info because of the spacing. Am I missing something or does forms design still need some work? Re: Trying to calculate On Time delivery No, no relationships as of yet. I did think about that but I am uploading data from a spreadsheet to fill these tables and I have always had a hard time linking parent and child records together after they have been created in any kind of mass update. But I know with relationships and being able to utilize summary fields would probably help. So far there are 6,108 shipment records. The company I am working for uses a platform called Odoo and it is terrible for doing reports and getting data out of it. As it is I have to export the data I am using and do several mods to it before I can even upload it into QBase. That being said I suppose I could just make getting the Max ship date for any Order #'s that have multiple shipments against them part of my prep routine for the spreadsheet before I upload it... Re: Trying to calculate On Time delivery Thanks Mark, this worked great! To dive into this further, the data I pulled was on a line by line basis where as a shipment may have multiple lines and each line could ship separately against the same due date. So there are instances where some lines on a shipment shipped on time but one not have made it out on time, which technically makes the overall shipment not on-time. When I was doing it on a spread sheet I would use a pivot table to group the shipment #'s and calculate on Ship Date looking for the Max Date. Can I do something similar in a summary report to get the On-time percentage at the overall Reference # level? Trying to calculate On Time delivery I have a table that holds shipment data, Ship to, Reference #, Due Date, Ship Date, and then a formula field that returns "Yes" if the the the Ship Date is less than or equal to the Due Date and "No" if not. I now want to show an over all Percentage of how often we are On Time. Any suggestions on how to set up a report that would portray this information? I was looking for a formula that would count how many records where the On Time field = Yes so that I could maybe summarize that. Any thought on how to set this up would be greatly appreciated. SolvedTransaction Log I have a client that is asking for a transaction log for the workflow I am building out showing the username, action taken, and date-time stamp for all decisions and other changes made as the workflow progress. They would like this log to be reportable and able to be queried. My first thought is to create a separate table for this and have a pipeline set up to capture this info in the new table, but I am wondering if there are other ways to do this? ------------------------------ Chris Swirtz ------------------------------ Re: Best way to restrict edit access to specific form sectionsJeff, Can you explain a bit further how to do that? When I try to set a form rule based on a status field and make the action "Make read-only" the sections and tabs are not available on the list. ------------------------------ Chris Swirtz ------------------------------ Best way to restrict edit access to specific form sectionsIn the App I am working on there are 3 tabbed sections that an outside user fills out and "submits". On a fourth "Internal" tab my clients have several steps that they take internally using the info filled out in the first 3 tabs. My client is asking that those first 3 tabs be locked for editing by internal users during certain points. I know I can lock edit access to the entire form easy enough, but to break it into parts, the only way that I know of would be to create a dynamic form rule listing what would be 100 fields in those first 3 tabs as read-only when in a certain status or when a certain user is working on it. Is there a better way to do this? ------------------------------ Chris Swirtz ------------------------------