ContributionsMost RecentMost LikesSolutionsRe: Creating a Delay of page reloadTry using a headerless pop-out window function like this onclick=\"var a=window.open('"&$URL&"', 'newwindow', 'width=300,height=275');setInterval(function() {if (a.closed) {window.location.reload();}},500); If you're trying to solve the same problem I was, you're wanting to keep the page from reloading before the automation has a chance to complete :) try that with your own url string and see if that solves it for you.Re: Allowing only the person assigned the task to mark it as completehow do users mark the task as complete. Is this a dropdown/checkbox? or are you using a magic button to do this? If the user is directly editing a field to mark this as complete, your only option is a form rule. I'd recommend making a "Complete Task" magic button that changes whatever field/value you're using now, and you can limit that button to only display for the assignee. We'll say for this example your users have a checkbox called "Complete"..... om the example below, xx is the field id for the tasks tables record ID, and zz is the field ID for your "Complete" checkbox. For convenience, this example has a js string to allow this button to reload the page the button was pressed on so it can be placed in reports, dashboards etc. var text URL=URLRoot() & "db/" & [_DBID_TASKS] & "?a=API_EdotRecord&AppToken=yourapptokengoeshere&_fid_xx=" & URLEncode ([Record ID#])& "&_fid_zz=1" & "&z=" & Rurl(); var text jsAction="javascript:"&"$.get('" &$URL& "',function(){" &"location.reload(true);" &"});" & "void(0);"; If(User()=[Assignee], $jsaction , "") Hope this helps! Shawn M. Renn, Jr. Certified Quick Base Platform Developer / Sales Engineer 440-201-6050 Ext. 307 srenn@mcftech.com MCFTech Solutions |Business Wise, Technology Savvy Re: Using Automation to autofill predecessor field with previously created task from automationSurprised this hasn't been answered. It should be a quick fix, but depends on how you have your app structured, Ie, where you have your default tasks housed, and how you're handling dependencies. If this is still unresolved, feel free to contact me directly Shawn M. Renn, Jr. Certified Quick Base Platform Developer / Sales Engineer 440-201-6050 Ext. 307 srenn@mcftech.com Re: Copy Record then edit orginalThat's true. I did make the mistake of assuming the "1" represented a checked box on the original, but the recommendation would work even if the field weren't a checkbox. Your approach is a sound suggestion as well. Re: Complex ReportingHey Michelle, This is a pretty common issue, and the simple answer is you can only summarize a record value once, either by the primary, secondaryOR tertiary user field. What you need is that same "Record" to be represented by user for any and all "assignment types" they might be listed in, and to do that you would want a junction table between the user table, and the record where they're being assigned. (aka a Many-to-Many relationship). What you accomplish by doing this is making the user, the record, and the "assignment type" a unique record, and your reporting would be done from this new "Assignments" table. Hope that helps! Re: Copy Record then edit orginalOr use a redirect command to "Chain" multiple API's, editing the source record to check the box first, then copying it. Something Like this should work..... // 1. Checks the box on the Source record being copied URLRoot() & "db/" & "_________" & "?a=API_EditRecord&rid=" & URLEncode ([Record ID#]) & "&_fid_30=true&apptoken=_____________________&rdr=" // 2. The RDR above cycles to a second API Call type to copy that same source record... URLRoot()&"db/"________?a=GenCopyRecord&rid="&[Record ID#] You could also solve for this with actions or automations, which are a bit more user friendly. Depending on the use-case, checking the box on the source record and saving could be used as an "Automation" trigger that copies the values from that record to another, but the API route is a bit more elegant IMO.Re: Combine User Fields for ReportsYou could forego the user table honestly and just use the native User field type.The key part is that the assignments be "Child" to the existing "Records" table.Re: Combine User Fields for ReportsThe best way to account for this would be a "Many to Many" relationship where what you're reporting on is the unique assignment/types a user may have for any particular "record". When reporting on a single table, a column can only summarize a single record once, or not at all based on the filters you apply to that report. Lets assume the table you're assigning these users as either "Assigned to", "Transferred to" and/or "Reassigned to" is called "Tickets". A single ticket record is unique, and having 3 different user fields will only allow you to summarize that ticket based on one of them. If however you you had a table called assignments where you connected the user, their "Assignment Type" and the Ticket, you could then run a report from the assignments table where that user/assignment is unique, and the # of "Tickets" to which they were assigned is not. Your reports would look like this.... Hope this helps.Re: How to change the recurring javascript to include changes to start date AND end date. A simple fix would be to modify the end date to be a formula-date field, to include either a duration, or a referenceto a duration field. Example... if all you had was start and end date field, you could add a Duration field and a new field called End Date Formula. Lets assume that not all of your tasks are recurring, and some you want to set manually, others should be driven by the start date and a default duration.... You could write the formula with the condition that if the existing End date field is populated, (which could only happen now if a user filled it out) then the formula would use that as it's value, otherwise it would use the start date + duration to generate it's own end date. Doing it this way allows you to rely on ONE end date field for reporting without having to choose between automatic or manual. Try this formula... If([End Date]="",([Start Date]+[Duration]),[End Date]))Re: How do you open a .DAT file using Quickbase?Happy to help!