473,320 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

creating dynamic Excel forms, w/ validation -- possible?

hello,

i am on an interesting project. in this project, i have to create
dynamic data-entry forms for offline-users to fill out, save locally,
and eventually postback to our app (when back online). data validation
is required on the form.

i had looked at using PDF-forms for this.. Adobe's "LifeCyle Forms"
would work perfectly. with it one can pass in xml to their webservice &
get back PDF-form binaries. however, Adobe's pricing is simply
unrealistic for any but super-large budgets (got an extra 50k + 20%
annual maintainence for your project? talk to adobe).

so now im back to something low-tech. sure, i could do it w/ .HTML
forms w/ javascript validation, and use javascript to save the
data-entry into a .xml file. however, a two-file solution is not viable
for us.

my next idea is probably better from a user standpoint anyway -- Excel
forms. the user could input into the excel doc, save it, and later
return it to us.

two key questions:

1) can i build dynamic Excel forms w/ .NET?
2) if so, can i build them w/ any kind of data validation?
any help would be greatly appreciated!

thanks,
matt

Aug 25 '06 #1
5 2516
If you are looking at offline work I would seriously look at MSMQ
(System.Messaging in .Net 2) and a WinForms app,

Kevin Jones

ma**@mailinator.com wrote:
hello,

i am on an interesting project. in this project, i have to create
dynamic data-entry forms for offline-users to fill out, save locally,
and eventually postback to our app (when back online). data validation
is required on the form.

i had looked at using PDF-forms for this.. Adobe's "LifeCyle Forms"
would work perfectly. with it one can pass in xml to their webservice &
get back PDF-form binaries. however, Adobe's pricing is simply
unrealistic for any but super-large budgets (got an extra 50k + 20%
annual maintainence for your project? talk to adobe).

so now im back to something low-tech. sure, i could do it w/ .HTML
forms w/ javascript validation, and use javascript to save the
data-entry into a .xml file. however, a two-file solution is not viable
for us.

my next idea is probably better from a user standpoint anyway -- Excel
forms. the user could input into the excel doc, save it, and later
return it to us.

two key questions:

1) can i build dynamic Excel forms w/ .NET?
2) if so, can i build them w/ any kind of data validation?
any help would be greatly appreciated!

thanks,
matt
Aug 28 '06 #2
sounds interesting, but i wonder about the ability to custimize. in my
scenario, forms is good because i can render new form UI (additional
textboxes, status fields, etc) per the intended recepient, at
execution-time (when the form is created).

i may be speaking out of ignorance, but wouldnt a winform app would be
harder to customize? remember that the UI is different for each user.
to make this happen, i would have to deliver each user an .xml file
that they would have to "import" into the winforms client, in order to
get the customized look.. i think it would be harder for my
non-technical users to do this, than to just to work on an excel form.

also, the user could not forward the winforms app to another user for
review/editing, like he could w/ a portable, common form (pdf-form or
excel form).

so, the question remains -- can one use .NET to dymically build excel
forms w/ validation?
matt
Kevin Jones wrote:
If you are looking at offline work I would seriously look at MSMQ
(System.Messaging in .Net 2) and a WinForms app,
Aug 28 '06 #3
How are you customizing the XML form?

Kevin Jones

ma**@mailinator.com wrote:
sounds interesting, but i wonder about the ability to custimize. in my
scenario, forms is good because i can render new form UI (additional
textboxes, status fields, etc) per the intended recepient, at
execution-time (when the form is created).

i may be speaking out of ignorance, but wouldnt a winform app would be
harder to customize? remember that the UI is different for each user.
to make this happen, i would have to deliver each user an .xml file
that they would have to "import" into the winforms client, in order to
get the customized look.. i think it would be harder for my
non-technical users to do this, than to just to work on an excel form.

also, the user could not forward the winforms app to another user for
review/editing, like he could w/ a portable, common form (pdf-form or
excel form).

