On Mon, Jun 22, 2009 at 12:03 AM, Khalid Baheyeldin <span dir="ltr"><<a href="mailto:kb@2bits.com">kb@2bits.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Look at Drupal + the Webform module. It does most of what you said.<br><br><a href="http://drupal.org/project/webform" target="_blank">http://drupal.org/project/webform</a><br></blockquote><div><br>Thanks, and this leads to the interesting question of whether the rest of the application might migrate to drupal eventually as well. Which would probably make for easier maintenance. <br>
<br>Though, at present, I'd need to convince the developer team that drupal / webform will do what we want (eg., do the validations easily). <br><br>I'll investigate further tomorrow, but so far it looks like I need to build select-lists through some other means; and there might not be validation lookups from other tables without manually coding them each time, which is more programmer-intensive than I'd hoped for...<br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">If you want to ask the author questions, he is presenting at the Toronto DUG this Tuesday at 6:30 pm.<br>
<br>See <a href="http://groups.drupal.org/toronto" target="_blank">http://groups.drupal.org/toronto</a> for details.<br><br>Say hi to Nate if you go.<br></blockquote><div><br>Hm, great timing there. I will find out if anyone from the programming team can go!<br>
<br>Thanks again, -Daniel<br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><div class="gmail_quote"><div><div></div><div class="h5">
On Sun, Jun 21, 2009 at 11:53 PM, Daniel Allen <span dir="ltr"><<a href="mailto:dada.da@gmail.com" target="_blank">dada.da@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">Hey you wise libre-software people,<br><br>I'm looking for an open-source "forms wizard" such as the one found in Open Office. Only, it has to run over the web. Does anyone have suggestions? <br>
<br>The existing project is in PHP, and we're using MySQL (v4) databases.<br>
<br>The set of tasks it should accomplish are:<br><br>1) allow non-programmer users to generate web-forms which can save data to the database<br>2) allow non-programmer users to define portions of the database as "views" which may be displayed in a spreadsheet-like format (optionally editable).<br>
<br>and:<br><br>3) validate input data according to preset criteria (eg., "account codes must
match regex format" or "value must match an existing value in this
other table")<br>
<br><br>I've looked at OpenOffice BASE and it seemed way too complicated for non-programmer users. <br><br>The competition in windows-land is fairly strong: a Microsoft web/server product called SharePoint will store web-visible tables (it calls "lists"), forms can be built in a windows-only gui program to save data to these lists, and if you download a "list", it will open in Excel for editing, and changes are propagated back to the online database. ...Of course it doesn't work properly with Mac Excel, and of course its supposed ODBC support is so weak that you can only use it with Microsoft SQL, but on windows... it looks really slick. <br>
<br>Hopeful someone has run across open-source tools that might fit the bill.<br><font color="#888888"><br>-Daniel<br><br>
</font><br></div></div>_______________________________________________<br>
<a href="http://kwlug-disc_kwlug.org" target="_blank">kwlug-disc_kwlug.org</a> mailing list<br>
<a href="http://kwlug-disc_kwlug.org" target="_blank">kwlug-disc_kwlug.org</a>@<a href="http://kwlug.org" target="_blank">kwlug.org</a><br>
<a href="http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org" target="_blank">http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org</a><br>
<br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com" target="_blank">2bits.com</a>, Inc.<br><a href="http://2bits.com" target="_blank">http://2bits.com</a><br>
Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>
</font><br>_______________________________________________<br>
<a href="http://kwlug-disc_kwlug.org" target="_blank">kwlug-disc_kwlug.org</a> mailing list<br>
<a href="http://kwlug-disc_kwlug.org" target="_blank">kwlug-disc_kwlug.org</a>@<a href="http://kwlug.org" target="_blank">kwlug.org</a><br>
<a href="http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org" target="_blank">http://astoria.ccjclearline.com/mailman/listinfo/kwlug-disc_kwlug.org</a><br>
<br></blockquote></div><br>