Discussion Categories

is there any way to create an record type without Primary key ? As i am getting the data from web service

I had created a process model to add employees, leave request, and leave approval. in leave approval, it doesn't get the employee id by itself. I had configured everything. it is showing an error in the expression rule... that the value should not be null... the value is not null at the table... I had checked with the expression rule... it gives the data by entering the id...  but here its showing error.

Hello all, I am trying to empty the form whenever I press add button it empty the form and take the data to an editable grid like this.

i have 2 level approval , first team 'A' has to approve and after they approves  it should go to team 'B' . If i'm on same page it shows "team b" form . if i comeback to the same request  again after sometime it starts from "team A"  form again instead of "team b" form

Hi Community, I got an issue regarding "Export to Excel" button in the record type. The button is clickable but no action happens. However there are 16,000 rows there and the source is data type. Also, it happens to some users but it fails for me. We are all using chrome (although I checked Microsoft Edge and it is the same). Could anyone suggest a solution please ? Thanks in advance.

I have a custom VB script which I need to execute using Appian. Does Appian have resources to do so? What are the steps I need to take to execute the script?

Has anyone seen this message before? Filters are working in lower environments but not in prod. This message is displayed for all record types regardless of number of data.

Is it possible that when authentication with SAML is successful, it triggers a process or a rule where any type of logic can be applied using the user's information?

