Foundation

Hi Everyone, Requirement: We need to Read the excel file which have some row data along with some text boxes.  We are unable to read the excel file which has some row data along with some text boxes as shown below, we have tried almost all the functions, but we did not get any solutions.  Used Plugin/Functions: readexcelsheetpaging validatedocumentheaders excelreadcellsbyname excelreadcellsbynumber Any suggestions would be appreciated, Thanks in advance. 

Hello Team, We are using a process for creating new user but the "Create New User" node is getting cancelled out giving below error The user [test123] does not have sufficient privileges to perform the requested action because they are not in any role. Do we have any idea why this is happening? Any help here is appreciated. Thanks in advance

Hello, I'm new to Appian and currently exploring its features. I'm looking to implement a feature where users can upload Excel files and view the data contained within those files.

Greetings, fellow devs I am now working on a Node.js project in the Appian environment, where we are using Mongoose and MongoDB to handle database operations. Our major aim is to efficiently manage CRUD (Create, Read, Update, and Delete) actions that alter data within our Appian apps. However, we've faced some complexities along the road and might benefit from community thoughts to negotiate these obstacles efficiently. Scenario Overview: We're integrating Mongoose, the MongoDB object modeling tool, with our Appian apps to interface with our MongoDB database. Our project requires managing a variety of datasets and performing CRUD operations to enable data manipulation within our Appian processes. I've included a piece of code that demonstrates our current approach to doing CRUD operations using Mongoose and MongoDB in the Appian environment. Let us dive into understanding these difficulties and developing solutions together. // Sample code demonstrating CRUD operations wit

Instead of sending out an email using the process model "Alert" setting, I am trying to integrate with Pager Duty API. Is there any way we can call an integration object (to integrate with Pager Duty) so that we publish an event to Pager Duty instead of sending out an email? Right now the email is been sent out and it integrates with pager duty in that fashion but our preference is to skip sending email all together.

So I have an interface that has links to documents that have been uploaded. However, the documents don't exist until after they've gone through a process model (or rather they're a temp file that you can't reference at that time). What I'd like to do is disable those links if the documents haven't been put into the system yet, but I am not sure how to check to see if the document exists in the system yet or not. Is there a function or something that can test a doc id to see if it's valid or not?

Hi, I need solution to automate code review for applications where all objects follow basic best practices. Appreciate your help.

Hi All ,I am having following code ..calling start process model .. i want page to be refreshed after process model is complete. What will be the best way to implement. a!buttonWidget( label: cons!OCO_TXT_USER_ACTION_SUBMIT, saveInto: { a!save( ri!userAction, cons!OCO_TXT_USER_ACTION_SUBMIT ), a!save(local!data, a!startProcessLink( processModel: cons!OPS_PM_UPDATE_SETUP_DETAILS, processParameters: { interactionDetails: a!update( data: local!interationDetail, index: {OPS Interaction.fields.interactionId',OPS Interaction.fields.isActive',OPS Interaction.fields.createdBy',OPS Interaction.fields.createdDt',OPS Interaction.fields.updatedBy',OPS Interaction.fields.updatedDt' }, value: { ri!InteractionId, true(), loggedInUser(), now(), loggedInUser(), now() } ), npiDetails: local!npiDetails, tinDetails: local!tinDetails, }, )) }, submit: true, style: "SOLID", showWhen: local!currentStep = rule!OCO_nullSafeLength(local!formSteps), validate: true )

Hi I have a process model to create a workflow..In the first interface,the user can enter details and they can clone the workflow ‘n’ times by clicking on clone button..After clicking “submit” button,the next page comes to update each workflow by adding some levels by clicking each one.Suppose if we update the first workflow and then clicked on update button, it will show green colour.But when clicking on second workflow and click update after provided the levels,,it shows ”action completed” without giving the green colour. For example,I have cloned the workflow 2 times,after clicking on submit button ,it then moves to update page..so if I update the first workflow it will get updated,but when trying to update second it shows action completed..This is happening if we put number of clones as 10 or any number as first workflow only gets updated. In the process model,it is updating correctly for the first workflow..In the second workflow,it got break in

Hi, How to call azure blob storage container and upload files through appian? Is any plugin available?

Hi am having the below issue on SFTP usage, I am getting the below error" ERROR com.appiancorp.ps.plugins.filetransfer.sftp.ReceiveFileOverSFTP - com.jcraft.jsch.JSchException: timeout: socket is not establishedfor my FT_Config, I used the below details. cast( 'type!{plugins.ps.appiancorp.com/.../}FT_Config', { serverHostName: "192.168.246.99", serverPort: 22, scsExternalSystemKey: <indicated in SCS>, usePerUserCredentials: false, timeout: 60000, keepAliveTimeout: 60000, activeMode: false } )I tried the connection details on external application (Cyberduck) and was able to access the remotethanks!

