This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello. While working at my company it has come up a few times that An Interface tool that acts like a standard "grid" would be extremely helpful.
This tool would allow users to update data that has a logical link to each-other like a stanard "row". Below are a few very simple examples where this would be extremely helpful.
#1) An application is being used as a file System ETL that has an interface that allows users to select what data to pull from a flat file and store in a database. The users can pick which 'columns' to keep by choosing the following information. The column name, type, and final database location of that column.
In this case a user needs to enter 3 key pieces of field information that have to relate to eachother.
#2) There is a table in a database that has thresholds for a specific law at the state level. (for Example: All loans in Florida must have a loan balance < 300k). However these laws can be updated, and the end users want the ability to #1: See the data, and then #2: Update it if the laws have changed.
A grid in this case would be perfect, as they could query the data to see the 50 states and specified limits, and then change the data in the "limits" column in order to update the database.
The previous 2 examples are pretty simple examples, but I have run into this request a few times from my personal experience, so figured I would see what everyone thought!