I have a lookup field on a detail (List of VAT options with an added column for the % values), im trying to use these now to calculate a value, how do I access the other column? I can access the VAT Code using this.get("UsrVatCode"), but want the associated column which as the % amount.
var lookupId =this.get("RecordColumn").value;
var esq =this.Ext.create("Terrasoft.EntitySchemaQuery", {
rootSchemaName:"INSERTOBJECT"});
esq.addColumn("Insert Object column you wish to view");
esq.getEntity(lookupId, function(result){if(!result.success){this.showInformationDialog("Error");return;}this.showInformationDialog(result.entity.values.Column You wish to view);}, this);
This is the code that I used to get it working, if anyone needs it.
var lookupId =this.get("RecordColumn").value;
var esq =this.Ext.create("Terrasoft.EntitySchemaQuery", {
rootSchemaName:"INSERTOBJECT"});
esq.addColumn("Insert Object column you wish to view");
esq.getEntity(lookupId, function(result){if(!result.success){this.showInformationDialog("Error");return;}this.showInformationDialog(result.entity.values.Column You wish to view);}, this);
This is the code that I used to get it working, if anyone needs it.
Im trying to create a calculated field to show a total of all records from a detail on a record, ive looked into using sql views, however I'm not sure if that would work as you cant filter by the record I don't think, are there any code solutions or anything similar?
You can try creating an integer column in the page (and in the object that this page represents) and create a business process that will change the value in this column once the record is added to the detail (or decrement once the value is removed). This way you can create the logic without additional code that will save resut in the server.
If you still want using the code - something similar is the functionality of the order product detail summary (that displays the number of products in order, can be found on the order page in the "products" tab). This logic can be found in the updateSummary method from the OrderProductDetailV2 from the Order package.
This is a Piot Table, connecting contact and labels objects.
We are expecting that, all label information for all contacts will be saved in this Object "UsrContactLabels", after adding labels and saving the contact page, when we refresh the page it does not save it in object and after refreshing this field is empty.
We added multiselect element on Contact Page:
MultiSelect values are Labels from Lookup (sceen below):
Hi Yevhen, I made new Server and added Multiple Choice as it was in documentation. I have same problem with saving data. There are not any error in console , after chosing multiple Choiche values "Labels" and saving Contact page, but after reloading the page the data is not saved and Labels are deleted so its empty .
When I use the former method, I get the same issue. I can select data in the field, but Creatio will not save it. When I use the method from the instruction, everything works as expected.
Could you please test the method from the instruction? Is using a different method required in your case?
The best way of doing a business process around the web server would be using the element "Call web service". Regarding the situation, it would be better to start your web server via this element.
we are created rest webservice with username as system setting(Paramater) it was coming in Bpm and password(it was showing an error while selecting parameter as system setting) as request parameters and get response as Token for these process we need to create business process.
The best way of doing a business process around the web server would be using the element "Call web service". Regarding the situation, it would be better to start your web server via this element.
I really need urgent help/suggestion in the below scenario-
Scenario-
Candidates resumes are attached in the Contact attachments and I need to stream this file to 3rd party resume parsing platform which can parse the resume/CV and send back the response.
My Findings -
I found a few resume parsing platforms to which If I can pass either file url/file/base64 and then it parses the information.
I also tried to pass the data in the "Data" column of the contact attachment table directly to the parsing platform but it returns an error - "Unable to decode encoded file data"
Challenge -
Not able to read file data from attachment as base64 and convert it to string.
This is the URL that is called when you try to get the attachment from the UI. d95c76f6-64bc-444c-9bfc-1b9cfd4f06e0 is the UId from the SysSchema table representing the object where the attachments are stored (ContactFile, AccountFile, FileLead etc) and the eba29d21-2922-4094-b996-f5c18ee025d1 is an Id of the actual attachment.
This should be also received using some program call (like some integration) as either a plain text or the set of bytes (should be tested). Then the content can be encoded\decoded using something like this https://stackoverflow.com/questions/11743160/how-do-i-encode-and-decode…. These are suggestions, unfortuantely we don't have a ready solution for this.
There will be no negative impact on the search functionality, just it's parameters will be different, all of the search templates features are provided in a corresponding table of the shared above article.