Discussion Categories

Hi! I´m creating a rule expression to return a value based on the logged in user, and use this value in an interface. In this case, I want to return the value "Proveedor 2" and show it in the interface. But the problem is that, when I try to reference the rule as a local variable, the following is shown. My local variable configuration is: I think the problem is in the test output of my expression rule. When I put it in raw format, the same text which appears in the interface is show (I just want "Proveedor 2"): 1)Image of expression Rule 2) Expression rule output in various formats In this case, I would like to extract just the "Proveedor 2" output. How can I do this?

If I intend to use Rich Text for a field in an application, what type of formatting should the field have in the database?  Would a Varchar(4,000) work for example?

I am trying to show HTML data in rich text editor but the html we are receiving from api has some hidden tags with visibility: hidden. I know that hidden items still take up space in the layout but the content is hidden. Rich text editor is not hiding those elements or tags. The data and elements inside those hidden tags are still visible in editor. Any possible way to resolve this? Also, how to make rich text editor open hyperlinks in another tab rather than in same editor window?

I'm having this issue while trying to search anything at the "all objects" search box. I don't know why this is happening only in the development environment. Can someone help me ?

Hi,  I would like to know how I can append data inside multidimensional/record or record relationship array ? Please check the example bellow append( local!sections, 'type!{urn:com:appian:types:SN}SN_DATA'(id: null) ),

Hi Everyone , Which link component can we use for this link(Target) which not a part of any record "gileadmedaffairsdev.appiancloud.com/.../iQBdsM9sWBbQJu_AcauYDn3QmjvXg6b8LUgndmI4vkmGkMvHAg" Where "060be4f3-2634-4745-98fe-88fbb6fcf834" this part(attribute) will change everytime when we open the page .Thats why we are not able to use the above target as it is as URI in safe link component. Is there any solution where we can generate link for the above target Many thanks

Hi Experts, I Need your help. There is a use case where I am designing an Interface from where the user uploads a CSV file and I have to convert that CSV file data to CDT. And once this has been converted into CDT I have to show that data in a read-only grid on the Interface. Thank you in advance for your support! Below is the overview of the data of my file:

Hi! I´m trying to make a simple record filter of a dropdown list, which contains a list of text. To make the dropdown, I point to a constant which contains a text array with the name of the suppliers: But the fact is that, when I try to make a simple filter, it doesn´t work. If I put a text value, nothing appears. If I try with an expression ("Proveedor 1") I have the following error: I think it´s because of the list, because the filters work properly in individual text fields. What can I do to fix it?

Hi, I want to export the data in excel on page load using ExportDataStoreEntityToExcel. how we can achieve this? I am successfully able to export the data on saveinto but here want to export on page load. Below is the code which i am trying. Code is not throwing any error but seems not calling this export service also. local!exportDocId: a!exportDataStoreEntityToExcel( entity: cons!SCE_SITS_VW_INCIDENTS, documentName: "test Report", sheetName: "Test Report", saveInFolder: cons!TEST_DOCUMENT_FOLDER, onSuccess: a!save( local!exportlink, fv!newDocument ), /*This displays an error if there is an issue executing the save*/ onError: a!save( local!errorMessage, "Error Exporting File to Excel" ) ),

Steps Done 1. App registration on azure portal.2.Admin Consent on Azure.3.Getting Access token from  login.microsoftonline.com/.../token4. Use the access token to call Microsoft Graph works for https://graph.microsoft.com/v1.0/users.  but While Calling Graph Api to access OneDrive https://graph.microsoft.com/v1.0/users/{user-id}/drive  After Admin Consent I received the error "Tenant does not have a SPO license" . Is this the free version issue or i need to add Office 365 to my existing tenant and how to do that ?

Hi Everyone,  If anyone have setup integration with Microsoft Dynamic 365 FO Ever. Please help me out with the steps till authorization.

A record is created but getting null error for a field.  Checked the DB structure as well, the field nullable = Yes there

