Custom ORM expressions - unable to call

[bandtank]

Thank you for the help. It works now. Here are the final implementations in case anyone else would like to do something similar.

custom/...

[bandtank]

FYI for anyone who may come across this - I am currently working on a custom function for the ORM. When it is done, the details will be here.

[bandtank]

EDIT: I submitted this response before I saw your comments. Thanks for the help. I will review the information now.

---

Some progress has been made,...

[bandtank]

Notably, the function is also not available in the GUI:
...

[bandtank]

I am writing a new ORM function to convert timezones by name. However, I can't figure out how to implement the instructions here regarding the creation...

[bandtank]

I eventually got the expression to work, but it is not as good as the custom report. There does not appear to be a date function, so it may not be possible...

[bandtank]

For anyone who may be interested, it is possible to do this directly with SQL, which avoids the timezone issue. More would need to be done to use the...

[bandtank]

I couldn't get the expression to work. I built a custom report instead. Unfortunately, I had to use a fixed timezone offset, so this is likely to be wrong...

[bandtank]

There are two datetime fields in my entity called dateStart and dateStartBill. I need an expression that returns true if the days are not equal. For example,...

[bandtank]

The fundamental problem is the options array that is passed to the backend hooks cannot be modified from the frontend. To work around that, headers must...

[bandtank]

Unfortunately, this is the best I could do after spending several hours tracing API calls to the backend. If I find a better way, I will let you know....

[bandtank]

Add the relationship definitions to the CAddress client definition:

custom/Espo/Custom/Resources/metadata/clientDefs/CAddress.json
...

[bandtank]

Starting with the CAddress entity definition, I added six fields and three links:

custom/Espo/Custom/Resources/metadata/entityDefs/CAddr...

[bandtank]

In Espo 9.3, I created an entity called CAddress to hold custom address records. The new entity comprises an address field and two decimal fields for...

[bandtank]

The information in the first few comments of this post is no longer applicable. I will add instructions for Espo 9.3+ below this comment.

[bandtank]

For my use case, I may need to make the process more complex at some point.

[bandtank]

I found another issue. Hopefully the code is completely correct now. The above code seems to be right except isModalEdit.

Editing an event...

[bandtank]

Alright, I figured out part of the issue I had originally. actionSave from views/edit.ts works differently than actionSave in modals/edit.ts. The former...

[bandtank]

The following code does not work, but the behavior is a little bit better:

              return this.view.save({
                headers:

...

[bandtank]

Thanks for the tutorial. Do you know how to continue saving the record from the error handler? I can't figure out how to successfully save and then close...