General

Code: a!forEach(pv!addedResearchItems_cdt, if(and(rule!APN_isBlank(index(fv!item,"id",{})),rule!APN_isBlank(fv!item.url)),cast('type!{urn:com:appian:types:gngp}GNGP_RESEARCH_ITEM',updatecdt(fv!item,{file_name:if(not(isnull(fv!item.file_name)),fv!item.file_name,if(not(isnull(fv!item.document_id)),document(todocument(fv!item.document_id), "name") & "." & document(todocument(fv!item.document_id), "extension"),{})   )})),   fv!item)) Getting below error: (Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'updatecdt' [line 5]: Length of input arrays must equal length of CDT/Dictionary array) (Data Outputs) Please help to rectify the above error as what code changes needs to be done

i got this error where i used remove() but i tried remove(null, index) will return null instead of error, so what could cause this error?

User not able to see write up in ipad  as shown below  But able to see write up in laptop as shown below Can someone please help on what needs to be done here or how to resolve

The "user" parameter has a value that does not exist, has been deleted, or you do not have sufficient privileges to access its data .  I am using record events and tracked the changes in the history table which are auto created in the events   ,  As an admin i can able to view the data , whereas normal users are getting this week , i have check all the records type user records they are having viewer permission  Please let me know what could be the problem 

Hi, I have a requirement to download the grid data along with the documents in to excel. I have seen there is a plugin  Embed Image into Excel  but, i dont see any success stories on it and it is not updated recently. Can someone suggest the way on this. THanks Soujanya

So when the user selects a particular interface, a document is generated and if the user selects the 'cancel' button then the document is deleted. There are cases where the document might get deleted through another form so if you try to select the cancel button, then an error message appears. Right now this is the idea for the process model but its not fixing the issue so please let me know if you see anything that might fix the issue. the 3PI exchange node generates the document, then the XOR node checks to see if the pv!download_doc is null or not and if it is, then move to the end event, if not then to delete the document and end the event. I tried a few other options for the XOR node but this is basically as far as I know what to do?

Hello,  I'm using excel plugin tools and i can read excel databut i don't need null of row so i want to delete null row.I tried to loop list of text string but cannot get it.How can i convert list of text string to list. here is my test rest of screen shot here is my excel data image

Hi Team, I have a Text Box and Button beside that text box, when I enter anything in the text box and hit on "ENTER" button on keyboard I want the Button to submit the data. Is it possible in Appian ? Thanks  Bihitak

Let me explain  I want to get to see the summary view of a user but with all the related action bar that appears up top  of the summary view  interface I'm being  able to redirect to the interface of the summary  but i can't see the things that  i see  when Im  on the record type with all the the actions . i hope any of  you guys could help me  or tell me if this is possible or not thanks  

Use case is that we have to remove the selected multiple users from multiple groups. The issue is when I select one user then the entire row is selected of groups listed users. I want to select the users in multiple from the selected group. a!localVariables( local!selectionValue: {}, local!selectedGroup: ri!initialGroup, local!actionTaken: if( isnull(ri!btnAction), false, or(ri!btnAction = "ADD", ri!btnAction = "MOVE") ), local!distinctUsers: if( a!isNullOrEmpty(local!selectedGroup), "Please select a group", a!flatten( a!forEach( items: local!selectedGroup, expression: a!localVariables( local!group: fv!item, a!forEach( items: getdistinctusers({ fv!item }), expression: a!map( id: fv!index, Group: local!group, Members: fv!item ) ) ) ) ) ), local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 10),

Hi. I was setting up some save functionality for the one spot in my code that saves to a particular variable. I had a rule that outputs null under certain conditions, but kept watching it show up as {null} instead. I have tried to simplify the issue and have found saving into the localvariable something like {"Apple", "Banana"} results in straight null instead.  What is happening in my interface? If i save the same value to a random debug variable it works fine.

Hi Folks! I have a scenario here which seems impossible to solve. We have an excel template where column A has formula that increments row number if we add data in column B. This excel is used as template in Appian where we are querying a view and dumping the data in this excel. When we tried doing this, the formula is overridden by the values from the view. So the formula doesn't work anymore if we add more rows in the excel. If we keep column A blank while generating template from Appian, we need to update something explicitly in column B for the values in column A to auto-populate. We don't want to use VBA code as well since macros are disabled by default. Is there any way that the formula could work even if we dump data in column A from Appian, any plugin or configurations we could do in Appian or anything on excel side? We want to avoid the situation where we are keeping column A blank just for the formula to work or manually enter values in column A on every row

