Allow for new lookup field item in form?

1

Hello,
I’m creating a hiring doc. It has three tables:

  1. Designers
  2. Companies
  3. People

Why have People as a separate table? Because I may need one or more points of contact for a company (hiring managers) and I also need the same information for a designer (name, phone number, email, etc).

image
image1920×925 71 KB

I’d like to be able to send out a company form and a designer form for people to add themselves to this directory but I can’t send out a single or multi-page form to do this because it won’t let me create a form that also allows people to create a People record.

Is there a way around this either natively or through packages?

2

You could create another table, “incoming records”. Use this to gather submissions with a form. Set up an automation that watches for new rows in that table, and forward the data along to the relevant tables.

2 Likes