Hello, I have a problem when entering the credentials to connect with Google Cloud, the private key is not recognized and I would also like to know what information goes in the fields Destination Bucket and Source Bucket

A feature is being deployed to the test environment.In which environment is unit testing performed for the feature?

Hi Team, How to send an email from outlook to start a process model in Appian ? and how many ways we can achieve this ? Thanks in Advance

Hello there,These trhee plugins are implemented by appian:community.appian.com/.../mail-pollercommunity.appian.com/.../msgraph-email-pollercommunity.appian.com/.../poll-email-from-microsoft-exchange-ews-apiHowever the latest version of the plugin needs to be on Appian 22.3 or later.Is it possible to get a previous version of the plugins compatiable with Appian 21.3?Kind regards, J

I am implementing a gridRowLayout. Inside the gridRowLayout I am implementing a fileUpload field.  So that I can add a new row dynamically and for each row I can upload 1 document. But the demand here is ... I cant upload same files again and again (i.e. I cant upload same files in different rows) . But I am not quite sure how to do the validation for it. Can anyone help me with this ?  This validation I have added for fileName. But as you see I could upload same files. I need validation to say that File Already Uploaded. Is there a way to do this validation ?

Hi everyone. I hope you're looking forward to the weekend. I am asking for ideas to handle the following scenarios with the decision table feature.  Scenario 1: An input is a list of strings with variable sizes.  Example input instances: [ "value 1", "value 2", "value 3"] [ "value a", "value b"] The input list of variable sizes is checked against a predetermined set of items to answer the following question. Do the input list items exist in the predetermined set of items? given this input [ "value 1", "value 2", "value 3"]  does at least 1 input element contains in { "value x", "value y", "value 2"}? In this case, the result will be true.  Question: what is the best approach to solving this scenario? Scenario 2: The following document indicates the following.  Leverage existing application reference data: Decisions can use your application reference data (like case statuses) that is stored in constants, database tables,

We have a unique user request that the user wants to submit change request to an approver group without having to close the interface and click another start process link in the read only grid. Currently the process model has a Process Start form that the user can edit changes. Here is the issue they want to send the changes to an approver group while keeping the interface page open to use a dropdown to select another entity and submit a request multiple times. Basically he users want to be able to submit change request and not have to keep going back in to the interface page from a link each time.

Hi, worday function is used when weekends are need to be excluded to calculate workdays. We have requirement to calculate including weekend. Below is our expression we need help to calculate finaldate when include weekend is true. here expectedholidays is list of holidays. a!localVariables( local!expectedDays: if(ri!days > 0, ri!days, 0), local!exceptedHolidays: if(isnull(ri!holidays), {}, ri!holidays), local!startDate: today() - 1, local!initialEndDate: local!startDate + local!expectedDays, local!FinalEndDate: a!forEach( items: enumerate(local!expectedDays)+2, expression: if( contains(local!exceptedHolidays,local!FinalEndDate), local!initialEndDate+1, local!initialEndDate ) ), local!exceptedDeadline: if( ri!days > 0, if( ri!excludeWeekends, workday( today() - 1, local!expectedDays, local!exceptedHolidays ), local!FinalEndDate ), cons!CORE_MAX_DATE ), local!exceptedDeadline

Hi All, Can we add hyperlink in tooltip?If yes can any one provide as the solution.

Hi! I would want to filter a site (record security) based on user conditions. When the user enters, I want to assign him a supplier name and a NIF, and then use this data interfaces to filter. Which would be your best-practice advices?

I have the requirement to find the difference between two record values of a record type like we do in case of cdts using cdtdifference(). I have the previous value of record type and then new value, I need to populate Audit table using these difference values. Any function like cdtdifference() or any workaround to do this?

Hi , i am getting this error after selecting a dropdown value :- Expression evaluation error [evaluation ID = GUC5I] in rule 'td_additemforbasicdetails' (called by rule 'td_tenderdetailsmaster') : Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 57]: A dropdown component [label=""] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was 37 and choiceValues was 32; 34; 36; 37; 38. How can i resolve this ?