Re: IWP: Logging in to just one record?

On 2008-08-24 04:37:08 +0200, Jonathan Peirce said:

> Hello All:
>
> FMP Advanced 9.01 Mac
> -Published via IWP
>
>
> -I have a database where each record is a city, and carries info such
> as hotel, contact, travel, meals, etc. for each city (record).
>
> -I would like to have people enter info into a record that corresponds
> to their city. For instance, the hotel would access the record for
> their city, and be able to enter their phone number, or address, etc.
>
> One solution is to break up the database and have a bunch of databases
> with just one record, then the hotel would go to the home page and
> click their 'city', and be prompted for Login/Pass. The problem with
> that is I would have to have hundreds of open databases on my desktop.
> I don't really like this solution.
>
> My "grand plan!" is to have each record generate a random password,
> then email it to the hotel, and when the hotel enters that password on
> the webpage, it takes him to the related record. They would only be
> able to see and edit 'their' record...
>
> I can't figure out how to USE the password in the login page. Maybe I
> could let everyone through the home page, but then the first page of
> the database is a login page that I build, where I could use the
> entered number to jump to the related record?
>
> Any ideas would be greatly appreciated!
> JP

I am planning something similar as you where hotels can update
information about themselvs, and my idea is to use a relationship where
the password and a username is the relationship primary key, so the
hotel only see this one record. You then must hava a second database
where you creats a relationship based on the username and password, and
through this relationship you will see only this one record with the
matching username and password.
I think it maybe can be one solution to crate a script that contains:
-from the hotel recrod, you start the script.
-it creats a password and username and sets this in the username and
password field on the current record.
-it creats a useraccunt with the username and password
-it creats a url to the database where you have the username and
password in the url so you get right to the database and the login
screen with the username and password already entered (I think this is
possible..)
-it creats a email to the hotelboss and sends some info about pleas
update and click the url.
the boss now goes to the webpage with the url and is logged in to the database.
-it sets the username and passwordfield with data, so the relationship
with the one record information is displayed
-it goes to one field, so it is in edit mode
-the hotelboss enters the information and hits Save.
-the scripts continues with commit record, and you can see the edited
info and do something more. When you are finisched you have to confirm
the entered information
-when confirming the useraccount is deleted and then you wil be logged out.

What do you think?

Nicolay

On 2008-08-24 13:07:00 -0400, Nicolay Flaaten
said:

> On 2008-08-24 04:37:08 +0200, Jonathan Peirce said:
>
>> Hello All:
>>
>> FMP Advanced 9.01 Mac
>> -Published via IWP
>>
>>
>> -I have a database where each record is a city, and carries info such
>> as hotel, contact, travel, meals, etc. for each city (record).
>>
>> -I would like to have people enter info into a record that corresponds
>> to their city. For instance, the hotel would access the record for
>> their city, and be able to enter their phone number, or address, etc.
>>
>> One solution is to break up the database and have a bunch of databases
>> with just one record, then the hotel would go to the home page and
>> click their 'city', and be prompted for Login/Pass. The problem with
>> that is I would have to have hundreds of open databases on my desktop.
>> I don't really like this solution.
>>
>> My "grand plan!" is to have each record generate a random password,
>> then email it to the hotel, and when the hotel enters that password on
>> the webpage, it takes him to the related record. They would only be
>> able to see and edit 'their' record...
>>
>> I can't figure out how to USE the password in the login page. Maybe I
>> could let everyone through the home page, but then the first page of
>> the database is a login page that I build, where I could use the
>> entered number to jump to the related record?
>>
>> Any ideas would be greatly appreciated!
>> JP
>
> I am planning something similar as you where hotels can update
> information about themselvs, and my idea is to use a relationship where
> the password and a username is the relationship primary key, so the
> hotel only see this one record. You then must hava a second database
> where you creats a relationship based on the username and password, and
> through this relationship you will see only this one record with the
> matching username and password.
> I think it maybe can be one solution to crate a script that contains:
> -from the hotel recrod, you start the script.
> -it creats a password and username and sets this in the username and
> password field on the current record.
> -it creats a useraccunt with the username and password
> -it creats a url to the database where you have the username and
> password in the url so you get right to the database and the login
> screen with the username and password already entered (I think this is
> possible..)
> -it creats a email to the hotelboss and sends some info about pleas
> update and click the url.
> the boss now goes to the webpage with the url and is logged in to the database.
> -it sets the username and passwordfield with data, so the relationship
> with the one record information is displayed
> -it goes to one field, so it is in edit mode
> -the hotelboss enters the information and hits Save.
> -the scripts continues with commit record, and you can see the edited
> info and do something more. When you are finisched you have to confirm
> the entered information
> -when confirming the useraccount is deleted and then you wil be logged out.
>
> What do you think?
>
> Nicolay

I think I solved it. Basically I have a password field filled with a
random number on each record. I have FM email the number to the hotel,
and then when they go to the page,
the opening script is a 'find', they type in their password, and it
takes them to the related record.
JP
--
“Travel is fatal to prejudice, bigotry and narrow-mindedness.”
-Mark Twain

On 2008-08-25 01:13:24 +0200, Jonathan Peirce said:

>>
>>
>> What do you think?
>>
>> Nicolay
>
> I think I solved it. Basically I have a password field filled with a
> random number on each record. I have FM email the number to the hotel,
> and then when they go to the page,
> the opening script is a 'find', they type in their password, and it
> takes them to the related record.
> JP

But then you must make shure that the user dont get acces to the rest
of the database somehow, and that the acces dont stands open for ever...
I think you can solve it your way, but be careful.

Nicolay

On 2008-08-25 08:34:20 -0400, Nicolay Flaaten
said:

> On 2008-08-25 01:13:24 +0200, Jonathan Peirce said:
>
>>>
>>>
>>> What do you think?
>>>
>>> Nicolay
>>
>> I think I solved it. Basically I have a password field filled with a
>> random number on each record. I have FM email the number to the hotel,
>> and then when they go to the page,
>> the opening script is a 'find', they type in their password, and it
>> takes them to the related record.
>> JP
>
> But then you must make shure that the user dont get acces to the rest
> of the database somehow, and that the acces dont stands open for ever...
> I think you can solve it your way, but be careful.
>
> Nicolay

Agreed. But with a random 6 number PIN (100,000 possibilities) and 365
unique records, I am hoping no one guesses another PIN. I can put in a
script that quits after 3 incorrect attempts, I think.
JP
--
“Travel is fatal to prejudice, bigotry and narrow-mindedness.”
-Mark Twain