User System Data?

Hi I'm pretty new to gINT....

I would like to know if I can give function to the input columns....

Example if there's a water content table with the following coloumns:

Depth, Wet weight, Dry weight, Tin weight, Water Content

Can I add a formula to the water content column so it gets calculated automatically?

Many thanks...

Parents
  • Welcome to using gINT!

    Functionality can be added to your Water Content table in the INPUT application using gINT Rules, and there are several examples of gINT Rules that populate calculated data into the project database here in the WIKI.

    However, I believe the calculation you want is already included in the gINT Lab Testing Module, which is part of gINT but needs to be enabled in the Additional Modules menu in INPUT. A PDF manual about the module and how to use it is available under the gINT Help menu by selecting Manuals.

    Note: In the gINT Lab Testing Module, the Tin Weight is referred to as "Tare".



  • I agree with Pat that a gINT rule or the lab module will provide the requested functionality and are your first choice.

    As a third alternative; if it is not a requirement to have the calculated water content in its own field in the actual database; you can simply calculate the water content using a formula on output (whether output be to a log, table, file, whatever).  This would be inserted in the output template (or corespondence file) and would calculate everytime you output to that template (or file).  This would only be preferable if a large amount of your data allready exists in a gINT table as described, and you do not care if there is an actual field with water content in the database.

  • Scott, that's a good point - and it brings us back to the User System Data question originally asked.

    In the report, to calculate the water content you will use an expression. This expression can be left in the report as-is, or (if it will be used in more than one place) it can be converted to a User System Data, which is essentially a named expression. Then each time you use it, you would select it by name from the User System Data table instead of re-entering the expression itself over and over.

    There is quite a lot of information in the gINT Help about creating, editing and using User System Data items. Also check out the Data Tool discussion in Help for an even easier way to use User System Data items in Report Design.



Reply
  • Scott, that's a good point - and it brings us back to the User System Data question originally asked.

    In the report, to calculate the water content you will use an expression. This expression can be left in the report as-is, or (if it will be used in more than one place) it can be converted to a User System Data, which is essentially a named expression. Then each time you use it, you would select it by name from the User System Data table instead of re-entering the expression itself over and over.

    There is quite a lot of information in the gINT Help about creating, editing and using User System Data items. Also check out the Data Tool discussion in Help for an even easier way to use User System Data items in Report Design.



Children