[SOLVED] How can I use the User's custom fields in an ODT document template?

Developing for Dolibarr
, ,
1

I have created 2 extra fields which works like a charm in the User’s form.

Now I want to place these 2 extra fields in a customized ODT template, but I don’t see the information on how to call these fields in this handbook: Create an ODT or ODS document template - Dolibarr ERP CRM Wiki

My current Dolibarr is 20.0.4

Any help or ideas is appreciated.

Thanks.

2

Where on the template do you want to place the 2 extra fields, and would you mind sharing the extra field definitions?

I would also like to see an object where there are data in these extra field. A screenshot cutout would be fine.

3

@jonbendtsen thanks for your quick response.

The Extra Fields were added to the user’s module:

extra-field-1
extra-field-11420×1039 67.5 KB

extra-field-2
extra-field-21386×981 64.1 KB

This is an example of user extra-fields with data (please notice “NO PERTENECE A UNA DIRECCIÓN” and “NO PERTENECE A UN DEPARTAMENTO” is an option in the extra-field.

user-fields
user-fields1104×563 42.6 KB

Here you can see the area where I want to place the extra-field 1, which must contain the “NO PERTENECE A UNA DIRECCIÓN” text.

document-template-sample
document-template-sample1478×524 56.6 KB

I don’t know how to call these user’s extra-fields.

Can you please guide me?

4

I don’t use extrafields on users. I do use them on proposals, orders, invoices. + on Projects.

I have them both on the object itself and on the object lines.

I don’t always display the content of the extra field on the PDF.

image
image558×530 36.1 KB

As for the complementary attributes on lines, aka extra fields on lines, I only use the value 4.

Maybe this can somehow help. If I click send email on one of these objects and I click the little encircled i next to Message then I get a popup with a lot of variables I can use for inserting data into the email. Maybe it is the same with ODF templates?

image
image401×368 18.4 KB

5

My next reply will probably not be until Friday. Also, when you figure it out, please consider writing in here how to do it.

6

@jonbendtsen, thanks for your support.

Your previous response gave me the idea and I thought that, if we can call the variable names with a standardized name, we should be able to do the same with the user’s extra-fields with using the same logic as per in the other modules.

So I went for:

  1. {myuser_options_subdireccion}
  2. {myuser_options_departamento}

The document template is now:

imagen
imagen928×397 37.6 KB

I am happy with the results.

I guess this should be in the Wiki, but it is not, and I hope this may help somebody in the future.

Thanks a lot!

1 Like
7

GREAT you found a solution. Could we get you to make a step by step guide and post it in this thread such that others might find it?

8

Hello my friend,

Sure! I can. Just allow some time and I will return with a useful handbook.

Thanks!

1 Like