Help

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

Solved
Jump to Solution
233 3
cancel
Showing results for 
Search instead for 
Did you mean: 
JeffJohnVol
7 - App Architect
7 - App Architect

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

Jeff Johnson
President, ChattLab Makerspace
1 Solution

Accepted Solutions
JeffJohnVol
7 - App Architect
7 - App Architect

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

JeffJohnVol_0-1738270174689.png

 

Jeff Johnson
President, ChattLab Makerspace

See Solution in Thread

3 Replies 3

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

Screenshot 2025-01-30 at 10.25.46 PM.png

Screenshot 2025-01-30 at 10.25.16 PM.png

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

Screenshot 2025-01-30 at 10.26.46 PM.png

 

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.
 
JeffJohnVol_3-1738252626364.pngJeffJohnVol_4-1738252646506.png

 

 
JeffJohnVol_5-1738252692801.png

 

 



 

 

 
 
Contact Fillout Form:
 

 



 

 
Jeff Johnson
President, ChattLab Makerspace
JeffJohnVol
7 - App Architect
7 - App Architect

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

JeffJohnVol_0-1738270174689.png

 

Jeff Johnson
President, ChattLab Makerspace