i am creating record type (Source as web service )Also Created one expression rule as written in code snipet a!localVariables( local!result: rule!JTV_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map( projectId: index(fv!item, "projectIds", {}), customFieldName: index(fv!item, "name", {}), customFieldId:index(fv!item, "numericId", {}) ) ) )But it returns output like this by doing like this project id will be blank in record type or i have to to join array to make it comma separated in record type ..... But out put required is like  MapprojectId 18800(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer))MapprojectId 12405(Number (Integer))customFieldName"2nd Outreach"(Text)customFieldId28306(Number (Integer)) MapprojectId 11000(Number (Int

I have a process model that opens an interface to "update a request."  I called the process, passed the parameters and the rule expression to fill the form of the previously entered data which the user is going to update. when i click edit, the interface shows up , but when i click next or cancel or any other button, it says " Action completed "  and then closed the interface and returns to this page.  Next or cancel are not the end of the form , next is supposed to take me to the next slide,  and the button works perfectly on the page that i am calling using the process model.  "Next" is supposed to take me to the next slide to make the user update the data. 

I am getting this error screenshotted above when trying to click a link field setup for editing/updating a user. I will show the block of code from Line 52 and on within TB_QE_getPodCodes that it says it is complaining about. Does anyone know why this might be occurring or point me in the right direction? Thanks in advance! a!queryEntity_22r2( entity: cons!TB_ENTITY_PODS, query: a!query( selection: if( a!isNullOrEmpty(ri!selectionList), null, a!querySelection( columns: a!forEach( items: touniformstring(ri!selectionList), expression: { a!queryColumn(field: fv!item) } ) ) ), logicalExpression: if( not(local!checkAllFilterNull), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter(field: "id", operator: "in", value: ri!id), a!queryFilter( field: "podCode",

Hi All , In the attached Screenshot, two values are shown for the project ID, and I want the custom field name to repeat itself twice and the custom field id to repeat itself twice as well.  I've added code snippet to what I've currently written for reference  and  Output should look like this  map project id  list of number(integer)-2 items   18800 (number(integer))    12405 (number(integer)) customFieldName  list of (Text)-2 items    "2nd Outreach" (Text)    "2nd Outreach" (Text) customFieldId. List of Number (Integer) -2 items    28306 (number(integer))    28306 (number(integer)) a!localVariables( local!result: rule!LGH_intCustomFieldsGET(), local!rows: if( condition: index(local!result, "success", false), valueIfTrue: local!result.result.body.values, valueIfFalse: {} ), a!forEach( local!rows, a!map(

In bulk search, like we searched 3id's (lets say 8,2,6) in one bulk search paragraph. Now in bulk update function, order of selected searched id's should be same like ( 8,2,6) same as bulk search. It should not be in any other order like (2,6,8) ,(8,6,2) or (6,2,8) etc. So how can we achieve this. Please suggest

Hi i have polled emails using filter and poll plugin in a process model. The body is saved as a .EML file in a folder.  Is there anyway to extract the body of the EML file in to a table. Or to convert the .EML file into different format so that it can be extracted in to a table. I cannot use ReadEML plugin due to jar file conflict. any suggestions??

Hi there, I have a desired requirement from a client about checking to see if two values are an 85% match. So for example, if a user entered ABC, Inc. for one value and ABC, Co. for another, it would be flagged. This is just one example, if the similarity of names was in the middle or end of the value, it would also be flagged. I just can't seem to wrap my head around any logic to make this possible. Any suggestions? Thanks!

Hello, We have Rich Text Editor to take input from user which can contain special character . We are using stripHtml() to get the text and later on we are comparing the text with Regex to show validation on RTE.The issue we are facing with stripHtml() is that it is leaving some characters as html encoded in the returned text. But we require the character itself.How can we handle such case for all the special characters? For reference -In the output, the special character ( š ) is coming as html encoded whereas the other character which  is <, can be compared using regex.We need the output as - "š<"How to handle all the such characters which will be coming as html encoded? Is there any other function which we can use to achieve the above result ?

While executing PM i am getting error how can i resolve ?a!localVariables( local!currGrantWorkflow: rule!GAI_getWorkflow(workflowId: ri!workflowId).data, local!refDecTree: if( rule!SCO_isBoolNotEmptyAndTrue( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getRefWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{7cd66171-e9d3-45ae-9967-fe88fbd9f594}fkWorkflowTypeStatusId'], taskDecisionId: ri!taskDecisionId ).data ), local!customDecTree: if( rule!SCO_isBoolBlankOrEmptyOrFalse( local!currGrantWorkflow['recordType!{f8c3f153-12d0-4850-97d9-bd6878795255}GAI Workflow.fields.{5febe064-3783-49f6-ac2c-1f69ce22e5b5}isCustomWorkflow'] ), null, rule!GAI_getCustomWorkflowDecisionTree( currStatusId: local!currGrantWorkflow['reco

Hi All, I have a requirement to upload attachments to a target folder location and assign them before perform submit on UI screen. Is there ant way I can achieve this? Thanks in advannce.

i have faced  access denied problem when i add more than one email type in AI Skill Email Object 

I have followed setup instruction as per 23.3 doc and installed RPA Agent, JDK and Maven.  The agent icon in status bar is not turning to blue, I see it grayed out. And hence the robot is not coming online. Please suggest.

Hi, I have an upcoming application that is going to have a heavy IDP component. I haven't actually worked with IDP yet, and development hasn't started yet, so all of what I've been researching for Appian capabilities has been what Appian has in their documentation and other community questions. The question is, when the user uploads the form and there are attachments that also have to be extracted, does each document have to be in its own PDF? Or can they all be uploaded as one, multi-page PDF and the system can extract them all separately? Thank you!  And I apologize if I'm not wording things properly, again, I don't actually have any hands on IDP experience yet, I know each form a user could upload has to be configured and classified, so this is assuming the main form and possible attachments have been configured. 

Actually i am getting a csv  document from sftp to the staging table i am writing expression rule to count the data. so here i am getting a error memory threshold reached during output conversion. Can some one give perfect resolution for these. 

Hi everyone, I would like to export my app from dev to prod environment. In the 2 different environments there is a folder with the same name but containing different files. I would like to delete the current app in prod and replace it with the updated version of dev, but keep that specific folder that already exists in prod, then replace the same folder of the app imported from dev to prod with the files I need, keeping the same UUIDs of the documents contained in it and also the other information. It can be done? Or can you download a folder from a specific development environment on the local PC and then upload it as a zip file to the desired environment without changing the uuids? What is very important for me is that the uuids do not change. Thanks in advance

i want to highlight these two duplicate values when a user enter a duplicate value. Please suggest me validation code.