Gossamer Forum: Products: Gossamer Links: Discussions: Auto insert data from another table

Jun 8, 2009, 11:09 AM

Sies

User (72 posts)

Jun 8, 2009, 11:09 AM

Post #1 of 4

Shortcut

Auto insert data from another table

How does links auto insert the contact name and email address from the glinks_Users table when "Add a Link" is selected?
I added "City" "State" "zip" and "Phone" fields to the glinks_Users table. I want these values to auto fill when users adds another link.

Jun 8, 2009, 11:40 AM

Andy

Veteran / Moderator (18441 posts)

Jun 8, 2009, 11:40 AM

Post #2 of 4

Shortcut

Re: [Sies] Auto insert data from another table In reply to

You would need a little plugin, that would hook in on add_link (POST), and then update their profile, based on the values they passed in from the add.cgi form. Afraid I don't really have time to do this for you at the moment though, as I'm a bit overworked ATM.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jun 9, 2009, 7:40 AM

Sies

User (72 posts)

Jun 9, 2009, 7:40 AM

Post #3 of 4

Shortcut

Re: [Andy] Auto insert data from another table In reply to

I didn't want a user to have to re-type their address everytime they added a listing. Since the address fields are already in the users table, I just the values in the user table to auto fill into add form. Just like the email does.

Jun 9, 2009, 7:47 AM

Andy

Veteran / Moderator (18441 posts)

Jun 9, 2009, 7:47 AM

Post #4 of 4

Shortcut

Re: [Sies] Auto insert data from another table In reply to

Ah, I mis-understood you.

Just use:

<%if FieldName%>value="<%FieldName%>"<%elsif user.FieldName%>value="<%user.FieldName%>"<%endif%>

Cheers

Andy (mod)
andy@ultranerds.co.uk