so, the question remains -- can one use .NET to dymically build excel
forms w/ validation?
matt
Kevin Jones wrote:
>If you are looking at offline work I would seriously look at MSMQ
(System.Messaging in .Net 2) and a WinForms app,
Aug 28 '06 #4
Sorry, meant to say.

How are you customizing the Excel form,

Kevin Jones wrote:
How are you customizing the XML form?

Kevin Jones

ma**@mailinator.com wrote:
>sounds interesting, but i wonder about the ability to custimize. in my
scenario, forms is good because i can render new form UI (additional
textboxes, status fields, etc) per the intended recepient, at
execution-time (when the form is created).

i may be speaking out of ignorance, but wouldnt a winform app would be
harder to customize? remember that the UI is different for each user.
to make this happen, i would have to deliver each user an .xml file
that they would have to "import" into the winforms client, in order to
get the customized look.. i think it would be harder for my
non-technical users to do this, than to just to work on an excel form.

also, the user could not forward the winforms app to another user for
review/editing, like he could w/ a portable, common form (pdf-form or
excel form).

so, the question remains -- can one use .NET to dymically build excel
forms w/ validation?
matt
Kevin Jones wrote:
>>If you are looking at offline work I would seriously look at MSMQ
(System.Messaging in .Net 2) and a WinForms app,
Aug 28 '06 #5
im not, yet. just spec'ing this out.

but the customization will (at this time) come in the form of "Part"
line-items for the user to report on -- each user is assigned different
lists of parts to inspect & report on. it *sounds* like this could work
in a tabular format -- PartID, % Complete, various date fields,
Comments, etc.

so i could generate & pass user-specific xml (his assigned parts) to a
winforms app and fill a datagrid w/ it, and let the user fill-in the
rest.

that may work. but the disadvantage is:

1) installation of an application thru our corporate gatekeepers
2) inability for user to simply email the filled-in inspection report
to another user (say his manager) for further tweaking. that manager
may then send it back to us, the application.

so thats why we've been looking at PDF-forms (ideal, but too expensive)
and now Excel forms.
matt
Kevin Jones wrote:
Sorry, meant to say.

How are you customizing the Excel form,
Aug 28 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Venkatesh | last post by:
Hi Everybody, This is the first timw I am entering into this Group. I am developing a VB Project with an MDI form. I want to display IE Favorites into my application. For this I need to...
13
by: mr_burns | last post by:
hi, is it possible to change the contents of a combo box when the contents of another are changed. for example, if i had a combo box called garments containing shirts, trousers and hats, when...
11
by: brian.newman | last post by:
I'm trying to use a layer inside a form to hide/reveal a part of the form, but my code doesn't seem to be working and I need some help debugging it. I'm not getting an error which has made it...
1
by: Toby Miller | last post by:
I have this form validation that I'm trying to build, but it's not working properly. A dynamic function to the onsubmit event for a form. the result of that function (true/false) should then be...
14
by: pmud | last post by:
Hi, I need to use an Excel Sheet in ASP.NET application so that the users can enter (copy, paste ) large number of rows in this Excel Sheet. Also, Whatever the USER ENETRS needs to go to the...
6
by: Chuck | last post by:
I created a VB.net app that opens a current excel workbook, puts some data in it and saves it. This works fine on all XP machines. But I am getting an error on win 98 machines. here a portion...
3
by: Mukesh | last post by:
sir, i am developing a database, which will store the users profile both personal and professional which includes the address, telephone, gender and etc. in my main table i have created a column...
3
by: saragoesnuts | last post by:
I have a program that automates to Excel with information in tables. I want to add charts to the excel file (pie charts, bar charts, etc). Is this possible?
4
by: Bongard | last post by:
I have a dynamic range that I would like to use as a linked table into Access. The problem is that Access doesn't seem to want to to recognize the dynamic range when you click on "show named...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.