In short, is this possible? For example, I want to require entry of a Contact Type on a new contact entry page, but I want to do it in the UI, not by making the underlying data column a NOT NULL column.

Like 0

Like

2 comments

Dear Jeffrey, 

You can do this with the field validation on the page. Here is the academy article on how to do that: 

https://academy.bpmonline.com/documents/technic-sdk/7-13/how-add-field-validation

Best regards,

Dennis

 

Thanks Dennis!

Show all comments

Hi guys, 

Do you know how to include a space between 2 buttons in an Edit page?

 

 

 

 

Thank you so much!

Like 0

Like

3 comments

Dear Eric,

In order to add a space between two buttons please use custom css style. Please find more information in the article by the link below:

https://community.bpmonline.com/questions/how-add-custom-style-control-page-based-condition

Best regards,

Norton

Hi Norton, thanks for your reply. Actually I applied the following code and now we got spaces between the buttons but unfortunately when we hit the buttons they are not working anymore. Is there any other trick here?

 

 

Dear Eric,

In general, adding custom css style does not affect the working of the buttons on the page. Therefore, most likely the issue is in the code that implement the custom buttons in the section. In order to identify the issue please do the following:

1. Delete custom css style.

2. If the issue was resolved, please read the article about how to add custom css again.

3. If the issue remained, please check the source code of custom buttons.

In order to get an additional information, please contact the account manager regarding receiving the “Advisory hours” service.

Best regards,

Norton

Show all comments
7.11
sales

Hi, 

Is it possible to specify a different attribute (unique attribute from the source table) instead of Name in the Data Import templates for Lookup columns? 

For example, to update existing prices an import to Product Price table must be done. In the Data Import Template for Product Price table, there is a Product (Lookup) column. The name of the product goes in the Product column for bpmonline to identify the referenced product. Is it possible to use Product code instead of Product Name as there may be more than 1 product with the same name but the code is unique across the entire product catalog. 

Regards,

Hatim

 

Like 0

Like

1 comments

Dear Hatim,

You can specify any value as an attribute for duplication check as long as this value is unique.

Best regards,

Angela

Show all comments
7.13_()
sales

Hi guys,

 

Can you please guide me to how to add images in dashboard sections ?

Like 0

Like

1 comments

Dear Nikhil,

It is possible to add an image to the dashboard section only using custom CSS styles. However, the custom CSS styles can be added only to a custom widget in the dashboard. Therefore, in order to add the image please firstly create the custom widget.

Please find more information in the article from the link below:

https://academy.bpmonline.com/documents/technic-sdk/7-12/adding-custom-dashboard-widget?document=&_ga=2.252225801.1861100856.1568022560-1432738620.1562155819

Best regards,

Norton

Show all comments

Hi,

I have the Project detail section included on one of my Account tabs, so that users can see all current and past projects we have worked on with that customer.

The issue is that his Project section detail list includes Project Tasks as well as the Project, where I only wish to display the Projects. I cannot find a way to filter out the Project Tasks from this display and the simple workaround of displaying the Project Task Type in the output is not great, as this only allows the user to identify and not remove. The live filter option is a one time thing and would mean a user has to create the filter each time they load the page up, which is not efficient.

How can I have this only showing Projects?

 

Like 0

Like

1 comments

Dear Mark, 

You can add a filter to the detail in code of this detail. Here is the example of how to do this (you can ignore the part of reading the MasterDetailRecordId and just adjust the filter part to your needs):

https://community.bpmonline.com/articles/filtering-detail-records-based-selected-record-other-detail

Best regards,

Dennis

Show all comments

Добрый день, коллеги!

На нашем коммерческом проекте сильно увеличился размер БД - разрослись системные таблицы.

Подскажите, можно ли уменьшить размер системных таблиц в БД? 

Предполагаю, что возможно очистить таблицу SysProcessElementLog.

Like 0

Like

1 comments

I am trying to used lookup for “VwSysSchemaInfo” which lists the Object’s Name(For example : in LandingType table, column name schemaUid for object lists). But am getting foreign key error like

“SqlException. Foreign key 'FKYLKAi7ejsTUaCmQl1hwk3jQcw' references object 'dbo.VwSysSchemaInfo' which is not a user table. Could not create constraint or index. See previous errors.”

