Link fields from Joomla database table to CB so they can be used in CB Lists

The CB Lists capability is very powerful - filtering, sorting, and displaying information in a customizable way - I've used it a lot for my clients. It would make a great stand-alone extension if it was reworked to be able to access all the tables in a Joomla database - including 3rd party tables.

I'd like to be able to connect a few user fields from another extension so I can use those fields in CB Lists.

It seems CB Auto Actions might be the solution - to create those fields in the CB Fields list, then somehow have the corresponding fields in the other extension's table to populate the CB fields. I wouldn't really know where to start to do this.

The other extension also uses the UserID from Joomla Core, so I know that's how they would connect.

The fields cannot be editable in CB and must update with changes in the other extension in real-time so that the CB List is always displaying current data.

I'm currently working with Joomla 3.10.x, but I plan to start updating all my websites over the summer to Joomla 4.x. So whatever I do now, needs to translate into Joomla 4.

I'd appreciate the simplest solution to this - I'm not a coder, but I know how to access my database so I can identify the tables and fields that I need to sync.

Thank you,
Ernie

We'll probably make a generic form builder for CB 3.x once fields are no longer coupled to profiles, which the data could then be used for a generic listing feature. It's a bit impossible right now since fields are directly locked to profiles in almost every way and especially userlists. Note this isn't a guarantee or promise. Just something we might consider.

Your only option right now would be to look into 3rd party form builders as they usually have a means of displaying their data as a table. Alternatively look into extensions specifically for displaying data as they usually have filtering features.

Is CB Auto Actions a possible solution until then? If so, how would I go about doing it?

I don't know how I would code it, but it would involve matching the UserID for each table, then having fields in CB to match those in the other extension, and keeping them in sync.

Does CB Auto Actions do this?

Thank you,
Ernie

You can push CB data to other tables and external systems using CB Auto Actions, but you'll have to entirely code that. You'd either use a Query action if you just need to work with SQL, a Code action if you need to work with PHP, or a Request action if you need to send it as an HTTP request.