I am new to Tadabase and I would be most grateful if someone could suggest some pointers to assist me in using a Pipe to accomplish my objective as stated below. I am currently using Form Rules but I have realised that Pipe would work much better. Any suggestion would be appreciated.
Use Case: Risk Assessments to be carried out on church buildings. An assessment is, in effect, a review and it consists of test questions that are recorded in a Tadabase table (Test Questions) grouped according to the type of test e.g. Fire Risk, Electrical Condition, Mechanical & Engineering etc. We have also grouped the tests into templates.
Approach: Each assessment review starts with a Form input of the Header record into the Table (Test Header), each with a unique reference Test Ref as shown below. The Test_Template i.e. the type of test is also specified using a drop down on the Form.
Please see Attachments 1a and 1b
Objective: Upon saving the Header record, I would like to populate a Table called (Test Results) with the test questions which are contained in another Table called (Test Questions). The criteria as to the range of questions to be imported is the Test_Template field which is a connection.
*The expected results•