I am looking for a way to have users register for a training class via forms. Rather than maintaining a excel file on a local network that users are currently using. Ideally they would submit a form to select a date/time. Then it would add this information to a table. Possibly with the added feature of tracking the number of users registered to a specific time/date so we can limit a class size. Probably would need a way to update the time selected by a user in case the change their mind about which date/time they want to attend.
Question
Question
Form/workflow to have users register for a training
Replies
To begin with you would need a Form for the initiator to populate their personal details and which option that they would like to attend, you could add an approval step in this process so that an internal member could confirm that there are seats available on the course and if approved an email can then be sent to the initiator and then call a Workflow to update back end/internal tables.
As for your business process you would then need Forms to make a call to a Workflow which would retrieve the Business Process Variables from the form after the approval stage, insert into a SQL table of registered parties and maybe some token calculator after a lookup to update the number of attendees in a separate course table in SQL which could update the number of attendees. This would retrieve the current number of attendees then add 1 to that value and write back to the specific column.