Please help.

I need to have this lookup. Why am I not able to use this. Since its already by implemented in one of the table (LandingType), why is this not possible for custom objects.

Also please help me to use this as a lookup column.

Like 0

Like

1 comments

Hello Sriraksha,

The cause of this message is in fact that there is no possibility to bind lookup to a view table via section wizard - it will result in this error message, but it will work (you can bind lookup to a view table) via configurations and object directly. Please go to configurations, find needed object and column in it, add necessary binding, save and publish the object and you will be able to bind a lookup field to a view table.

Best regards,

Oscar

Show all comments
printables
script task
Javascript
sales

I am trying to generate a printable from the opportunity object (which will be a quote) and attach this printable to an email after generating.

 

I am getting stuck on the generate and save printable script task. 

This is the error I am getting

Terrasoft.Common.ItemNotFoundException: Value "Name" was not found.
   at Terrasoft.Core.Entities.EntityColumnValueCollection.GetByName(String name)
   at Terrasoft.Core.Entities.Entity.SetColumnValue(String valueName, Object value)
   at Terrasoft.Core.Process.UsrlabSavePrintableAndEmailQuote1Custom6.ScriptTask1Execute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)

 

I'm not sure what the issue is. I tried hardcoding the name in the script but that doesn't seem to work either. 

 

My script action that is failing.

var reportService = new Terrasoft.Configuration.ReportService.ReportService();
Terrasoft.Configuration.ReportService.ReportData report = reportService.GenerateMSWordReport(
    (PrintableId.ToString()), ObjectId.ToString(), ConvertToPdf);
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("Opportunity");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("Id", OpportunityId);
fileEntity.SetColumnValue("TypeId", AttachmentType);
fileEntity.SetColumnValue("Name", "ExamplePrintable.docx");
fileEntity.SetColumnValue("Data", report.Data);
fileEntity.Save();
 
 
return true;

 

Let me know if you need any more information.

Also, any documentation where I can read up on this myself. Like the fileEntity variable, or just how this code works in general.

 

Any help is appreciated thanks!

Like 0

Like

1 comments

Hi Tyler,

Implemented this week a very similiar feature throw a business process.

I reversed engeneered this market place app: https://marketplace.bpmonline.com/template/creating-quotes-opportunities

But I used the user task instead of the script task in the processes as I was getting in trouble passing the process parameters to the script task.

 

Hope it helps,

Luis

Show all comments
grid
7.14_()
sales

Is there a good way to get the column headers to remain visible while scrolling through the grid (e.g. on section pages)?  I've tried CSS position:sticky, but it doesn't appear to have any effect with the way the grid is constructed.

Like 0

Like

1 comments

Unfortunately, there is no good way to create sticky header while scrolling through the grid. After freezing header row in the grid all other blocks on the page need to be adjusted in order the page is displayed properly.

Show all comments
7.14_()
sales

Hi all !

 

In a section page, I have some processes that re run from the page using the ‘Run Process’ object.

The problem is that users activate the process before data on the current screen is saved.

I need that when user activates one of the processes in the Run Process, the page will saved automatically before the process is run.

 

How this can be done ?

Like 0

Like

3 comments

Please override the method runProcessWithParameters in the BaseDataView module. Then use messages to save the page before running the process.

https://academy.bpmonline.com/documents/base/7-14/how-work-system-messages

Then debug the "save:" and "onSaved:" methods and find how to use them for saving the page and getting back to the runProcessWithParameters method after saving. 

Hi Eugene

Thanks for answering me.

When you say "Override the method runProcessWithParameters"

Do you mean to copy it to the Schema Section module?

As I could understand the Schema Section inherits from the "Section base schema ( NUI )" that inherits from the "Base data view ( NUI )".

 

I tried to copy the function to the Schema Section and implanted debugger, but it's not activated.

Please advise if I've done something wrong.

 

Oren Diga,

I recommend reading all articles from the development guide before starting development. It will help to avoid mistakes at the very beginning.

https://academy.bpmonline.com/documents/technic-sdkmob/7-12/bpmonline-development-guide

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-custom-client-module-schema

Show all comments