TroyMacPherson
Qrew Cadet
Joined 4 years ago
User Profile
User Widgets
Contributions
Records 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 ------------------------------0Views0likes3CommentsKanban 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 ------------------------------0Views0likes2CommentsUsing 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 ------------------------------1View0likes2CommentsRe: 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 ------------------------------0Views0likes0Comments