07-21-2008 09:25 PM
Iam very new to Act! customisation, I want to create custom table in the Act like 'name' and 'Date of joining' are the two columns for that table. could anyone suggest me how to do it. Thanks .
07-22-2008 09:13 AM
While the first reply to your post is a good resource if you want to see it in action, your best bet, if you're a developer and have Visual Studio .NET, is to download the VS.NET template for Custom Sub-Entities.
That's where the download is. Follow the tutorial - it's in a .PDF there, and make sure to include all of the references it lists (hint: do a search for the names in your program files/act folder, because they're all scattered around) Once you've done the tutorial, you can change it around a little to get the specific fields you want.
Come back and ask more questions if you still have some after doing the tutorial. It's really not an easy process at all.
07-23-2008 01:26 AM
I had gone through that tutorial and same thing i followed then i have got the sub entity called pets but i wanted add/remove some fields into that subentity. Could you suggest in which class i have to make changes.
07-23-2008 01:55 AM
Here is a short example of how to add and delete fields, hope it helps
Private Sub DeleteField(Byval alias as string, Byval descriptor as Act.Framework.CustomEntities.CustomEntityDescriptor) 'get the fields Dim fields As Act.Framework.Database.FieldDescriptorCollection = ActApp.ActFramework.Fields.GetFields(descriptor) For Each field As Act.Framework.Database.FieldDescriptor In fields If field.Alias = alias Then 'delete the field ActApp.ActFramework.Fields.Delete(field) End If Next End Sub Private Sub CreateField(Byval ftype As Act.Framework.Database.FieldDataType, displayname as string, alias as string, Byval descriptor as Act.Framework.CustomEntities.CustomEntityDescriptor) Try 'create the field field = New Act.Framework.Database.FieldDescriptor(displayname, alias, descriptor, ftype) 'save the field ActApp.ActFramework.Fields.Save(field) Catch ex As Exception MessageBox.Show(ex.Message, "ACT", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try End Sub
07-23-2008 11:20 AM
there are a few applications out there that make table creation really easy. my favorite is from Topline Results. you can see it here:
07-29-2008 11:07 AM
04-11-2012 06:37 AM
If I use a program like Topline Designer to create another table for ACT! do all other users in our office have to have Topline Designer installed in order to see the new data or would just I need it? I'm sure my boss does not want to spend that much money for add-ons after already spending a lot on the ACT! program itself.
We are just trying to add a table for the serial numbers and corresponding data, RMA info, etc. that each customer purchases...so we really don't need a lot of the extra fancy stuff that many of these Add-ons come with.