Event entry form from 2 seperate tables

HI. so i am busy setting up a test portal for my Dog Breeding organisation.

I have a 4 main tables that i am sourcing information from.

  1. User (name, email, member number, breeder/owner,members club, website)
  2. dogs owned by above user with same email linked to the above user (Dog details, email address linked to user profile)
  3. list of different events hosted by different clubs
  4. list of clubs

Now im trying to create and entry form that can be mailed to the office for processing.

when i create my form, it always wants to write to a specific column in my calender file.

I dont want it to write to any file, i just want to be able to email the selection as a pdf to someone. is this possible

Consider creating a helper table with a single row and user-specific columns. This will allow the email action to read the necessary details and send the email to the desired recipient.

Use the Form container component to link the form to the helper table. Then, create a custom action directly on that source table.

The form will now write to the helper table instead of the previously selected table (Calendar).