
888Washington
Members-
Content Count
5 -
Joined
-
Last visited
About 888Washington
-
Rank
Newbie
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
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
- 1 reply
-
- trigger
- compare values
-
(and 1 more)
Tagged with:
-
Triggers to populate more than one record
888Washington replied to 888Washington's question in Tables, Views and Relationships
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
- 3 replies
-
- tabular report
- hide columns
-
(and 3 more)
Tagged with:
-
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
-
Triggers to populate more than one record
888Washington posted a question in Tables, Views and Relationships
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 >