How can I use multiple fields for a title?

ERPNext
1

I’ve been running around in circles how to concatenate two fields together for use in the title of a doc. All I’m trying to do is get field first_name, and field last_name to look like, say first_name is “jon”, last_name is “doe” I want the resulting title to be “jon doe”. how can I do this?

2

Into the options of the title field put

{first_name} {last_name}

2 Likes
3

Can title be a hidden object?

4

By default it is hidden property, why do you ask ‘Can’?

image
image523×632 13.1 KB

5

Hi @max_morais_dmm

Just tried this in V13 but it returns an “Invalid Data Field” error

Any other suggestions pls?

1 Like
6

When I put it in the options, I have the error:
Title is an invalid Data field.

Only Options allowed for Data field are:

* Email
* Name
* Phone
* URL
* Barcode

I have same problem, like author

7

Do you find solution?

8

I need help with that.

9

Still doesn’t work as far as I’m aware. You may need to resort to Custom Scripts

1 Like
10

I need just title in format like this
{last_name} {first_name}
howto create Custom Script for it?

11

Try this. Make Title field as Data fieldtype and include this in your .py file.

def validate(self):
        self.title= ' '.join(filter(None, [self.last_name, self.first_name]))
1 Like
12

Thanks, but will it works after erpnext update? Or Should I insert it something else?

13

Can I use it through app/server-script ?
Or how to do it and save update erpnext?

14

{fieldname} in option or default not working for v13. The documentation needs update.

15

Hi @max_morais_dmm
Can you check whether this still works in a newer installation you have access to (ideally V13)?
What you are suggesting is exactly what is described in the documentation: Document Title with multiple fields

For me this approach does not work. This is what I set:

image
image1920×861 32.1 KB

This is what I get in the doctype:

image
image1006×208 7.72 KB

Did this break in the meanwhile or do I do something wrong?

(I am on ERPNext: v13.49.4 and Frappe Framework: v13.51.0)

16

While the read-only field type seems to be broken (at least on my version), one can circumvent it and concatenate fields using the HTML field type. Then one will need to use Jinja tags. They are formatted slightly differently but not very complicated. In my example above it would be {{doc.bank}} {{doc.company}}.

(no idea whether I made something wrong with the read-only fields or whether there is a bug in newer versions.)

1 Like
19

in current situation this is only one solution which working… :frowning: