I came across this today, regarding renaming the tables:
I have no idea if it's safe or not, particularly because I don't know what the dependencies are or how to find out what they are. Also, I'd still need to rename columns as well in order to do what I need to do.
Anyone have any ideas?
My snippit is to change the DB TABLE name, not the advanced name for developers...you might have to talk to support to get a script to do that. I'm sure it's doable...
This is one of my main SF Forms gripes, the naming sucks. Way way back, those autogenerated (totally crappy) dev names used to be what showed up on the EXPORTS, not sure if that's still the case, but maybe.
What needs to happen is a Regex needs to run as the user types, like on creating a page, and the Advanced name "Suggestion\Default" needs to be based on the Name\Title, not the ID or Control type...it's just insane this hasn't been addressed yet. I mean there's always something to address, but this is (aside from no permissions) a HUGE problem with forms thats inconsistant with the rest of the CMS.
I just tell forms editors to always open that up and remember to set the "developer name"...it's insanity. Heck even I forget to do it sometimes...like 10 widgets on a page, maybe I forget on 1....and it's set for life.
So is there no way to change the column names?
The reason I ask is because we have a script that runs periodically that hits a database, with a given table, and with given fields, and pulls data from it. We'd like to just set up a form, with corresponding table definition, with the same names so we don't have to ask anyone to change anything about the script, with the exception of the access info and db name. Is this in any way possible? Or do we simply need to have someone re-write that script to reflect whatever those table column names are?
The problem isn't that he doesn't know about that, it's that it's already set the once and borked his DB table with pointless generic names like form_text_box
In database there are fields name like form_text_box__c011 in form response tables ?
so my question is that how can we know that this is column is used for first_name or last_name etc. is there any link for these type of fields in database .