My customer wants to use the chat function. We are considering linking the chat system from an external system, but we would like to complete the exchange of messages within Appian as much as possible. Basically, the interaction is one-on-one, and it is assumed that the user will initiate a chat when making an inquiry to the administrator. Please let me know if the above chat function can be realized within Appian.

In our Appian Application a form is being submitted through a process mode and after the process it is automatically being redirected to home page. I want to keep the user in the same page after the submission. Is there any way to do it?

Current Behaviour: a!localVariables( Â%A0 local!test: {}, Â%A0 if( Â%A0 Â%A0 condition: local!test > 0, Â%A0 Â%A0 valueIfTrue: { Â%A0 Â%A0 Â%A0 "My First Message", Â%A0 Â%A0 Â%A0 "My second Message", Â%A0 Â%A0 Â%A0 "My third message" Â%A0 Â%A0 }, Â%A0 Â%A0 valueIfFalse: "My false Message" Â%A0 ) ) Given the above code when the local!test value is {1} the output is {"My First Message"} when the local!test value is {1,2} the output is {"My First Message", "My second Message"} when the local!test value is {1,2,3,4} the output is {"My First Message", "My second Message", "My third message", "My First Message"} If you set the condition to be local!test < 0 you will see similar unintuitive behaviour. Expected behaviour: an error to be thrown stating that you can not do a comparison between a value and a list.

Hi, We have a requirement to expose an interface to users who don't have an account in Appian. While this could be solved using Appian Portals, we are in an on-premise environment, and I've read that Portals are not available in these on-premise environments. Is there any alternative that works similarly to Portals for on-premise environments? Thanks in advance

I'm trying to achieve this kind of display on my interface, but I find it to be difficult. Is it possible to achieve such effect?

Hi, I have a value to display and it comes from DB. The value for example is "Consistency Assessment completed – Artwork updates are NOT required – Specify reasons in comments" SO now before displaying it I have to remove this part "– Specify reasons in comments" and display only "Consistency Assessment completed – Artwork updates are NOT required". Can some one please help how to strip that comments part. Thanks in Advance.

Hi All, We are getting "Run encountered an error: Invalid Community credentials (APNX-1-4520-204)" even though we are going correct details, during scheduled Health check report . Is there any solution for it? Thanks in Advance

Hi Everyone,  I'm currently exploring new opportunities within the UK, specifically in the Business Process Management (BPM) domain, and I would greatly appreciate your support. If you have any advice, connections, or opportunities, please feel free to share them with me. Spreading the word by sharing this post would also be incredibly helpful in extending my reach. Thank you in advance for any assistance you can provide. Let's connect and make the most of our professional network! #OpenToWork #London #Appian #LondonJobs LinkedIn Profile:- www.linkedin.com/in/nidhi-agrawal-jpr

Hi Friends,     Whenever I am trying to check process history, the paging details not getting displayed correctly. PFAs for your reference. Total count is 453 when page number is 1; No. of pages: 5 Total count is 183 when page number is 2; No. of pages: 2. Is anyone facing the similar issue? How to fix it? Thanks in advance!

Hi All, I am using a!queryrecordtype() function to retrieve data from records but every time it also calculates the fetchtotalcount parameter even if I gave it as false. Can anyone please help me out how to remove the totalcount calculation.

i'll get list of data from one query, to that query data i have to map few fields value  ex query1 gives : id :54,  class: B, owner :xyz id:54, class: A, owner :test from second query from another table will get  id:54, owner :abc this second query owner data needs to update/show in query1 how can i achieve this  update for id:54, class:A , owner: abc

Hi All, We have a requirement where external system wants to embed Appian interface. But the problem is we need information from the external system so that we can show up on Appian embedded interface. I have gone through documentation (https://docs.appian.com/suite/help/23.4/Embedded_Interfaces.html) but couldn't find anything on how to get parameters from external website. Appreciate your response.

I was unable to upload the images

I am using Appian's Send Email Smart Service.I cannot receive emails sent to emails with the domain names @outlook.jp and @outlook.com.The Send Email Smart Service is green in the process model with no errors and the Send Email Smart Service is passing.I have tried using Appian's Send Email Smart Service with Process, Process Model, Process Initiator, Process Designer and Custom Sender as the sender, but I cannot receive the emails.The recipient email is enclosed with a toemaiaddress function. We have also checked our spam folder, but there are no emails. In Outlook, the domain of the emails sent from the Send Email Smart Service has been added to Safe domains.No specific Outlook rules have been created.The emails themselves are very small in size as they are test emails. One concern is that when I use the toemailrecipient function, emails are sent for non-outlook email addresses, but I get the error "No valid recipients resolved" for outlook email addresses.