Forum Discussion

Qrew Captain

7 years ago

Using different forms for ""Editable"" reports

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 dro...

App builders

Ask about Quickbase functionality

Forms

QuickBaseCoachD

Qrew Captain

7 years ago

@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. The form layout is ignored, its just a list of fields really and what report gets used for dropdowns.

ArchiveUser
Qrew Captain
7 years ago
Hi Mark, thanks - yeah, the problem with that is then it sets that dummy list of fields for all grid edit reports unless you override it by making an embedded table or grid edit report "editable" on the form...but once you do that, you can't control what report is used to display the drop down fields' options.
ArchiveUser
Qrew Captain
7 years ago
Though I just realized you said "specifying that form to be used for Grid Edit on some or all reports" - I'm trying to figure out how you would do that for only specific reports and not all of them. See attached picture - it appears to me there that you can only set grid edit behavior to be associated with one form.
QuickBaseCoachD
Qrew Captain
7 years ago
You can set which form is used by report, right?

"Override role settings by report