Is there a way for the automation to perform the action based on the response in a certain field e.g. if the response in the Gender field is ‘Male’ the record should be created on one table and if it is ‘Female’ then the record should go on another table.
(I think I do need them on separate tables as opposed to creating a view as I need to link records. In my example above, on a male record I would need to select someone from the female table to match him up with and vice versa)
Apologies if I’m not being clear.