- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2025 06:41 AM
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
President, ChattLab Makerspace
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 12:49 PM
Katherine from Fillout was able to assist me, and it worked. Here's the solution:
President, ChattLab Makerspace
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 06:27 AM
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:
 
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 08:00 AM
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).
President, ChattLab Makerspace
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 12:49 PM
Katherine from Fillout was able to assist me, and it worked. Here's the solution:
President, ChattLab Makerspace
![](/skins/images/DD0CD7D0ACF200EF4456420D87029A3D/responsive_peak/images/icon_anonymous_message.png)