TrishWehrle
Qrew Cadet
Joined 7 years ago
User Profile
User Widgets
Contributions
Total grandchild records in a grandparent with drill down
I have three tables, Audits>Questions>Nonconformities Audits have multiple questions Questions have multiple nonconformities I'd like to display the # of nonconformities related to the audit on the audit table without creating a new relationship between audits and nonconformities. I've got this accomplished currently just doing a summary field from nonconformities to questions and then questions to audits but had to disable drill down since clicking it only took you to the 'parent' question table. Is there a rich text formula that could show # of nonconformities related to an audit with drill down that would go to the 'child' nonconformities table?93Views0likes2CommentsCombine two APIs
I 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 ------------------------------22Views0likes2CommentsAmpersand messing up formula/form rule
I 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 ------------------------------30Views0likes2Commentsformula to refresh dashboard
I 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 field
Here'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 ------------------------------2Views0likes3Comments