Your account attachments/files could be using one of two file locations/objects. With Freedom UI a generic " attached file" object was introduced that could be used with any object. However, many objects have specific file/attachments objects, such as "Account files", or "Contact files" (sometimes those are named "File and link of account"). Make sure that you're using the correct object based on what you have on the screens. To check this, open the page in the designer and click on the attachments list, you'll see the object the page is actually using there in the "File storage location" property. 

Ryan

Hello, 

By default, Creatio provides a plugin to be able to upload only in Word format.
https://academy.creatio.com/docs/8.x/no-code-customization/category/pri…;
https://academy.creatio.com/online-courses/article-courses-18

PDF conversion in printables is available after installing this marketplace app https://marketplace.creatio.com/app/asposepdf-connector-creatio. The first 150 conversions are for free, but other conversions require additional payment (prices are available here https://purchase.aspose.cloud/pricing). 

So for test purposes, you can use the free 150 conversions provided in the app. 

We have already registered the idea for our R&D team to implement this functionality in further releases. I will assign your case to this project in order to increase its priority.

Best regards,
Ivan

Besides, this aspose means that your document will go through some 3rd-party service, that is not acceptable by many customers security polices.

So, it is extremely necessary to have this functionality inside Creatio system

Vladimir Sokolov,

Yes, the security issue is often brought up by our clients/prospects too !

Damien

This issue has years!

Clearly the less work to customer need ratio in the Creatio dev pipeline

I hope this is the time 

We've also had problems with the conection with aspose, besides the security issues, actual failures at certain time

Is the role that is being set using a formula? If so, that formula looks incorrect.

Hello.

I tried to do replicate the same situation. Activity table has a column SendDate which might be null. In business process i created a script task with the following code:

The result i got:

The values of SendDate columns in my Activity table were all null. All these values became the min value of datetime (1/1/0001 12:00:00 AM).

Your error message says that the datetime type in SQL Server has a limited range for dates it can store, specifically from January 1, 1753, to December 31, 9999. In .NET, the default value for DateTime is DateTime.MinValue, which is January 1, 0001. This default value is far outside the valid range for SQL Server's DateTime type.

After analyzing source code you provided i suggest taking a look at those lines of code and changing your sql command parameter types to SqlDbType.DateTime2:

insertCommand.Parameters.AddWithValue("@usrDate"...
insertCommand.Parameters.AddWithValue("@usrStartTime"...
insertCommand.Parameters.AddWithValue("@createdOn"...

Hope this helps

Hello!

Unfortunately, it is not possible to trigger the process after successful logging due to how new sessions are added to the system. They are not adding through Entity logic, which is why they will not trigger process triggers.

For example, by reading from User Session object, you can find the last authorization to the system (and other information about this session):

But such a signal will not trigger due to the behavior that I mentioned earlier:

Such a solution is possible only by using some custom development.

Kyrylo Atamanenko,

Thanks! 

can I ask you In the business process I am creating, do I use an element  (modify data) that updates the user's permissions (Organizational roles). is it possible? If possible, what object is this? 

The Zapier connector for Creatio is somewhat limited and does have some problems. Another option, plus much more reliable route (in my opinion) is to simply use Creatio webhooks. See https://academy.creatio.com/docs/8.x/no-code-customization/base-integrations/webhook-service-integration/overview

Zapier can easily send webhooks to Creatio, plus the use of webhooks is much more flexible and allows for a greater set of objects and fields to be used since the Zapier connector is limited to just a couple of objects (last I checked). 

Since your system looks like it's self-hosted based on the URL, assume you might need to contact support for getting webhooks setup for use.

Ryan

Hello,

You need to create one-to-many relations between these objects. To do this, you need to create a lookup column in each object that will refer to another object. After that, you will be able to use filters and relationships to display and customize the necessary lists.
You can't do it using no-code elements because this connection is set up at the object level.

Hello,

Here is an instruction with which you can add your own custom icon: 
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/front-end-development/freedom-ui/remote-module/requirements-for-icons

Best regards,
Ivan

Ivan Savenko,

Dear Ivan,

I mean APP Icons, When I'm on App Hub and want to add a new app and assign it an icon, I can just access predefined icons. 

I need to know, if like in CLassic UI, I can upload my own.

Thanks

Ivan Savenko,

Dear Iva, Hello Colleagues, some idea how to do what I'm asking? is it possible?

Julio.Falcon_Nodos,

I believe you can add the image bytes into the SysModule record, however, I don't know of any easy way to do this without creating something to load the bytes into the table. The no code tools only allow for selecting from the list of choices.

Ryan

Ryan Farley,

Thanks Ryan,

In Classic UI this were a daily task (In Section Wizard), I expect in some near future it could be available on App Wizard also to Freedom APPS

Regards,

Julio

Hi Julio

The AutoNumber value is stored in a Sequence in the database (Postgres Sequence for cloud instances).
For example, you can get the last value of a sequence using this query:
SELECT last_value FROM "Contact_RId_seq".

To reset a sequence, you can use the following query:
ALTER SEQUENCE "seq_name"
RESTART WITH 0;

Hope this helps!

Mohamed Ouederni,

Thanks,

1.- But, can I access this data from a process? 

2.- Have access to this object from a process, 

3.- How to determine which sequence correspond with a specific section?

I have not visible this table from a Creatio Cloud instance, I've enabled an autonumber field in contacts, for example, and not available the table mentioned by @Mohamed, see it

Hi Julio

1- You can run a custom SQL query from a Task Script.
2- No, you don't have access to the sequences.
3- The sequence name is identical to the column UId. You find it in the source code tab of the Object in Advanced settings.

Thanks!

Hello Julio,

Once you add the autonumber column, you'll need to get the UId for the column. You can open the object then select "Open metadata" under the Actions menu, the find the column and get the Guid for the UId. 

That is the name of the sequence in the database. If needed, you can use that to get the next sequence value using this where the guid is the UId for the column (for Postgresql):

SELECT nextval('ed398640-de69-842b-c50c-6c673da5aa98')

Then to reset it to 1 again you can use this (if needed, replace the 1 with whatever number you want the sequence to start at): 

SELECT setval('ed398640-de69-842b-c50c-6c673da5aa98', 1, false);

To do this via a process, you'll need to do a direct database connection and you'll use a script task, see https://customerfx.com/article/executing-direct-sql-statements-in-a-process-or-configuration-web-service-in-creatio-formerly-bpmonline/

Lastly, if you want to get what the last value/number used from the sequence was, you can use:

SELECT last_value FROM "ed398640-de69-842b-c50c-6c673da5aa98"

Ryan

This is No Code ? In Classic UI was sImple, why in Freedom I need NASA certification to do this?

Julio.Falcon_Nodos,

Yes, for now to reset the value it requires the database update (either by Clio, SQL Executor, or asking support to update the value). I do hope we'll get a UI to manage that at some point. The prefix is also set at the object level now, instead of a system setting - so that now requires an object publish to change rather than updating a setting.

Ryan

Ryan Farley,

Thanks for your support Ryan

Julio.Falcon_Nodos,

Hello,

Yes, unfortunately at this moment there is no possibility to reset sequence using No Code. But you can always contact support, and we will be happy to do it for you. We have created a request to the responsible development team to add this functionality in future releases.  

Antonii Viazovskyi,

Thanks Antonii

Hello!

Please publish the ContactCommunication object and then try to run all previous actions.

Kyrylo Atamanenko,

Hello, 

After publishing I get the same error