ContributionsMost RecentMost LikesSolutionsModify bulk records that meet criteriaI have a "Downtime Log" that contains records for equipment that is down. Records are created automatically at 15 minute intervals. If equipment is down for a day, 96 downtime logs are created (24 hrs x 4 records per hour). Users then edit downtime logs to enter a reason for downtime. I want to part-automate this process by giving users the ability update bulk records. I thought of creating a second table ("Downtime Automation") where users select the equipment, time period (start date/time -- end date/time), and downtime reason,and an automation applies the downtime reason to relevant downtime logs. But my automation is not finding all downtime logs within the specified time period. Users specifiy the time period using start date/time and end date/time, which are lookups of date/time field from parent downtime log (value conditional on logs for selected equipment). Is there a reason why I cannot use these time values to filter logs? Is there a better way to achieve my aim? Any help much appreciated. ------------------------------ Andrea Pahor ------------------------------ Re: Automation Missing FieldThis has happened to me. I closed and reopened the automation and the field appeared after a small lag. ------------------------------ Andrea Pahor ------------------------------ Re: How do I get a Formula Numeric filed to display null not 0?Thank you, Don. ------------------------------ Andrea Pahor ------------------------------ Re: How do I get a Formula Numeric filed to display null not 0?Thanks, Don - much appreciated. I omitted some key information: No of Technicians / No of Crew can be unspecified (TBD), in which case the formula should return null. For example, I want a result of null ifVehicle per technician = "Yes" andNo of Technicians = "TBD". How would I build this into your suggestion? ------------------------------ Andrea Pahor ------------------------------ How do I get a Formula Numeric filed to display null not 0?I need a formula numeric field (called No of Vehicles) to return null and not 0 when a condition is met: If ([No of Techs/Vehicle] = null, null) The full formula for this field (No of Vehicles) is: If ([No of Techs/Vehicle] = null, null, If ([Vehicle per technician] = "Yes", ToNumber([No of Technicians]), If ([Vehicle per crew] = "Yes", ToNumber([No of Crew]) )) Note: No of Techs/Vehicle is a formula numeric field Vehicle per technician is a text - multiple choice field Vehicle per crew is a text - multiple choice field Thanks in advance for any help! ------------------------------ Andrea Pahor ------------------------------Re: Slow Down the RefreshThank you, Chayce!Re: Slow Down the RefreshI hope to use this but am struggling with the syntax. I have a URL formula button that runs an automation. I hope to add the javascript described above. How would I combine these? URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Job ID#] & "&apptoken=myapptoken" & "&_fid_367=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Job ID#]) "javascript:" & "$.get('" & URLRoot() & "',setTimeout(function(){" & "location.reload(true);" & "},2000));" & "void(0);" Multiple if statements for date formulaI have service schedules in a scheduling table. Schedules - which are separate but related records - are based on frequency (monthly, 3-monthly, 6-monthly, yearly, 3-yearly, 5-yearly). When a higher service level is completed it means related lower service intervals have also been completed. I have a formula that does this ... That is, when a 5-yearly service is complete the yearly, 6-monthly, etc. schedules update to show they were also done on that date. What I need is a formula that will take the "date last service" and update the "date next service" so that related schedules should not be scheduled for the same date. For example, if a 5-yearly service was done on 1-Jan-2000 the "date next service" of the 5-yearly service is 1-Jan-2005. Yearly services will be scheduled for 1-Jan-2001, 1-Jan-2002, 1-Jan-2003, 1-Jan-2004 ... But a yearly service should not be scheduled for 1-Jan-2005 ... The formula below intends to identify whether these services fall on the same date and if so add one year so that the "date next service" becomes 1-Jan-2006. The formula appears to work but looks clunky. Is there a better way to write it? If ([Date Next Schedule (this schedule)] = [Date Next Schedule: Related 5-Yearly Service], If ([Frequency Unit] = "Year", (AdjustYear([Date Next Schedule: Related 5-Yearly Service],[Frequency No])), (AdjustMonth([Date Next Schedule: Related 5-Yearly Service],[Frequency No]))), //If date next schedule = date next schedule of related 5-yearly schedule //Then adjust date next schedule by the frequency of this service level //If frequency unit is year then adjust date next schedule by year x frequency //Iffrequency unit is not year(i.e. must be month) then adjust date next schedule by month x frequency If ([Date Next Schedule (this schedule)] = [Date Next Schedule: Related 3-Yearly Service], If ([Frequency Unit] = "Year", (AdjustYear([Date Next Schedule: Related 3-Yearly Service],[Frequency No])), (AdjustMonth([Date Next Schedule: Related 3-Yearly Service],[Frequency No]))), //If date next schedule = date next schedule of related 3-yearly schedule //Then adjust date next schedule by the frequency of this service level //Iffrequency unit is yearthen adjust date next schedule by year x frequency //Iffrequency unit is not year(i.e. must be month) then adjust date next schedule by month x frequency If ([Date Next Schedule (this schedule)] = [Date Next Schedule: Related Yearly Service], AdjustMonth([Date Next Schedule: Related Yearly Service],[Frequency No]), //If date next schedule = date next schedule of related yearly schedule //Then adjust date next schedule by the frequency of this service level If ([Date Next Schedule (this schedule)] = [Date Next Schedule: Related 6-Monthly Service], AdjustMonth([Date Next Schedule: Related 6-Monthly Service],[Frequency No]), //If date next schedule = date next schedule of related six-monthly schedule //Then adjust date next schedule by the frequency of this service level If ([Date Next Schedule (this schedule)] = [Date Next Schedule: Related 3-Monthly Service], AdjustMonth([Date Next Schedule: Related 3-Monthly Service],[Frequency No]), [Date Next Schedule (this schedule)])))))) //If date next schedule = date next schedule of related three-monthly schedule //Then adjust date next schedule by the frequency of this service level Remove default header from report?When printing a report, is it possible to remove the default header that shows the table name and report name (highlighted yellow in below image)? Re: Maximum number of fields you can display in a drop-down for a lookup field?What I meant to say is that I'm trying to display the 13 fields within a single record. You will see only 9 fields highlighted blue below. The lookup does display many records as you described.