Xataface Forums

Hi Scott,

This would be a good feature to have.Ê I have thought about possibly making an alternative "relationship" view for certain types of relationships, so that instead of showing a list of related records, it shows a checkbox group of all possible related records with the related ones checked.Ê I have not done this yet though.

In the coming version of dataface, however, I have implemented an "Update Set" form that allows you to apply bulk changes to multiple records at once.Ê This could be used to set the "category" field, say, of a whole group of records all at once.Ê However it won't help if it is a many-to-many relationship.

-Steve

Code: Select all

action:delegate=related_records_checkboxes


The grid widget is a special, compound widget that provides a spreadsheet-like input option for entering related records. This widget can only be used on transient fields\footnote{Transient fields defined in the fields.ini file but don't have a corresponding field in the database table. The are used to provide the user with input options that would not otherwise be available}, and it requires that the relationship directive be set to reference an valid relationship.

As an example, suppose we wanted to be able to edit the profile's Posts in a grid widget on the Profiles edit form. The Posts relationship is defined in the relationships.ini file. We would begin by adding the following to the Profiles fields.ini file:

\begin{verbatim}
[Posts]
transient=1
relationship=Posts
widget:type=grid
\end{verbatim}


This would cause a grid widget to show up on the Posts edit form. It allows the user to enter multiple posts at once. Let's look at these options a little closer:

\begin{enumerate}
\item \textbf{transient=1} - This indicates that this field does not have a corresponding column in the table, and we know that it doesn't. It let's Xataface know that this field definition is not a typo.

\item \textbf{relationship=Posts} - This indicates that this widget will be editing records from the Posts relationship.

\end{enumerate}


One thing to notice is that this grid contains all of the columns from the Posts table. This may be a bit of an annoyance, so it is possible to explicitly specify which fields should appear by way of the widget:columns directive. For example if we want the postTitle, and postContent fields to be included in the grid we would adjust our fields.ini definition as follows:

\begin{verbatim}
[Posts]
transient=1
relationship=Posts
widget:type=grid
widget:columns="postTitle,postContent"
\end{verbatim}

Code: Select all

$out = str_replace("</label>","</label><br>",$out);