Help with formula (maybe)

[Zurdic]

Hi,

Im created field of type varchar and field of type text, what basically want to do is connect multiple fields into one:

(don't cate about booking name for now it's same as booking number)

But booking_test should be booking number-First name

How do I connect those?
BookingTest is type of text

[shalmaxb]

You need the formula string\conactenate, like so:

cBookingtest = string\concatenate(cBookingNumber, ' ', cFirstNname);

cBookingNumber and cFirstName must be of type string (VARCHAR or TEXT). I doubt, that cFirstName is. But you might try.

[Zurdic]

Is there any way how to connet auto increment int + text/varchar cause booking number is auto-increment INT ant first name is text,

Final should look like this: (datetime in format "YYMMDD") - (int) - (bookingnumber) Firtstname Lastname

also how to make from date which looks like this 24.5.2024 create this 240524? (I need this for that formula also)

[ChrisSka83]

Try this formula.
You just have to adjust the field names.
dateStart is the field where the date is in, you have to change that.
int -> auto-increment INT
and the fields for first name and surname.
And at the very front the field in which the formula is to be written.

​
name=string\concatenate(datetime\format(dateStart, dd.mm.yyyy),' - ', int,' - (',bookingnumber,') ',contact.firstName,' ', contact.lastName); 

[ChrisSka83]

For the format of the date of course your formatting, I only copied mine.

dateStart, yymmdd

[Zurdic]

Hi,

Okey it looks better but still doesn't look as we need it, this is how ti looks now:

and I need that booking_test look like this 240909-3-00039 FirstName LastName

[Zurdic]

This is current formula

[ChrisSka83]

You must note that there are 2 different fields for the date.

In the standard system, these are dateStart & dateStartDate

dateStart also contains the time
dateStartDate only the date

Have a look at the field overview of your entity to see if you have a field called cArrivalDateStart

[Zurdic]

We have also with the time cause we need, when the customer will come at a certain place.

Is it possible to show it only with date? Or I have to make another field and that field add to that string, if it makes sense.

And If so, can I add field to be only visible in entity manager/layout manager and not if you are making opportunity (if it makes sense).

[ChrisSka83]

You already have the fields.
Let me take the examples from your screenshots

https://forum.espocrm.com/forum/developer-help/109773-help-with-formula-maybe?p=110071#post110071

Arrival Date -> 09 Sep 00:00
Departure Date -> 12 Sep 00:00

dateStart -> 240909 00:00
dateStartDate -> 240909

now enter Arrival Date -> 09 Sep 10:00
you get with dateStart -> 240909 10:00
with dateStartDate -> 240909

[ChrisSka83]

It is also possible that you have named your date fields differently. You will have to adjust it accordingly.