TroyMacPherson
Qrew Cadet
Joined 5 years ago
User Profile
User Widgets
Contributions
Formula help - calculating duration between dates in separate rows of data
Hello, looking for help on the following problem. I have a child table tracking step changes to a parent record. Each Step change has a From Step, To Step and Step Date: Record ID ID Number From Step To Step Step Date 1 1001 Initial Secondary 1/1/2024 2 1001 Secondary Tertiary 1/3/2024 3 1002 Initial Secondary 1/15/2024 4 1002 Secondary Tertiary 1/17/2024 I am trying to calculate the time between steps by ID Number. I think I need some way to pull the Step date of the previous record related to the ID number into the prior row to run the duration calculation, but I'm not sure how best to do this. When its the last step related to the ID number, this value can be today(). Here is what I think I need a calculation to do: Record ID ID Number From Step To Step Step Date Step End Date 1 1001 Initial Secondary 1/1/2024 1/3/2024 2 1001 Secondary Tertiary 1/3/2024 Today 3 1002 Initial Secondary 1/15/2024 1/17/2024 4 1002 Secondary Tertiary 1/17/2024 Today Any suggestions would be appreciated!100Views0likes3CommentsRecords created in the last 24 hours
I'm trying to find the number of records created in the last 24 hours using the following code, but getting a type mismatch error, any advice? Count(If([Date Created] > ToTimestamp(ToDate(Today()) - 1), 1, null)) ------------------------------ Troy MacPherson ------------------------------Solved37Views0likes3CommentsKanban Filtering
Is there a way to show a Kanban Report on a Form that is filtered by the current record on the form? I am hoping to allow users to move the card to change the status of the record as opposed to using the drop down. Having a hard time just displaying the related record and It's got me scratching my head what I am doing wrong. ------------------------------ Troy MacPherson ------------------------------14Views0likes2CommentsUsing Pipelines to generate a Historical Status table with a start and end date/time for status changes
Hi, I'm struggling with something - hoping for some guidance. I have a parent table with a Status field (New, Pending, Closed). When the record is created, a pipeline triggers to capture the Status, and the Date/Time in a realted Child Table. I am capturing every status change in the same way so I have a history. In the Child Table I'd like to calculate how long each step takes. I have the Step Date/Time as a starting value, but how can I capture the End Step Date/Time? This would be the same value as the following record's Step Date/Time, but I'm not sure how to get that value into the previous record. Any suggestions? ------------------------------ Troy MacPherson ------------------------------27Views0likes2CommentsRe: Upload Multiple File Attachments to QuickBase
HI Bailey, if you go into the settings of your app, there is a Plugins section under Advanced Features. You will find the File Manager plugin there. Note, you will want to have your tables ready for this plugin including a Parent/Child relationship and the file attachment field in the child table. Good luck! ------------------------------ Troy MacPherson ------------------------------93Views0likes0Comments