
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 03, 2025 12:47 PM
I have an Hours table that records for each member (identified by email address) the number of hours they participate in an organization event. The table consists of email address, event category, #hours, date, and two optional fields, event name and event id. When members go to input their hours, they typically have more than one activity to report. I want to create a form such that the member inputs their email address only once and then can input multiple instances of {event category, hours, date}. I saw one possible solution that added another table linked to the hours table and allowing multiple records, but I'd prefer to not have to create another table for just this purpose. Any help, guidance, direction would be greatly appreciated.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2025 01:55 AM
what the "button" entry means in the "add hours" field. But I assume, from what you said above, that it is a link to the URL for their personal form?
Yeap that's right, opens the link to their personal form
---
when I click the arrow next to the "add hours" field heading, it pops up "button" and again I don't know about that construct yet.
Hmm I'm not sure I follow. Are you referring to the 'Button' field type? If so, here's the documentation: https://support.airtable.com/docs/button-field
---
When I click on the down arrows next to the field heading names, it pops up "copy field URL".
Yeap, you're looking at the field settings so that sounds about right
---
Where are the personal forms - was one created for each of the 3 members in your example?
Nope, there's a single form that is prefilled with the member's record ID
---
In any case, I don't think hundreds of members having the URL to their personal form is sustainable.
Ah, yeah, if the users can't handle keeping track of personal URLs then this system doesn't work I'm afraid. With this restriction, I reckon you're going to have to create a new table to handle the form submissions like you said
---
If the form needs to change, then we would need to change it for all members
There's only one form, so changes will only need to be made in one place

- « Previous
-
- 1
- 2
- Next »