Hi Everyone, I have a task that might be a good application for a 4D web area. This would be my first use of this feature; normally I'd use Arealist or a Listbox to do this, but in this case the number of variables is high enough that a new approach might be warranted.
The problem: we have a number of workcenters that each have different data collection requirements when a product is made at that workcenter. I have a table for each workcenter that includes data on what each data element is; the user can set up a workcenter and specify how many data elements are to be collected, what the name of each data element is, and what the data type (alpha or real) of each data element is. The problem is creating a data entry area. The area is supposed to look like a spreadsheet so that a user can enter multiple data points on a single screen and then click one button that behind the scenes will update multiple records. I've created a simplistic screen shot at: https://s13.postimg.org/hmj5o10fr/Web_Area_Mockup.jpg Basically, the program flow for the data entry portion is: > User selects the workcenter for which he needs to enter data > The web form design is programmatically pulled together with the data from the workcenter setup file - this includes data about the type of data, the amount of data to be displayed, the enterability rules, etc. - and it pulls in the privileges of the user. The form is then set up with the correct number of rows and columns, the data is put into the proper cells, and the enterability rules are applied. > The user either enters new data or overtypes existing data as required > The user submits the data (is this a 'Submit' button in the web area or a button on the form?) > The program checks which data elements have been changed and updates the database accordingly So my questions are: > What are best practices for setting up an enterable HTML table that will be displayed in a web area? > Is there any callback possible when the user enters data in a cell in an HTML table in a web area? > How does one pull the data from the form out of the web area so it can be used to update the database? If anyone has any coaching tips or - this would be wonderful - an example I could poke at - I would be deeply grateful. Beers on me at the Summit, for sure. Thank you, Bob Miller Chomerics, a division of Parker Hannifin Corporation llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll "PLEASE NOTE: The preceding information may be confidential or privileged. It only should be used or disseminated for the purpose of conducting business with Parker. If you are not an intended recipient, please notify the sender by replying to this message and then delete the information from your system. Thank you for your cooperation." ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
