ContributionsMost RecentMost LikesSolutionsFuture Date FormulaI am working on developing an automatic job scheduler for our operations team. In my app, I have two fields: [Most Recent Production Run Date] and [Recurrence] From these two fields, I need to be able to calculate the [Next Scheduled Production Run Date]. I have been able to figure out for monthly, weekly, annual jobs, but where I am struggling is on jobs that we run, for example, twice monthly... in these cases, for example, [Recurrence]="Mid-Month: 16th and 23rd". So, if the [Most Recent Production Run Date]=1/16/2021, then I would need the [Next Scheduled Production Run Date] to be 1/23/2021. If the [Most Recent Production Run Date]=1/23/2021, then I would need the [Next Scheduled Production Run Date] to be 2/16/2021. Any advice on how to build a formula to achieve this result? Thanks, Jen ------------------------------ Jennifer Miller ------------------------------ Automations: Not able to copy formula fieldRe: Best practices - combining two apps to one Thanks so much Mark! We are only at 49MB in one app (between 5 tables) and 39MB in the other app (between 2 tables) currently and will be working on a solution to archive old data on a regular basis, so I'm hopeful that space won't be an issue, but that is great to know �� Thank you, Jennifer Miller Best practices - combining two apps to oneLooking for advice on best practices. I currently have two related apps that, as they've evolved, I am thinking would make much more sense to be in one app... for better user experience, easier/cleaner reporting, and easier/cleaner API calls from/to external systems. My concern with doing this is the number of fields already on each table. By combining the tables in these apps, I would end up with over 750 fields on one table... should I be concerned with performance issues if I do this? We use these applications to drive our daily production operations so performance issues would be a huge concern. ------------------------------ Jennifer Miller ------------------------------