Limits of page reference fields in the admin

[DrQuincy]

From a database perspective page reference fields should scale quite well and there's always the option to build a custom table managed with hooks if you need something ultra fast so you have control of the indexes.

But, in the admin, is there any field type that scales well? I've tried them all out and from what I can see, all page reference field types and input types, do not have the option to show your page references in a searchable, paginated lit loaded by AJAX; they all go in a single list. I can imagine this getting problematic once the number of page references gets moderately big.

Is there such a thing? What do you do if you have 100s of references, 1000s of references or more? At what point are the standard page reference fields no longer an option?

[virtualgadjo]

Hi,

if your page reference field is used for a single page selection, you may choose "page auto complete" in the input->input field type select, it is ajax powered and works very well 🙂

the only big difference is that you have o know at least 2 or three letters of the page title you're looking for
it works great too with a hook (custom php code) allowing you to select several parents, templates and so on if needed

have a nice day  

[DrQuincy]

Yes, that's great, I have used that, thanks. I'm particularly interested in managing 100s to 100s of references.

[Jonathan Lahijani]

I agree with this.  A new type of multi-select inputfield for page references for advanced use cases would definitely help.

I know Shopify has some unique, purpose-built multi-select fields (like when choosing products/variations).  But it doesn't let you search options that have been specifically selected.

I didn't see anything generic from CMSes like Payload, Statamic, CraftCMS, Kirby or Laravel Filament.  Have you seen anything in any other systems that solves this well?

[Jonathan Lahijani]

@DrQuincy Here's a video of a concept field I made called InputfieldPageModalSelect.  Let me know your thoughts and suggestions!