ContributionsMost RecentMost LikesSolutionsRe: Dynamic form rules getting triggered by ImportThe problem turned out to be that the [Repair Check-in] field, as a date field, had the box "today's date as default" checked in the field properties. This meant that new records automatically got today's date added into this field, even during import. The fix was just to uncheck this box. Problem solved.Re: Dynamic form rules getting triggered by ImportI was thinking the same. I disabled the two automations but the problem persists. I'll open a ticket with Quickbase. Thanks for your help.Re: Dynamic form rules getting triggered by ImportThat's what I had thought, that imports should not trigger form rules. I have no Webhooks or Actions. I do have two Automations. One of them is set up to change a field called [Location Check-in] whenever the field [Location] is changed. This would include if [Location] was changed from "In Repair" to something else, which is also technically what the form rule is doing too in a very specific scenario. So there could be an overlap between the automation and form rule. However, the automation is only set up to fire if a record is modified, not when it's added. I just did a new import of data and neither of the automations fired, but the imports did get the [Repair Check-in] field modified. It's so weird.Dynamic form rules getting triggered by ImportI have a dynamic form rule that says "When the record is saved, and [Location] has been changed to "In Repair", change [Repair Check-in] to current date". This works as expected. If the [Location] field is changed to "In Repair" (and ONLY in this case), the current date is added to [Repair Check-in]. I have tested it and it works fine. However, I have come to find that using the Import function to add new records triggers this form rule regardless of what the value in [Location] is for the new imports. Even if new records are imported with [Location] being something other than "In Repair", the form rule triggers and adds the current date to [Repair Check-in]. It shouldn't be doing this. The rule should only trigger when [Location] is edited and changed specifically to "In Repair". Why is this happening? I can't figure it out.Rich Text Page formatting doesn't workUsing a Rich Text page I'm creating an app user guide. I'm using the tool bar to select font, font size, bold/italic - you know, the usual stuff. No problem. It looks good when I'm in the page editing it. When I save the page and then go to it via the link on my Home page, the page loads and a lot of those format changes I made don't appear. The font is clearly not Verdana (looks more like Times Roman), the section headings are not 18pt font... I don't know why the page I'm looking at when I edit it - and that I save - looks nothing like the page when it's actually viewed by the user. What's going on?Re: Use IF text lookup in a numeric formulaI figured it out. It's that "AND" is capitalized. I made them lowercase and now it lets me save the formula without errors. I had no idea that this could cause conflict. Good to know.Re: Use IF text lookup in a numeric formulaI noticed the trailing bracket too and removed it, I still get the same error. I copy/pasted your formula above just to be sure... I really don't know then why this formula won't work.Re: Use IF text lookup in a numeric formulaAfter the first AND in the second row QB says "expecting ," and that there are "extra characters beyond the end of the formula". I assume that means that it doesn't like the AND function and concluded it must be because [Priority] is Text in a Numeric formula.Use IF text lookup in a numeric formulaHi, I have a numeric formula that calculates the amount of hours that have passed if a date/time exceeds 24 hours. If([Delivery (hours)]>24,[Delivery (hours)]-24) I would like to add the condition that if the field [Priority] matches a certain text that it change the result. Something like this: If( [Priority]="Normal" AND[Delivery (hours)]>24,[Delivery (hours)]-24), [Priority]="Rush" AND[Delivery (hours)]>12,[Delivery (hours)]-12) However because I'm now calling on a Text field, QB complains about it because this is a Numeric formula. If I convert the formula to Text, now I can't calculate the numbers. Can anyone help me with a way to do this?Re: report totals not showing in Excel when saving as spreadsheetWhy 4 years later is this still not a feature? It seems like such a massive oversight. Half the point of summary reports is to break a grand total down into sub-categories but that doesn't mean that I don't still want to see the grand total when I export it to Excel. Having to do it manually seems unnecessary.