ContributionsMost RecentMost LikesSolutionsRe: Subscription Sending Summary report Hi Dan, I'm unable to replicate your experience. I just created two table report subscriptions (testing with List All) - one with the report in-line and the other as an attachment. Both came through as normal table reports. I would recommend opening up a care ticket so our lovely technical support team can assist you! ------------------------------ Chelsea Carpenter ------------------------------ Re: Dynamic Filter - Field Not Available Hey Adam, There is a table in the Help article "Using dynamic filters" called Quickbase field types used for dynamic filters. It includes columns for Reference and Lookup fields. If you see your field type with a Y in the Reference Field column, and it's not working, then please open a support ticket. ------------------------------ Chelsea Carpenter ------------------------------ Re: Duration Formula Hey Kirstynn! I'll provide some suggested formulas below, but first I'll just chat a bit about field options. Especially when we are new to formulas, we may feel inclined to put everything into separate fields. Whether we need separate fields or not depends a lot on what needs to happen based on the field's value. Some examples: - If human awareness and action need to be the result (no automations or notifications), you could potentially use one formula text field. - If you need to count separately the 4, 2, and 2 data, then you would likely need separate fields for each. Just some food for thought to think about how fields might be consolidated depending on the purpose they serve to your workflow. Now to the formulas! To calculate quantity of days between two date fields Field type: Formula - Duration Example field label: Days Between Formula: [Date 2] - [Date 1] >> Again, ask yourself/your stakeholders, do you need tosee this value, or can it be included as a piece of other formula fields. To calculate whether the quantity of days between two date fields is withinn days Field type: Formula - Checkbox Formula: If(ToDays([Days Between])>=4 and [Request Type] = "Supplier",true,false) >> This will return a checked box (true value) at or above 4 days between the two dates. Combined calculation in a checkbox field Field type: Formula - Checkbox Example field label: Send notification Formula: var Duration DaysBtwn = [Date 2] - [Date 1]; If($DaysBtwn >= 4 and [Request Type] = "Supplier", TRUE, $DaysBtwn >= 2 and [Request Type] = "Bidder", TRUE, ...) Combined calculation in a text field Field type: Formula - Text Example field label: Attention Formula: var Duration DaysBtwn = [Date 2] - [Date 1]; If($DaysBtwn >= 4 and [Request Type]= "Supplier", "NOTE TO END USER", $DaysBtwn >= 2 and [Request Type] = "Bidder", "NOTE TO END USER", ...) >> You could also get fun with this in a Formula - Rich Text to add colors and text formatting ------------------------------ Chelsea Carpenter ------------------------------ Re: Tab Behavior in Forms Hi Keith! I believe I can help you with this. The fix involves a bit of HTML to contain the tabbed areas, as well as section headings to provide a border of sorts. Since I don't know your exact form, I'm going to use a made up example to describe the solution. Let's say your form is on an Orders table. Tab 1 is Payment Details, Tab 2 is Item Details, and the section following Tab 2 is Customer Details. - Insert two elements above the Payment Details tab - Give the topmost element the following details: > Section Heading element > Set the field labels to be above fields - Give the second element the following properties: > Text element > Text = <table> > Check HTML (Limited) - Insert an element below the Payment Details tab - Give the element the following details: > Section Heading element > Set the field labels to be above fields - Insert an element directly above the Customer Details section heading - Give the element the following details: > Text element > Text = </table> > Check HTML (Limited) Just to note! New forms will not have this issue. Learn more about that forthcoming feature update here: - Future of Forms Empower 2022 presentation - New Forms Beta Community announcement ------------------------------ Chelsea Carpenter ------------------------------