General

I cannot select or change the target as I get "Cannot find the main Appian window. Reopen that window and launch the modeler from there." Is there a fix for this bug?

He all, we are able to upload files with extensions(docx,xlsx) to documentum.but we are facing issues, while retrieving from Documentum to Appian, we are not able to get the extension, instead saving as type "file".is anyone facing this issue and let me know the leads. Thanks.

Having two tables one is having 100 records other is having 5 records with same index as in table one ,  I want to update the table with 100 records with the data from table with 5 records using foreach loop in appian? write syntex.I am trying to update records using write to record function. Can anyone explain about this.

Hi Experts I have a problem where I need to generate an excel without storing the data in DB. I'm using Export CDT to excel smart service, But I have nearly 6000 rows to fetch with only 3 columns(Request ID, DOC ID, Doc Name). I want to know what is the maximum amount of data in terms of size(MB or KB) a process variable of type CDT can hold. And if is there any better solution of what I'm doing, please suggest me. Thank you in advance

when i pass the value to the code am getting below error if( null(ac!convertWord_txt), "zero", convertnumbertoword( trim(split(ac!convertWord_txt, ".").[1]), "" ) ) what might be the issue here

Hi  We have just upgraded the Appian version from 21.4 to 23.3 and we have an issue with the date format exported to excel coming from record types, in the prior version this issue was not happening, does anyone has experienced the same issue? 21.4 version-correct format 23.3 version - incorrect format by looking the format in the excel is taking it as if it was a text but this is the logic behind the date column: if( a!isNullOrEmpty(fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime']), todate(null), todate( text( fv!row['recordType!{92d1b022-5508-4130-83d7-528677bb837e}ACH CASE.fields.{b79811e6-b6ad-4b38-b04d-134b4d22d656}createdOn_dateTime'],"mm/dd/yyyy hh:mm AM/PM" ) )) we are just converting the date and time to date and when we do that the format gets reflected as text in the excel which was not happening in version 21.4 

Hi All, Facing "could not cast from list of Map to Dictionary" error while calling a!startprocess in interface, could you please help me in resolving the issue. Created a portal to capture the vehicle details in an apartment, after data entry and after clicking on "Save" facing this error and this is developed for hands-on purpose only. Pasted error and code for your reference. "Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = WBZTQ] : An error occurred while executing a save: Expression evaluation error at function a!startProcess [line 438]: Could not cast from List of Map to Dictionary. Details: CastInvalid" a!localVariables( local!residingOwner: true, local!tempApartmentName: "Dollfine Durga County", local!successMessage: "", a!sectionLayout( label: if( ri!isUpdate, "Update Vehicle Details", "Create Vehicle Details" ), contents: {

Hi All, I have noticed this behavior when we are passing list of nulls to a!isNullorEmpty it returns false. I know there are ways we can handle this but is this something fundamentally wrong with this function or not. (I know it is hundred times better than isnull() but still curious) 

Hi , Is there any course for Appian mobile development videos  in community .

Hi everyone can anyone help me how to collapse a section by using FitNesse script Thank You

If a database table do not have any primary key, then how we can handle this table in Appian CDT?

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

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

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, 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.

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

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