ContributionsMost RecentMost LikesSolutionsRe: Combine two APIsThat did it! Thank you so much! ------------------------------ Trish Wehrle ------------------------------ Combine two APIsI have a button on a report in the Nonconformities table (that is the parent to workflow table) I'd like that button to change field 214 to 'extended' (field 214 is multiple choice) and then add a child record in Workflow table that updates field 6 & 8 on that child form with text but keeps the user in edit mode on the newly created child form am I close with this? I think changing 214 is working, but adding the child record is not. Thanks! URLRoot() & "db/"& Dbid() & "?a=API_EditRecord&rid="& [Record ID#] & "&_fid_214=Extended" & "&rdr=" & URLEncode(URLRoot() & "db/"& [_DBID_WORKFLOW] & "?a=API_AddRecord"& "&_fid_9=" & URLEncode ([Record ID#])& "&_fid_6=CAR Due Date Extension" & "&_fid_8=IEP CAR due date extended" & URLEncode("&rdr=" & URLEncode([Record ID#]))) ------------------------------ Trish Wehrle ------------------------------ Ampersand messing up formula/form ruleI think having an '&' in my field is messing things up. Help I have a formula text field 'Department Formula' that works great: If(Contains([Employee/Contractor - Department],"Inflight Services"),"Inflight", Contains([Employee/Contractor - Department],"Flight Operations"),"Flight Ops", Contains([Employee/Contractor - Department],"Ground Operations"),"Ground Ops", Contains([Employee/Contractor - Department],"Cargo"),"Cargo", Contains([Employee/Contractor - Department],"Customer Support & Services"),"CS&S", Contains([Employee/Contractor - Department],"Technical Operations"),"Tech Ops", Contains([Employee/Contractor - Department],"Network Operations Control"),"NOC","Other") And a multiple choice field 'Department' with these options: Inflight Flight Ops Ground Ops Cargo CS&S Tech Ops NOC Other And a form rule when employee name is not blank, 'Department' is equal to the value in field 'Department Formula'. It works perfectly for all selections except CS&S. When the Employee is in that department, the 'Department Formula' field displays CS&S as it should. But the 'Department' field is blank. Is it the & thats messing things up? Is there a way around it? Thanks! ------------------------------ Trish Wehrle ------------------------------ formula to refresh dashboardI have a button on my form that checks a box (which does some automations), saves the record, and redirects to the dashboard. The problem is when you land back on the dashboard the automation isn't quite done so it doesn't look like the change has taken. Is there a way to add onto my formula to redirect to the dashboard and then refresh it? URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=xxxxxxxxxxxxxxxx" & "&_fid_35=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()) Thanks! ------------------------------ Trish Wehrle ------------------------------ Re: Extract a date from the middle of a logged fieldThank you thank you thank you! ------------------------------ Trish Wehrle ------------------------------ Re: Extract a date from the middle of a logged fieldIf there are two then the most recent one. Thanks! ------------------------------ Trish Wehrle ------------------------------ Re: Extract a date from the middle of a logged fieldHere's the logged field example that made me realize my formula was wrong. It returned the value of May-26. [MAY-12-20 8:54 PM Jason Khalaf] EE Contact with (close contact) [MAY-22-20 12:55 PM Adam Walters] Living with [MAY-26-20 8:58 AM Barry Smithley] EE positive Here's one example where the log has 'living with' as the latest entry: [APR-06-20 12:10 PM Trish Wehrle] EE Contact with (close contact) [MAY-26-20 10:18 AM Leah Schooling] Living with ------------------------------ Trish Wehrle ------------------------------ Re: Extract a date from the middle of a logged fieldSorry I'm stuck. Not sure I even know what search and replace is. ------------------------------ Trish Wehrle ------------------------------ Extract a date from the middle of a logged fieldI'm trying to extract a date into a formula date field from a logged field that isn't necessarily on the top or bottom of the log. It could be, but it could also be in the middle. I need the date associated with the "living with" selection from a multiple choice field. The formula i thought was working is If(Contains([Type Log],"Living with"), ToDate(Left(Right(NotRight([Type Log],"Living with"),"["),9)),null) But then i realized if there was another entry below the "living with" entry, it was grabbing that date instead. Is this possible? Thanks! ------------------------------ Trish Wehrle ------------------------------ Summary Report - filter by totalsI have a summary report that tabulates different types of cases based on a location. What I need is to only show locations where the total number of cases is more than a certain threshold...say 5? I have a field for Case type and a field for Location. The summary report works great but shows too much. I don't have any relationships and would love to keep it that way. Is there a way to accomplish this with a report filter? Seems like it should be so easy but I can't seem to figure it out. Thanks! ------------------------------ Trish Wehrle ------------------------------