automatic creation of a field

[garciasanchezdaniel]

Hello again friends...

• I'm in the edit view of my custom module (created by the builder module) called illumination

1. This module, among other fields, have a field 'client' of kynd relationship, with the module called clients
2. This module will contain many records
3. My intention is that each time you save a record, automatically create a field 'numbers', in the format: clientname_ILUx, where 'x' is a counter

For example:

First record -> clientname_ILU1
Second record-> clientname_ILU2
N record-> clientname_ILUN

What are the steps? I hope your answers
Thank you very much!

[rafael.q.g@hotmail.com]

I do not know exactly for what propose it is needed, but you can dinamically create fields computing a new file under /custom/Extation/modules/Custom_module/Ext/Vardefs/new_file_name.php
This file has to have a content like:

 <?php 
$dictionary["custom_module"]["fields"]["custom_name"] =  array (
    'name' => 'custom_name',
    'type' => 'varchar',
  );  

Then run programatically the repair/rebuild using sugar admin object (I haven't this code now).
After that the new field is created.

[garciasanchezdaniel]

Sorry Rafael...but I don't understand you
Can you put me any example?
Thanks so much!

[andopes]

Hello again friends...

• I'm in the edit view of my custom module (created by the builder module) called illumination

1. This module, among other fields, have a field 'client' of kynd relationship, with the module called clients
2. This module will contain many records
3. My intention is that each time you save a record, automatically create a field 'numbers', in the format: clientname_ILUx, where 'x' is a counter

For example:

First record -> clientname_ILU1
Second record-> clientname_ILU2
N record-> clientname_ILUN

What are the steps? I hope your answers
Thank you very much!

I don't think this is a good approach.

Why to create one field for each record?
What should happen if such table has 1k records? Do you want to automatically create 1k fields? There is no database which support such amount of fields in the same table.

Is there any other information you want to store with respect to client?

Cheers

[garciasanchezdaniel]

Sorry, I think I have not explained this too good...
I want to assign different values, but always assigning to the same field...
I think I can use logic hook, but I don't know implement this yet
I don't know which file I must edit... so I hope your answers.
Thanks

[andopes]

Let us know in detail the workflow behind this feature.

Cheers

[garciasanchezdaniel]

Let us know in detail the workflow behind this feature.

Cheers

I want autogenerate a field called 'number' in order to that each record of my custom module has a diferent number, and in list view of my custom module, I will see all my records ordered by this number

This field will be formed by the value of the field clientname (of the same module) and a counter, beginning in 1

Daniel

[andopes]

My suggestion:
Create a custom field in Accounts called client_prefix, type varchar.
Create an int field in your custom module called client_id
This field client_id will be rendered in screen as client_prefix + client_id.

Cheers

[jmuhly]

So this is a string, right? you want, basically, a string that is a mashup of the client's name, and a counter of the number of records this particular client has of this type.

The logic would have to be some sort of workflow. I.E. when the client field is chosen, a count of the number of records associated with that client would have to be called, with the result, plus one, mashed together with the client's name and an underscore.

Ok so now i've described what you want to do in english words.

Step 2 Describe it in steps.

Condition-client relationship field is filled
Action--count (list of module records who have this client as related) Return Count
field data = 'clientname + "_" + Count'

What's the tools and syntax to do that? I'll leave that to the sugar experts, but hopefully this helps.

[garciasanchezdaniel]

Thanks everybody for your replies.
I solved it by logic hooks!!!
Thanks