Discussion Categories

Hi  when i uplaod a doc to the grid , it returns this error shown in image below(Document must be indexed by its corresponding record type fields or relationships) .  ALSO the name field shows [Reaction Tree] what is that? where exactly am i supposed to fix the indexing? how to resolve this issue  ? local!document:rule!SKJ_GetDocumentByDocId(local!ac), a!sectionLayout( label: "Documentation Details ", labelIcon: "file-text", labelSize: "SMALL", labelColor: "STANDARD", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!gridLayout( totalCount: count(local!document), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ),

When you and your colleague are working on the same expression rule, you need to have a common test case to be used for both of you, what will you do?? Select multiple actions required[Multiple Choice][a] Create Test case[b] Add it to a testing group[c] Use Ad-hoc Test Cases[d] Create a new testing Expression Rule

I have below record Data {'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':3, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11107, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110604, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':4, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11108, 'recordType!PRO Lead Documents.fields.pdmDocumentId':110605, ), 'recordType!PRO Lead Documents'( 'recordType!PRO Lead Documents.fields.leadDocumentId':5, 'recordType!PRO Lead Documents.fields.leadId':6712, 'recordType!PRO Lead Documents.fields.createdBy':"test@hioscar.com", 'recordType!PRO Lead Documents.fields.documentId':11109, 'recordType!PRO Lead Documents.fields.

Hi all, I'm a bit unfamiliar on how can I search for a document based on its name to send it on an email? right now of course doing it manually works but I was wondering if there is a function that returns the document based on its name or anything similar. For example, I want to send the document named YI5688 (saved in my appian folder called documents) , my process variable contains the name , but I'm not sure how to "search" for the document. Any thoughts or suggestions? Thanks in advance!

I am getting the above error , what does it mean and how to fix it?  I am trying to add the document in the grid , and save to its record type.  The rule input Doc is defined as (array) could this be where the problem is?  a!sectionLayout( label: "Documentation Details ", labelIcon: "file-text", labelSize: "SMALL", labelColor: "STANDARD", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!gridLayout( totalCount: count(ri!Doc), headerCells: { a!gridLayoutHeaderCell(label: "Document" ), a!gridLayoutHeaderCell(label: "Name" ), a!gridLayoutHeaderCell(label: "Classification" ), a!gridLayoutHeaderCell(l

Hello All, We are having a requirement to split the document uploaded by the user into smaller documents if the size of the document uploaded by the user is more than 5MB. The file type can be any like Excel, txt, pdf etc. We need to create a solution that will pick the file and divide that in small size files and save in Appian document folder. Thanks in advance for your response. Regards

Hi, we need to make an integration with SharePoint Online, in form of single system login, with Appian 21.4 The customer after done the configuration on SharePont, gave us a PFX certificate and no client secret. But as I read on Appian documentation the "certificate authentication" is an alternative to Client Secret authentication which is needed by Sharepoint Connected System on Appian. So we need the customer to configure following "Granting access using SharePoint App-Only" (https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs) and not "Granting access via Azure AD App-Only". Is what I say correct? Is there a way to configure a SPO integration on Appian by using the certifcate authentication? Thanks

I have a parent Interface calling 2 child interfaces. Both the child interfaces are grids.  The first grid shows previously added data and has capability to select a row and add it to the bottom grid using Select button. The second grid has search fields to search for an item and add it to the grid. I'm passing these 2 different data as 2 different variables to the Grid 2. (Though I tried passing as single didn't work). Here is my scenario:   I select first item from Grid1 it gets added to the Grid 2 Then I search functionality and add data to Grid 2 Now I select another item from Grid1 and try to add. Problem: This time when I select my second item from Grid 1, I don't see the newly added item in Grid 2. I see the newly added item is seen in local!submissionSubstance_HTTP but not in the Gri 2 This is the local for my Grid 1 selection local!submissionSubstance_HTTP: a!refreshVariable( value:rule!DCC_castSubmissionSubstanceData( s

Hi, I have a web API, and inside that am calling few expression rules and storing it in Local variable. Is there a way that i can see what value is getting stored in that local Variable.(just like we have an option in interface, expression rules.) Eg: From local!getDelta am getting Delta value local!abc: rule!xyz( getDelta:local!getDelta, processid:index(http!request.querryParameters,"processId",{}) ) I need to check what is the value in local!abc in Web API object.

Does anyone tried to execute a robotic task using a robot installed in a remote linux terminal? Im trying to execute a simple robotic task that open chrome browser and returns me some data of a webpage, the robot is online on the dashboard but when i try to open the browser it pops the following error:  2023-04-18 11:05:07 02s (0h) - Driver could not be initialized: unknown error: Chrome failed to start: exited abnormally. 

Hello, I'm retrieving from DB base64 documents by record types from CDT queries and using it in the app, and I am having a problem when retrieving them. The application should be able to work with documents up to 2 MB, but the limit for queries is 1MB. Is there any way to increase this limit?

Hi! I have created two different Records (R1, R2). In my site, I have a summary view of R1, which shows some info + a Read-Only Grid of R2 (filtered by R1 primary key) Besides I have a related action (of R1) to delete the records of R1 My problem here is that, when I try to delete R1 I have faced different "errors" among the time: A) nothing happens B) an error appears (not able to delete) C) It deletes the summary view and the R1 field, but NOT the R2 fields Something similar occurs when I try to update records So, which recommendations would you give me in order to be able to delete/update two different records at the same time? I would like to hear the best practices. I was thinking about re-making each process model (delete-update) and add a delete/update records of R2 in each case. Would this be a good approach? Thanks a lot!

I have a record used in an interface and I want, as I press a dynamic link, in the save() part to add an empty vale to the array of the record, to do this I try a!save(recordtype,append(recordtype,save!vale) the save!value is the recordtype(), but it says it doesn't allow appends to records, how do I do it? I don't have much experience with records still. I need this because I have a foreach with that recordtype as the item so I need a new row when I press the dynamic link so I can fill the fields that should appear Thank you

I am trying to get a temporary table data by executing a stored procedure. This stored procedure is responsible to create a temporary table, insert some hard cored values (id and name as fields) and then dropping the temporary table. Before dropping Inam using select all statement so to get my data before dropping the table. But somehow I got the data which is similar to this, { { id = 1, name = Abc }, { id = 1, name = Pqr }, { id = 1, name = Uvw }, { id = 1, name = Xyz }, { id = 1, name = Ijk } } It looks like 2D list of map. can anyone help me in binding the data to excel using Export DataStoreEntity to Excel and Execute Stored Procedure smart services.

Hi All, I'm new to appian plugin development. I need some kind of road map where to start and how to develop my knowledge. I have basic understanding in java. What is the basic requirement that is needed for a plugin development.  Thanks!

We have freeform paragraph field, where user can enter any text string except the emojis. I have tried some of following regexreplaceall function which works fine to remove emojis but it also removes some of the special chars as well. Any suggestion on how to just eliminate emojis by completely removing it or just replace it with text string. input: "afs saf [emoticon:4191f5ee34e248a29fa0dbe8d975f74a][emoticon:5ced9b85a4a246058e4772ef2b9956f4][emoticon:33306c418930400bac28808410f8ac8b][emoticon:ac85b29e2ff049dd9278224b337cdf43][emoticon:ccfc0979d5bf49dc92a54d454ae8fe68] sdfa sdf___~!@#$%^&*()_+{}|:<>?" Function:  regexreplaceall("[^\u1F600-\u1F6FF\s]", ri!input, "" ) currentOutput: "afssafsdfasdf___~@^_{}|:<>?" desireOutput: "afs saf  sdfa sdf___~!@#$%^&*()_+{}|:<>?" Thanks! Ajay

We have 3 cloud based environments: DEV, QC & Production. When the Appian platform is being upgraded on the cloud, we can schedule the date/time it happens for each environment. General good practice is that you should upgrade your non-production environments first. After a period of regression testing on those environments, you upgrade your production environment. Now, if we upgrade our non-development environments first for a period of a week to give the developers and software testers time to do their regression testing, we cannot deploy any new features or bug fixes to production during this time as the Appian versions on DEV/QC are different to Production. This is a major problem if during that week of testing a critical bug is found in production that needs to be fixed and deployed to production ASAP. How do you all handle this?

Hi all,  i have this problem with the calendar: today is shown as saturday, but it's friday.  I don't understand how to change this setting, and i don't think it's depending by the timezone. Anyway, there isn't the UTC+2 for italy timezone.  Anyone have some idea?  Thanks in advance

hello all, I am trying t write to a table using write records smart service. The data is being written in DB table but I do not have the records updated captured in my output variables of node. I am doing a single entry at a time and record has no relationship defined. One thing to note here that we have configured triggers on this table which updates some columns for the same table. We are using Postgres DB. has anyone else experienced the same situation. Node Configurations:

Hello! I´m having some trouble trying to save my values in an editable grid. The first 6 columns are read-only (data from a local variable, query of a record) and the 7 one is an editable column (user introduces quantity) My values are not saving correctly into my rule input "RecordLineasRecepcion" Could you please tell me how can I save the values of each column? I think I cannot use fv!item in the saveInto parameter of the six first columns because the user is not interacting. Should I use an (or some) a!save functions? Can that work with more than one row? This is an example of what I want to do: 1) Show the value of the selected field of my local variable 2) Save the value to another record With my code code, no data is saved when I click "Submit" I leave my code below (I know that if there is no user interaction data will not be saved when using the SaveInto of each field directly, but I´m not sure how to be able to save the values): a!

I have a read only grid sourced from expression which is getting data from an integration. I want to export this grid data to excel. So can someone please help how to do this. Stuck here as Export CDT to excel is deprecated. 

Hi All, What is the best way to add a user just created with the Create User Smart Service to a specific group in my application, is there a specific smart service I can use for this in my process model? thanks in advance

Hi All, I'm trying to add a exception to one of my nodes when I'm creating new users, checking the condition if the username is taken or not. I'm currently trying to add this exception to the create new user smart service node,  When I create this exception it gives me an error of activity class parameter? is it saying that the value giving to check it doesn't exist ? I'm not sure.

is there any way to improve the Look &feel of our appian interfaces by adding Html & Css from external Sources.

Hi good day, I'm trying to create a download csv/excel file from a list of dictionary from my data.1st Step - Fetch Data from DSE2nd Step - Transform Fetched Data to Specific Dictionary (with Formula).3rd Step - Convert Transformed Data (Dictionary) to CSV/Excel Document.4th Step - Put Document in Document Download Link.Note: This is going to be perform in Interface.