I am looking to consume my own or an external API that returns a JSON response and embed an IFRAME inside a Creatio Freedom UI page to display the relevant data.
My Goal:
Call an API that responds with JSON data.
Display the API response inside an IFRAME in Freedom UI.
Ensure the IFRAME updates dynamically based on API data.
My Questions:
What is the best way to embed an IFRAME inside a Freedom UI page?
How can I dynamically set the IFRAME's src based on API response data?
Are there any security or CORS restrictions I should be aware of when using an external API?
If anyone has experience implementing this in Freedom UI or has sample configurations, I'd love to hear your insights!
However, an IFRAME cant just display data from an API. An IFRAME simply embeds another page, it would be the responsibility of the page you're embedding to retrieve and display the API data.
However, an IFRAME cant just display data from an API. An IFRAME simply embeds another page, it would be the responsibility of the page you're embedding to retrieve and display the API data.
The error you're encountering is related to your system being unable to find or load the e_sqlite3 library. This can be caused by several reasons. Please note that this issue is not related to the Creatio system itself but rather to a Microsoft component.
This article might help you: Microsoft.Data.Sqlite library 'e_sqlite3' not found:
Below are a few steps that may help resolve the issue (please note that these are general recommendations, and since the issue is related to Microsoft components https://www.nuget.org/packages, you might also find assistance on forums or by contacting Microsoft support):
1. Make sure the e_sqlite3 library is present.
2. Install or update the SQLitePCLRaw.bundle_e_sqlite3 package. You can do this via the NuGet Package Manager using the following command:
3. Ensure that your target platform is compatible with the library. For example, if you're building for x86, make sure you’re using the correct version of the library (x86 or x64).
Installing or updating the package via command line (cmd):
1. Open the command prompt: On Windows, press Win + R, type cmd, and press Enter.
2. Navigate to your project directory: Use the cd command to change to the folder where your project is located.
For example, cd path\to\your\project
3. Install or update the package: If you have NuGet CLI installed, you can run:
nuget install SQLitePCLRaw.bundle_e_sqlite3
However, if you're using .NET Core or .NET 5/6/7, it’s recommended to use the dotnet CLI instead:
dotnet add package SQLitePCLRaw.bundle_e_sqlite3
This command will automatically add the package to your project and update the .csprojfile.
Example commands:
1. Navigate to your project directory: cd C:\Projects\MyApp
2. Install the package: dotnet add package SQLitePCLRaw.bundle_e_sqlite3
After successful execution, dotnet will download and install the package. If everything goes well, you’ll see a message confirming the package has been added to your project.
I have a master record and a detail where I allow inline editing. Making changes on the detail triggers an update on the master record. Because the table behind the master record has live updates, the changes are immediately reflected on the master record.
All that logic works fine. The issue I have is that if the user makes changes to the master record and then changes to the detail (like adding a new detail, deleting or editing an existing one,) the changes on the master record are not saved,.
Is there any way to save the master record when the user saves the detail changes?
Im trying to save a script task in the open process of a lookup but when I try to save it the next message appear: An item with the same key has already been added
And i can´t save the process. I already generate all schemas and compile. But i still have the same problem
Everyday at 11PM I get the same error notification in my Notification panel:
Account not found with IdentityId "".
With what I could see it was generated from a business process called "Lead generation. Сonsistency check" in CrtSocialLeadGen package. What can I do to fix this issue?
The system message you are encountering is related to the out-of-the-box process “Lead Generation: Consistency Check.” This message occurs when the system cannot connect to the service to verify that all leads have been successfully entered.
You can disregard this message if you are not utilizing the Lead Generation functionality. The process executes even if the integration with services like Facebook or LinkedIn has not been configured.
If you prefer not to receive these messages, you can deactivate the “Lead Generation: Consistency Check” process in the process library.
Thank you for reaching out regarding the issue you’re experiencing.
To resolve the problem, please try the following steps:
Open the page in a different browser.
If the page loads correctly in another browser, clear the cache and cookies in your original browser and check the UI again.
If these steps do not resolve the issue, please contact Creatio Support at support@creatio.com. Our team will be happy to assist you with a deeper analysis of the problem.
I hope this helps. Should you have any further questions, feel free to reach out.
i've already tried to reload it on another account on another laptop and it still fails to save contact business rule even though it says successfully saved
I have add a button on the contact page in order to create an opportunity :
When you click on "Créer une opportunité" it launch a process which open a preconfigured page, the user select the "Besoin client" and then click save. Next i'd like to open the new record.
So in my process :
the opportunity page opens but it closes automatically.
i have an issue, I have two fields: "Start Date" and "Duration". When I input the "Start Date", I want the "Duration" field to automatically calculate the years and months of how long the person has worked until today. How can I solve this? And can I use a business rule to solve this problem?
Hi, thanks for your answer, sorry but i still confused, For example, I input field a is 1000 and field b is 2000, for field c will be filled automatically by adding field a and b to 3000, is that possible? And what is the step?
as of version 8.2.2, you can use the new business rule formula feature of the "set field value" action.
Before that, you would either create a business process that does the calculation (if live updates are enabled on the entity, the result will immediately show up on the form after saving), or programmatically, as Oleksandr has described it.
We are currently working on adding a filter to a custom section within our mobile application. The object has a lookup column named "Community," and our goal is to filter the records such that the "Community" value matches the current user's associated community. The relevant field on the "Contact" object is the "Primary Community."
We are familiar with the process of applying filters to mobile app sections by leveraging the out-of-the-box (OOTB) features of Creatio to configure the web page and then merging the generated code into the mobile app page. However, the specific condition involving the current user’s community seems to present a more complex challenge.
We would greatly appreciate any guidance or suggestions you may have for implementing this filter condition efficiently.
Currently, this functionality is not available in the standard Creatio solution and we have a task to implement quick filters in the Creatio mobile app for the R&D team. As a workaround, to achieve your goal, you can try the following approach, in which a quick filter is added to the page by the “Community” column and the user can select the appropriate value:
Here is an example of code for page MobileCalendar_ListPage for filter on first tab 1) changes in viewConfig - "type" : "crt.Screen", "header": [{ "name": "My_QuickFilter", "type": "crt.QuickFilter", "filterType": "lookup", "config": { "caption": "Community", "icon": "person-button-icon", "iconPosition": "left-icon", "entitySchemaName": "Community" } }],
Currently, this functionality is not available in the standard Creatio solution and we have a task to implement quick filters in the Creatio mobile app for the R&D team. As a workaround, to achieve your goal, you can try the following approach, in which a quick filter is added to the page by the “Community” column and the user can select the appropriate value:
Here is an example of code for page MobileCalendar_ListPage for filter on first tab 1) changes in viewConfig - "type" : "crt.Screen", "header": [{ "name": "My_QuickFilter", "type": "crt.QuickFilter", "filterType": "lookup", "config": { "caption": "Community", "icon": "person-button-icon", "iconPosition": "left-icon", "entitySchemaName": "Community" } }],