I want to store in lookup records .xls file for your c# code. In the code , I 'll just take .xlsx file and use it further. I can create a field with the "File" data type for lookup, but I can't display it in lookup. How to work with such a field in general?

File attachments
Like 0

Like

1 comments

Hi, 

I recommend you to take a look at the attachments detail. When you upload a file to it, in the column "Data" you can see the value that you can use in your code (note, this field would be empty if you store files not in the database). If it format doesn't satisfy you, then you can change it, for example cast('' as xml).value('xs:base64Binary(sql:column("ivf.Data"))', 'varchar(max)'. As far as I know, you cannot store File values in the lookup column, only if you create an object with File column inside and use this object.

Show all comments

Hi All, 

 

I've created a lookup, when I Click "New" I can Add a value to it.

 

My question is: How to add only unique values to the lookup and prevent user from entering repeated value. 

 

Thank You.

Like 0

Like

2 comments

Hi Anas Iyad Ahmad Ibrahim,



For all the records that get inserted into the Creatio table (Objects: section, details, or Lookup) the inserted record is distinguished by the "Id" (GUID Type) column which is a unique identifier for the record.



If an additional column has to be considered into account before inserting a record, then a custom implementation has to be made to validate the additional field value.



Please click, view and select display columns and add Id, and Name. Then Id field will be displayed with a unique value for each record.





BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

Thanks a lot

Show all comments

Hi All,

 

I want to add a record to my lookup but not from lookup page, I want to add it from my section Page, How Can I Do That?

Like 1

Like

1 comments

Hi Community,

 

I want to hide the "+" button shown below, during column setup. The expectation is that the user should only select the current object's columns. This functionality is similar to Customer Portal users as it is not visible to them.

 

 

Is there a way to hide this for normal users also? Any suggestions will be appreciated.

 

Regards,

Sourav

Like 1

Like

1 comments

Hi,

The code for this button is:

{
						className: "Terrasoft.Button",
						visible: {
							bindTo: "ExpandVisible"
						},
						click: {
							bindTo: "expand"
						},
						markerValue: "addObject",
						imageConfig: resources.localizableImages.ExpandImage,
						style: Terrasoft.controls.ButtonEnums.style.TRANSPARENT
					}

It is defined in the schema StructureExplorerViewConfig. As you can see, the parameter "visible" is bonded to the attribute ExpandVisible.

This attribute is located in the schema StructureExplorerMainViewModel and you can override this schema and set any value you want to it based on the needed condition.

Show all comments

I'm just getting started working with the new Freedom UI.  One thing I'm not able to find any information on is if the new Freedom UI supports mini page popups.  If not, is there a something that has been deemed a suitable replacement for that?  If not, any plans on the roadmap to add support for this?

Thanks!

Jeremy

Like 5

Like

5 comments

Hello Jeremy, 

 

Unfortunately, the support for mini pages for Freedom UI is not released yet. I created an idea for our developers to adopt this functionality in the future. 

 

Thank you, 

Igor

Hello Ihor,

 

 

Can you tell me if support for the mini page is already available in version 8.0.6? I can't find any documentation about it.

 

Thank you,

Andreia

Hello Andreia, 

 

We expect this functionality to be available in 8.1.0 version of a system. 



Best regards,

Anastasiia

Anastasiia Zhuravel,



is it possible to use freedom ui mini page from classic view?



Huge thanks!

Solem

hi team,

 

is this functionality enabled now since we already have 8.1.0 version?

Show all comments

How can I establish a connection between SQL Server 2019 DB and Creatio Studio?

Like 0

Like

1 comments

Hello,

 

Thanks for your question. 

 

Here are the guides on how to connect DB for on-site instances:

 

https://academy.creatio.com/docs/user/on_site_deployment/database_serve…

https://academy.creatio.com/docs/user/on_site_deployment/database_serve…

https://academy.creatio.com/docs/user/on_site_deployment/database_serve…

 

As for cloud sites, this option is not available due to security policies.

 

However, we can help to implement any changes in case you provide the script.

 

Please let us know if additional questions arise!

 

Best regards,

Anastasiia

Show all comments

How can I establish a connection between Production DB and Creatio Studio

Like 0

Like

1 comments

Hi!

 

Thank you for your request.

 

I regret to inform you that the connection cannot be established for cloud sites: SaaS is not accessible for the DB user due to Privacy Policy.

 

However, technical support can help implement any changes in case you provide the script.

Show all comments

Strange packages appear during installation another apps (Like SQLconsole). They are empty and when I'm trying to delete them, the error "Application deletion error", appears. What can it be?

 

Like 5

Like

2 comments

Hello,



These packages were created automatically when you launched the application in the Application Hub.



Details on the academy website:

https://academy.creatio.com/docs/release/release-notes/80-atlas-release…



To remove such packages, you need to remove the associated record in the SysPackageInInstalledApp table.

Cherednichenko Nikita,

Thanks!!! 

Show all comments

I'm trying to binding lookup data with section data inside of this lookup. But when it is installed to another, an error occurs and the data section is not bound. How to bind lookup data with data section?

Like 0

Like

1 comments

Hi colleagues,

Please select these data bindings and press install in the "Multi actions" menu.

Will it be successful?

Best regards, Alex.

Show all comments

hello,

I have a query that can we generate any pdf in creatio and fill the detain in the pdf using our Custom feilds .

Like 1

Like

3 comments

Hello,



I believe that your business task could be achieved by this add-on.

Bogdan

Will surely look into this 

Thanks

Hi Bogdan

As far as I have explored Aspose.PDF Addon ,we are not able to create Pdf in studio can you provide some steps how to configure this addon in my Application in Sales.

 

Show all comments