Hi Bob, I have to agree with John - I don't see anything that precludes using a listbox. And I say this as a guy who really likes using web areas.
Just make all the listbox arrays text. (This is essentially what you would be doing using javascript anyway.) You can handle converting to and from other data types when you load/ save the arrays. On Fri, Mar 16, 2018 at 1:09 PM, Bob Miller via 4D_Tech < [email protected]> wrote: > 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] > ********************************************************************** -- Kirk Brooks San Francisco, CA ======================= *We go vote - they go home* ********************************************************************** 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] **********************************************************************
