Hi all -
I've been thinking about this, and I think I have a way, but am not sure.
Is it possible to create a form, that instead of 'Submit' 'submitting' - it triggers a pipeline that takes all of the information just entered and creates a unique table entry off of each option?
So - what I'm thinking is - the table will visually look like this:
Today's Date
Staff Member User ID (who submits this report)
Total # of families served = ____
Total # of service providers served = ___
followed by:
___ total served in Community A
___ total served in Community B
___ total served in Community C
But on Submit, a unique entry is created for each numerical value provided in the form field.
So - so to create 'Community A' 'B' and 'C' - I would create a unique 'report' filtering values to just that one Community, that the form then lists on independent lines - so the end user sees all the communities and is able to enter their 'total' interactions within that community.
However, on submit, via a Pipeline, each one of their populated numerical values becomes its own unique entry in the table; filling in the 'date' and 'User ID' based on those field IDs.
Is that possible to do? I think it must be, but would love the confidence boost of having you more experienced users weigh in here.
Thank you!
Jen
------------------------------
Jennifer Juhasz
FamilySmart
BC, Canada
------------------------------