I have one requiremnt where i need to just convert the raw data into respective CDT. Is it possible to convert into the CDT without expression data. I have used cast but it is not worthy to be work. If same case is used for this using expression then it is working [RecordID=4, CatalogID=, ScopeID=6, VendorID=, InHouseTechnicianID=, WORemediationID=, BidID=, Category=, Description=, GLCode=, GLSeg=, IsExterior=false, LineItemApproval=, MatCost=, Pass=, Price=0, Quantity=1, UnitOfMeasure=, ResidentResponsible=1, Room=, SubCategory=, Summary=, TechCost=, TechTime=, OriginalPrice=, VendorPrice=, Modified=, Deleted=false, CreateUser=henryfok, CreateDate=2/15/2018 12:00 AM UTC, UpdateUser=henryfok, UpdateDate=2/15/2018 12:00 AM UTC]

Recently my Appian cloud environment got upgraded to 24.1 and have advanced level Appian support. But I am still not seeing Case Management Studio, do I need to submit additional request or how can I access it?

Using | Open User Profile | and | Open Settings Menu | as they appear in the Cheat Sheet  results in an error: Input Must Be Set.  Are there examples of how to use these correctly?

Hi Everyone, Can anyone please help me, Is it possible to display image in radio button as shown in screenshot below:

Hello, We are building a site which will be used to gather request and I'm trying to find if there is a possibility to make bulk upload of these request using excel. The form which need to be submitted contain single rows and also arrays of data. We want all of these bulk uploaded request to stay in "draft" mode and not being push to the backend databases, because that can lead to incorrect information to the database since we have some validations which need to pass. We need to give the client the agility to edit these information when they are loaded as bulk. What are the capabilities of Appian to load bulk data, what are the limitations?  Thank you!

Hello, we have a locally hosted production environment and a cloud development environment. We want to deploy the application from the cloud to the local machine. When we export in dev and import the app to prod environment the database tables are understandably not linked to the record types. However when I connect them and tell Appian where they are (I am running a local MariaDb and connected it to Appian via admin console) they are connected up until I import another version of the application. So on each import I have to go through each record type and add the data source which is the database table. How to solve this? There has to be a better way to do this.

How do we go about inserting a TIFF file into a Word document using ADT? Currently, we're able to insert a TIFF file with a single image into Word without any issues. However, when attempting to insert a TIFF file with two images, we encounter a problem - only one image is inserted successfully while the other is not. What could be causing this issue?"

Hello,  Is there any way to add a dynamically generated dropdown inside of the Appian navigation bar?  For example, I have a database table filled with a value that I would like to 1. Create a dropdown record for each value 2. When selected, open up an interface with that value passed into it as a rule input Thank you,  Nicholas

Hi everyone,  I'm seeing this behaviour which I cannot explain. Could anyone recommend me a solution or reason for this behaviour? I'm having an interface with gridField(), one of the grid column's value is richTextIcon() containing a submitLink() to kick off a process model. Please see below the code to build up my grid column:  a!gridColumn( align: "CENTER", label: "", value: a!localVariables( local!showLink: false, a!richTextDisplayField( value: a!richTextIcon( caption: "Re-open Case", icon: "folder-open", link: a!submitLink( showWhen: local!showLink = false(), saveInto: { a!startProcess( processModel: cons!PRO_PM_REACTIVATE_CASE processParameters: { noteContent: "This case was re-activated", caseId: f

Hi All, Can anyone please help me how to change the color of button using recordaction in interface.

Hi,I am not able to see properties of any node in process models of all applications. I verified all the permissions everything is fine.Here I am attaching snippet for reference.

Hi.   I am getting an error trying to parse a list of docIds and convert  it to a list of cdts I made.  The cdt are of the form projectMouDocument{mouId(int), docId(int)) I pass in a static mouId and a list of docIds.Heres my script for the output into a process variable that is a list of projectMouDocuments.  I expect to get a list of projectMou documents from this. a!forEach(    pv!documentIds,    cast(  'type!{urn:com:appian:types}DSC01_projectMouDocuments'(), a!map(  docId: pv!mouId,   mouId: tointeger(fv!item)  )   ))Error in script task : An error occurred while evaluating expression: projectMouDocuments:a!forEach(pv!documentIds, cast('type!{urn:com:appian:types}DSC01_projectMouDocuments'(), a!map(docId:pv!mouId, mouId:tointeger(fv!item)))) (Expression evaluation error at function a!forEach: Error in a!forEach() expression during iteration 1: Expression evaluation error at functio

Use Case Screen-A Have text field and button to send value to Screen-B Screen-B Obtain value from Screen-A and display form based on obtain value. Solution that I tired 1. Record Action: Does not work because can't send value to Process Model 2. Related Action: Does not work because It can send only static value. not a value from Screen-B I search for some forums and there is solution of using starProcessLink but, It is limited to hyperlink. Not work as a button. Maybe I have to create cardLayout to simulate it as a button and use startProcessLink inside? Thanks!