How do records and pages become linked?

Permalink Browser Info Environment
I just imported a few dozen records into an Advanced Form and wasn't too surprised that the auto-generation for pages didn't apply to an import. I've over it though, what I'd like now is a method to link the records to pages I will batch create. Does such a method exist? Is it an attribute or something that links the two? Or a special table? I'll jump into MySQL if necessary.

I'd like to use the 'associated record' option in the Data Display block to pull the proper data onto the detail page.

Type: Discussion
Status: New
fridayphoto
View Replies: View Best Answer
fridayphoto replied on at Permalink Reply
fridayphoto
I think I found it.

In the table 'sixeightformsAnswerSets', there's a field for 'cID', which should correspond to the page's 'cID'.

The above mentioned table's fields don't have recognizable titles but you can look up the asID's from the link URL on the 'Records' page for the form.

The cID for a page you can get from the page's 'Properties'.

It's hard to say whether it's faster to link or to manually specify the record on each page.
jgarcia replied on at Permalink Reply
jgarcia
Yep, that's pretty much it. There is a method of the sixeightAnswerSet class (found in models/answer_set within the package) called setCID(), but it's not much more than a SQL query to run on the Answer Set object that set's the CID to whatever is passed to it.

You can also specify the associated page in the backend but clicking on the record's details. In an upcoming version, I'll be tying in the page association with records a little more seamlessly that will include things like creating the page on import.
fridayphoto replied on at Permalink Reply
fridayphoto
> You can also specify the associated page in the backend but clicking
> on the record's details

I did already sort out all of my pages but I'm curious, for future reference, how to do it through the backend. When I click on 'Edit' for a record, I get only the fields I setup, no associated page bit.

I'm using Advanced Forms 1.7.4
jgarcia replied on at Permalink Best Answer Reply
jgarcia
It's not on edit. It's when you click to view that record (on the date of submission).
fridayphoto replied on at Permalink Reply
fridayphoto
Thanks so much Justin, that's exactly what I was looking for in the first place. Never thought to click the date ... oops.

Have a great weekend!
jgarcia replied on at Permalink Reply
jgarcia
Sorry - I should probably make it a little more clear!

concrete5 Environment Information

Browser User-Agent String

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.