Using different forms for ""Editable"" reports

Question

I have two embedded table reports on a single form that I've set as "Editable" in the form properties. When I include a related field as a column in these reports, I cannot set a filter on the drop down. I know you can do this if you set the grid edit behavior for the table to use a particular form, but that ties me to one form and one set of fields. Any idea on how to get around this? I feel like either I?m missing something or its just a limitation of the grid edit reports. I?ve seen similar questions on here, but they don?t address this exactly because they?re typically only dealing with setting the grid edit behavior at a table level. Thanks in advance!

chrischris · Answer

You can create a report from scratch to be "grid edit" only. When the report creation dialog box opens that allows you to select what type of report, select "Grid Edit", third option down.

archiveuser · Answer

Thanks for the quick response.&nbsp; The reports I mention above are already set to grid edit report types.&nbsp; When setting up those embedded grid edit reports, I select my desired fields - including the related field.&nbsp; That related field in the grid edit offers no way of filtering it.&nbsp; Unless I'm missing something...again, thanks for trying to help.&nbsp;&nbsp;

chrischris · Answer

I'm uncertain what you mean by 'set a filter'. Do you mean conditional dropdown selection lists? Where the selection of drop down 1 determines what is selectable in drop down 2?

quickbasecoachd · Answer

@Christine,Have you tried making a form which DOES have a drop down list with the filers you want, and then specifying that from to be used for Grid Edit on some or all reports?It is not an obvious thing, but you can create a dummy form which is just really a field list in sequence, and when you use that form for grid edit, then means that the report columns and the filters for drop downs would be taken from that dummy form.&nbsp; The form layout is ignored, its just a list of fields really and what report gets used for dropdowns.

archiveuser · Answer

No, sorry for the confusion.&nbsp; For example, in a regular add/edit form you can set a related field to display options based on a report and its associated filters.&nbsp; The grid edit shows ALL options for a related field, and it uses the 3 record picker fields that you set in the advanced table properties.&nbsp; The grid edit report will use a particular form if you set the grid edit behavior in the "Forms" section of the table to use a particular form to determine the fields that show up.&nbsp; That won't work for me because I can't have all the grid edit behavior tied to one form because I need different fields in the editable forms to be displayed.&nbsp; It seems to me that this is just a limitation of the grid edit reports further complicated by the "Editable" option in the form settings.&nbsp; Hopefully that makes sense.&nbsp;&nbsp;

Forum Discussion

Using different forms for ""Editable"" reports