Skip to main content
Solved

Creating a contact form from one table to add row on another.

JeffJohnVol
Forum|alt.badge.img+16

I'm having a mental block on something, and I'm sure someone will point out the right way to do this, and I'll privately say "oh, of course", but for some reason the coffee and adderal hasn't kicked in yet....

I'm trying to make a member contact form that has a link to a specific person to populate an email table.

I have two tables:

Member - a list of people including status, name, email address etc...

Email - a table that has all the email fields that I use an automation script that takes certain status values "Send" and sends those out and changes the status. I use this script method instead of the pure automation because I have several other scripts that generate emails from templates to send emails out.

We essentially have a wiki page with a page for each users's profile (for example: <Jeff's profile >. I want to have a link that uses id=record_id() of a row on my members table, which ties to an individual. When they hit the link, it pulls up the name, member photo, and some contact fields (person's name, email and text). When a person fills out the form, it adds a row to the Email table with the particulars and a status of "Queued". At that point, I can modify my script to process the contact form and send the email.

My initial thought was to add a record-field to "email" from the "Members" table and use a record picker to handle it, but that would require a contact to add the item manually, and I just one one form with them able to submit their request.  I also thought I need to create an "Email" row for every member, and it be an edit form, but that gets compiclated if a member gets 2 or more people contacting them. Maybe I need to create a 3rd record, say "Contact" to support this? But if so, I'd need to have a way for the form to pull in the name and photo...

Please remind me what I'm missing,  🙂

Thanks

Jeff

Best answer by JeffJohnVol

Katherine from Fillout was able to assist me, and it worked. Here's the solution:

 

View original
Jeff JohnsonPresident, ChattLab Makerspace
Did this topic help you find an answer to your question?

TheTimeSavingCo
Forum|alt.badge.img+28

Hmm, I feel like I'm missing something, but would a prefilled form link work?

And so once they click the link above the 'Members' field is already filled and they can just enter the body:

 

Adam, Consultant @ thetimesaving.company
JeffJohnVol
Forum|alt.badge.img+16
TheTimeSavingCo wrote:

Hmm, I feel like I'm missing something, but would a prefilled form link work?

And so once they click the link above the 'Members' field is already filled and they can just enter the body:

 


Thanks for the suggestion Adam. The trick is that if I have a members table, with one member per row, and a member gets 5 visitors trying to send a message, I would either have to count on them not doing it at the same time, or add 4 more rows for the member, which I don't want to do. FWIW, I hope to have rows of contact forms and I'll use a javascript to format and send (extra work, but there's other logic I need to do to filter out spam and bots beyond the normal captcha).

 

Here's a simplified scenario: I have 2 tables, Person and Contact. I want my form to create a new Contact row, but the link to come from the Person table. I'm assuming the fillout url would point to the contact form, but pass in the record_id of the person. But creating a new contact row, the person isn't linked to the contact yet.  Rather than use the Person selection as shown in the form, is it possible to pass in the Person record_id, associate it in the form (as read only) and pull in the photo on the page? In a worst case scenario (which may be the best solution) I suppose that I could just pass in the Person "key" (Name) to the form, not have a photo displayed, and create the Contact with the Name key and then associate it with a script when I process the contact email.
 

 

 

 

 



 

 

 
 
Contact Fillout Form:
 

 



 

 
Jeff JohnsonPresident, ChattLab Makerspace
JeffJohnVol
Forum|alt.badge.img+16

Katherine from Fillout was able to assist me, and it worked. Here's the solution:

 

Jeff JohnsonPresident, ChattLab Makerspace

Reply


Most helpful members this week

Terms & Conditions