General

Hello Appian Community so from last 2-3 days I don't know  why I am not able to access my cloud database , whenever I am trying to open it so new tab is opened but there is blank page I don't know what's wrong so someone can help me out regarding this. ?

We have a process model that inserts records into a table and then we call a stored procedure that will execute and perform an update action on the newly inserted records while running it the process model is executing successfully and records are getting inserted but it seems the execute stored procedure node is not executing. also, the node is not giving any errors, yet it is taking some time to process but the update is not done. Can anyone help on what might be the probable reason? Is it going out of scope? Screenshot of the PM where the node has been added:

Hi, I have an interface from which I am passing documents from an attachment field from an interface to a process model. That process model simply writes the doc id to the database. I am getting a problem thet the rule inputs are holding the values but it is not passed to my process model. Can anyone please help on this.

Hi Everyone !!!,I know this is very common question i know it but for clerification can anyone let me know that  We can directly save the data into the database througth interface but which is better from process model or interface??

Hi All, I have to display the data shown in below screenshot. Is there any grid pattern available to display like that?

Hello, We have a CDT in our application to match an Excel file that is being uploaded. If the Excel template changes (ie. column headers are renamed and rearranged), what is the best practice for getting the CDT to match the new Excel file being imported? If I edit the XSD of the CDT to match the new Excel template, will all dependencies automatically update under the CDT?

In part of my requirements for this project I am working on in Appian is to allow admins of the application be able to dynamically add fields and forms from the backoffice interface for users to access and submit their responses to the dynamically generated forms. I have looked everywhere online for the answer but have found little to no information on the topic. All I found was a plugin, however I am precluded from utilizing plugins in this specific project, and as such, must be developed entirely on Appian without plugins. Can this be achieved?

Hello Everyone, I have a requirement of showing an editable grid when clicked on a value in a read only grid. Is it possible to do? Or Is it possible to give a search filter and user filters to a editable grid?

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 )