888Washington

I'm looking to only insert unique values within a record on update with a trigger. Right now I have two tables set up with a trigger on insert/update. When a user updates a field within the Employee's table, it copies all of the information from the current record into the Employee History table. However, my users want to be able to see what fields were modified within the Employee History table. The trigger currently just copies all fields (and values in those fields - most are text) from the current Employee's table to the Employee History table. The user then can compare the current r

Thank you! I ended up establishing a Join on the inserted value, and was able to accomplish this. I also created an update trigger so that if a user modified the result of the initial trigger, it would update the corresponding table with the most recent information.

Hi, I'm trying to hide two columns in a tabular report if one of the fields has null values or is empty. I've tried the following Java Script several different ways, but can't seem to get it to work correctly. A submission form feeds this tabular report, and if the user doesn't enter values in the 'Qty' field, it should be hidden on the tabular report. <script> var stl='none'; var tbl = document.getElementsByTagName('table')[0]; var rows = tbl.getElementsByTagName('tr'); var EmpQty = ("[@field:Employee_Productivity_Qty]").length; if (EmpQty<0) { for (va

Hi, I'm trying to implement the code above to hide columns 7 and 8 in a tabular report if their values are null. I can't quite seem to tweak the code to make it work for me. See code below. I declared a variable called empqty, which should be the name of the field to check if there are values, if the data is empty (null) then the tabular report should hide columns 7 and 8. Any assistance would be greatly appreciated! Thank you! <script language="javascript" type="text/javascript"> var stl='none'; var tbl = document.getElementsByTagName('table')[0]; var row

Hi, I'm trying to populate multiple records, based on a single record selection and submittal. I have 3 data pages involved in this process. I'll change some of the naming-convention from my industry-specific jargon to make a bit more sense: Data Page 1: Team Name, Employee, Title In the first data page the user organizes their employee's into different Teams. Each team is given a name and there are usually 4 to 5 employee's on each team who each have their own title. For example, Team 1 may have: > Billy - Team Lead > Bobby - Organizer >