I feel like this is basic and I’m just missing something real simple. I added a field is studio and I am able to see it in Detail View and Edit View and add data no problem. But we use quite a few custom PHP files where we use SQL and my new field doesn’t show up in my SQL queries. The column is obviously in the table because I can save to it in the UI but for some reason I can’t access via SQL. Any thoughts?
Hi,
Your custom field is not put in the main table of the module, but the _cstm one (e.g. contacts_cstm). You can join those tables on the columns id and id_c.
And there it is! I knew it was something simple. Thanks you very much.