ContributionsMost RecentMost LikesSolutionsRe: Search widget resultsThat did the trick! Thanks ------------------------------ Audrey ------------------------------ Search widget resultsHello, I have a search widget on my dashboard & search columns set up, which is all fine. The results show unhelpful fields; I want to choose which fields are shown in the search results. Is there any way to customize which columns the results show? Thank you. ------------------------------ Audrey ------------------------------ Re: Date Field formatHello, Thank you for the solution above. Is there a way to do this without dropping leading zeroes for single digit months and days of the month? ------------------------------ Audrey ------------------------------ Populating a formula checkbox field based on value in duration fieldnever mind - figured it out ------------------------------ Audrey ------------------------------Re: Duration fields/automationsRecords that have a result of 0 or less than 0 are automatic fails and I don't need the team to review. I just want to automate a process to auto fail them, which requires changing several fields. I don't want to flag them for review; that is a separate scenario. Both scenarios have the same problem, in that automations can't be done based on formula fields. ------------------------------ Audrey ------------------------------ Re: Duration fields/automationsreposting separately ------------------------------ Audrey ------------------------------ Re: Duration fields/automationsFormula fields of any type, including formula checkboxes, do not appear in the drop down options for automations. The reasons to flag something for review are many--over 20 today and growing. I just gave a few examples here. Automations appear to be the simplest means to flag them. The formula would be so complex and have many nested rules, which I would need to change at least twice a year, that it sounds like it would not be simpler than having automations do it. ------------------------------ Audrey ------------------------------ Duration fields/automationsI am requesting ideas on how to flag certain entries that have obvious or possible errors. I am trying to base this on a duration field and have tried many workarounds. The field is "age on date of service". -If it's less than 0 I'd like to create an automation to change another field in the same table to a noncompliant status. -If it's outside other age parameters, I'd like to create an automation to change other fields to flag the entry for review. I can't do automations on duration fields. I tried building a formula field to copy the duration field's value, but this is not allowed. I can't do these operations on the data entry form because I'm maxed out on derived fields. When I try to do a QuickBase action instead of automation, the option for modifying a record is greyed out no matter what I do/do not enter into the action's fields. I tried to build a report and highlight the out-of-range values on it, but you can't highlight based on formula fields. Thank you. ------------------------------ Audrey ------------------------------ Re: Using \ in formula text field Thank you, Austin K! Sometimes it's the simplest things :) ------------------------------ Audrey ------------------------------ Using \ in formula text fieldHi, I am trying to find out how to use \ in a formula text field. My current formula is: "G:\SharedDrive\folder"&[File Name]&"" I get an error message stating the \ needs to be enclosed in quotes like this: '\'. I do that and the field only returns '' without the \. Thanks ------------------------------ Audrey ------------------------------