I have a custom field that I created programmatically for Employees. I added it to the detail and and edit views through Studio. But when I try to save an employee record the value for my custom field isn’t saved, but the other fields are.
The field is just a regular text field. I know that the employees module uses the users table, so then I tried creating it as a User field instead, but it still doesn’t work. Here is the field def:
I forgot to mention that I tried that. But what do you mean by the repair should be query free?
This time I did the repair, I scrolled to the bottom and I noticed that it said the database was out of sync with the customizations… Not sure why that happens? Anyway I clicked execute on that and it said I had a syntax error in the query… so I guess the problem was the custom field was never being created in the database.
So looks like you’ve pointed me in the right direction anyway, thank you!
Well the reason I created it programmatically is I guess because I find Studio to be a bit clunky, and I just prefer to know exactly what I’m doing. Anyway that being said, I just created another field in Studio (but under Employees, not Users this time) and it works completely fine. Definitely something strange going on, but I guess this is a good enough work-around in this case.