EQuIS Forms Series – Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016

April 27, 2016




Part 5 of 5
EQuIS Forms provide users with the ability to view and update data from often-used tables that relate to facilities, locations, and sample test results.

TABLE of CONTENTS
01:29 Conceptualizing a Form (2:04)
03:33 Designing the Form (1:16)
04:49 Developing the Form (1:14)
06:04 Coding a Custom Form (3:47)
09:52 Form Code & Form Design (3:39)
13:30 Anchoring Form Elements (1:58)
15:29 Form Load Method (6:03)
21:33 Form Buttons (8:28)
30:01 Q1? What are the references?
31:15 Q2? Do you need a different form to edit permit information?
31:29 Q3? What type of Visual Studio project is this?
32:45 Q4? How do you make the form a child of the main window?
33:17 Q5? What code do we add to show that the data has been added to the grid and needs to be saved?
35:51 Q6? Any additional tips on publishing and permissions?
37:52 Q7? Is the compiled form normally placed in the main EQuIS Professional installation directory as a DLL?

Download EQuIS Forms Series:
Part 1 of 5 – Introduction to Forms – March 2016 [16:34]
Part 2 of 5 – Coordinate Conversion Form – March 2016 [14:30]
Part 3 of 5 – RVF Builder Form – April 2016 [10:30]
Part 4 of 5 – EQuIS SQL Form – April 2016 [43:50]
Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016 [39:10]



Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

EQuIS Video for EPA Region 4

April 25, 2016

EQuIS 6.5 Announcement

April 21, 2016


Click here to download.

EQuIS Forms Series – Part 4 of 5 – EQuIS SQL Form – April 2016

April 20, 2016




Part 4 of 5
EQuIS Forms provide users with the ability to view and update data from often-used tables that relate to facilities, locations, and sample test results.

TABLE of CONTENTS
01:00 Definition SQL (1:20)
02:20 EQuIS SQL Form (1:55)
04:15 Limitations SQL Query Form (1:31)
05:46 Overview EQuIS SQL Form (1:16)
07:03 Basic Query (6:25)
13:29 Multiple Tables Query (4:28)
17:57 Exploring the Database (15:23)
33:22 Publishing a (*.sql) Report (2:36)
35:58 Q1? Is there a list of valid local variables?
38:34 Q2? Once the SQL statement has been published, does it appear under the Report tab, or the Form tab?
39:28 Q3? What permissions are required to publish a report?
39:57 Q4? Are there any blocks for the type of SQL, such as Insert or Delete?

Download EQuIS Forms Series:
Part 1 of 5 – Introduction to Forms – March 2016 [16:34]
Part 2 of 5 – Coordinate Conversion Form – March 2016 [14:30]
Part 3 of 5 – RVF Builder Form – April 2016 [10:30]
Part 4 of 5 – EQuIS SQL Form – April 2016 [43:50]
Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016 [39:10]



Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

EQuIS Forms Series – Part 3 of 5 – RVF Builder Form – April 2016

April 13, 2016




Part 3 of 5
EQuIS Forms provide users with the ability to view and update data from often-used tables that relate to facilities, locations, and sample test results.

TABLE of CONTENTS
00:37 Definition RVF
01:08 Definition RVF Builder Form
02:11 Specific RVF from Specific Tables
04:00 RVF Specific to EDD Type
06:51 Q1? Is output all records rt_analyte or just the cas_rns used by Whtiney facility?
07:41 Q2? Does RVF Builder Form respect only facility IDs in the selected facility?
08:11 Q3? How are RVF made facility specific?

Download EQuIS Forms Series:
Part 1 of 5 – Introduction to Forms – March 2016 [16:34]
Part 2 of 5 – Coordinate Conversion Form – March 2016 [14:30]
Part 3 of 5 – RVF Builder Form – April 2016 [10:30]
Part 4 of 5 – EQuIS SQL Form – April 2016 [43:50]
Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016 [39:10]



Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

EDGE 6.5 Announcement

April 8, 2016


Click here to download.

EQuIS Forms Series – Part 2 of 5 – Coordinate Conversion Form – March 2016

April 4, 2016




Part 2 of 5
EQuIS Forms provide users with the ability to view and update data from often-used tables that relate to facilities, locations, and sample test results.

TABLE of CONTENTS
00:38 Coordinate Conversion Form .dll’s & Library
01:33 New Documentation
02:48 Source & Target Data
05:47 Demonstration
11:34 Q1? Can you clarify if the units only apply to Z value?
11:52 Q2? Is a Schema Update required?
11:58 Q3? Will documentation be updated Online as well?
12:14 Q4? Does this form overwrite or make new records?
12:43 Q5? Does the unit get pulled from dt_coordinate or dt_facility?
13:09 Q6? Does Coordinate Conversion Form require a specific EQuIS license level?

Download EQuIS Forms Series:
Part 1 of 5 – Introduction to Forms – March 2016 [16:34]
Part 2 of 5 – Coordinate Conversion Form – March 2016 [14:30]
Part 3 of 5 – RVF Builder Form – April 2016 [10:30]
Part 4 of 5 – EQuIS SQL Form – April 2016 [43:50]
Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016 [39:10]



Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!


EarthSoft Currents Week 30 2017 Video Newsletter

EnviroInsite Series: Part 4 - Srip Logs - Jul 2017