You could go the "local web with forms" route that Dooza
suggested, or you
could just use Excel on the laptop, if that is where the data
is going to
end up anyway. You can set up a data entry form in Excel to
make data
collection easier.
I'm thinking that the uploaded Excel file on the central
server could be
linked to by the master Excel file, so that any changes are
automatically
picked up.
Example: You send out four laptops, one to each Sales region.
The
representatives collect information via an Excel application
using the data
entry form.
At the end of each day, the representatives return to their
hotels and
upload the daily data file to the central web server using
predefined file
names, replacing the previous posting.
Back at home base, someone runs the master Excel spreadsheet,
which has
links to each of the four regional spreadsheets. The master
file is then
saved and processed as necessary.
As I said, there are many ways to do this, and they don't all
have to
involve a lot of web programming. You could use this approach
with e-mail if
needed.
HTH
Steve
"dpiasta" <webforumsuser@macromedia.com> wrote in
message
news:g9k8ul$69h$1@forums.macromedia.com...
> Basically this is the scoop. We gather form information
in remote regions
> that
> do not have internet access.
> The form is on a laptop that has complete internet
capabilities but at the
> time the form is being used it has no access to the
internet. So,
> basically the
> internet access is temporary. We are totally flexible as
to how the form
> info
> is gathered. Ultimately each entry will be appended to a
larger excel
> spreadsheet (or equivalent). Any ideas?
>
>
>
4
Replies
AdChoices