Creating T2s from a report
This will display a link to create a new Tier 2 record for each Tier 1 folder.
Go to the record view for a new Tier 2 record and copy the URL. In this example, we used an attendance record with the URL https://apricot.socialsolutions.com/document/edit/form_id/28/parent_id/1806/id/new
In the URL replace the parent ID, in this case 1806, with ',[column],' giving us the URL https://apricot.socialsolutions.com/document/edit/form_id/28/parent_id/',[column],'/id/new
In your report, pull in the record ID from the Tier 1 records.
Open the properties and change Data Style to “Custom Text”
Use the expression below, replacing the URL with the desired Tier 2 record’s URL created in step 2.
CONCAT('<a href="https://apricot.socialsolutions.com/document/edit/form_id/28/parent_id/',[column],'/id/new">Click Here to Create New Attendance Record</a>')