Discussion Categories

So I am working toward getting my Senior Developer Certification. One of the major components of the Exam seems to be Database Management. I am well versed with RDBMS but wanted to understand the scope as far as certification is concerned. I see "Appian Advanced Data Design Training". However it is Instructor Led only. There is no self study option. Not only can't I find anything on schedule in the "Americas" for the Instructor led course, I would rather study on my own time. I simply want to know what topics are covered in the Instructor Led course. Hopefully this is public information and can be shared? Thanks in advance

Thought I would ask here to draw awareness. Going through the Portals Course - specifically the Publishing Portals Course. At the end there is a tutorial that needs the Wyndhamm Power Outage Application. Only I cannot find the application in the Appian Community Edition. Did someone at Appian forget? Or am I supposed to find the package somewhere and import it. Hopefully someone has solved this problem already.

When I'm trying to create a datatype from dB I'm getting the following error, "Your data type could not be created.please consult the logs for more information" Can anyone please help me with this??

RPA process cant scan Drop down components from appian and ends the process when it comes to drop down, it takes id as a random number when i gave recorder by interacting with dropdown, So what i was trying to do is create rpa process to automatically login into my appian designer and create an interface, so when i try to press new which is a drop down the interaction is not being performed

Hi, I am taking the service name from drop down field from interface and mapping it to following variable. After that I am uploading excel as below: Following is the rule I am using in script task and saving its value into Boolean type variable 'flag'. My requirement is if pv!Service_name=pv!cdt.srvc_nm then it should go to XOR path otherwise send email path.  if I change the value in excel rows the flow is not going in appropriate way. Thanks, Kiran

a!localVariables( local!metadataJSON: if( a!isNotNullOrEmpty(ri!metadataJSON), a!fromJson(ri!metadataJSON), null ), local!result: a!forEach( items: local!metadataJSON, expression: a!localVariables( local!section: fv!item, a!forEach( items: local!section.questions, expression: a!localVariables( local!questionrow: fv!item.questionrow, a!forEach( items: local!questionrow, expression: if( fv!item.questiontitle = ri!targetField, updatedictionary(fv!item, { "responsetext": ri!value }), null ) ) ) ) ) ), local!metadataJSON ) I have a nested json. I need to update its field "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there an

Hi All, I am planning to give appian senior developer exam. What will be key points to prepare? Academy courses are enough or do we need more preparation?  Thanks in Advance.

want to store values to different table so i have used write to multiple DS, but giving error like this i have configured like this= { { entity: cons!CR_APP_ENTITY_CONTRACT_EXTENSION, data: pv!crAPPContractExtension_cdt }, { entity: cons!CR_APP_ENTITY_COMMENT, data: pv!crAppComments_cdt }} 

Hi, I am trying to download the Data Store Entity in to excel. If I don't give any selection and filter criteria only 5k records are downloading & if I give selection & filter criteria only 1k records are downloading, but I expect more records to be download. Is there any limitation from Appian to download the records from data store entity, If yes, then how much records?  Thanks, Kiran

Trying to read the emails from Gmail account using "IMAP", but found no solution.

I want to retrieve data from Appian profile using Username.

I have multiple excel sheets and can I assign the which sheet number to open(as Default) when I open excel after download.

When updating data i didn't get multiple dropdown field and gettting error like: Interface Definition: Expression evaluation error at function a!multipleDropdownField [line 609]: A multiple dropdown component [label="Employee Name"] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was adetuya, akshaymoghe and choiceValues was aalapv; aartibansal; abdul_khan1; achyutamm; adetuya; aghosh; aishwarya_bajpayee; akaul; akshaymoghe; akshay_nikam; ankit_bass; apawar; asimzr; atadeo; basava_raju_g; basitza; bhushans; bilalq; carolina_branas; chandramauliv; chiragk; chrisxl; cjansen; clarkm; dhavaljp; diana_palmer; dilippathare; dpaul; dterzian; elomboy; francisab; gbubattula; gpattnaik; haroona; harshadp; humzak; jalpa_dave; jlakkimsetty; jmishra; jpattan; kamalpreetarora; kanikanarang; karangauba; karishma_babbar; kjaladi; ksiginumsetti; lindsey_pecor; luke_kovar; mayanksengar; mehakbakshi; mkonanki; mohitarora; mszekely;

Hi guys, I import file HTML into Send Mail at Process Model I run file in local But, I run in appian This my HTML  .myDiv { border: 1px outset gray; } .button { border: none; color: white; padding: 15px 32px; text-align: center; text-decoration: none; display: inline-block; font-size: 16px; margin: 4px 2px; cursor: pointer; background-color: #4169E1; } .grid-container { display: grid; grid-template-columns: auto auto auto auto auto; padding: 5px; } .grid-item { border: none; padding: 10px; font-size: 15px; text-align: left; } This contains text TH - Test Name Name: Test Name Created By: Test Created On: 5/19/2022 Status: Test VIEW DOCUMENT

Hello Assume radio buttons A,C, Z, Other, F (db gets data in this manner) we can easily sort but other should be at end of the list The order is alphabetic but other to be end Using Query Records Ant Cat Frog Z Other if we just do sort, we can get below which is wrong as per req Ant Cat Frog Other Zebra

What are the challenges or Limitations of Appian

Hi Friends I need to amend signature/image on pdf template. this pdf template having 6 pages and image should be amended over all pages all together . Is there any way or smart services or plugins in process model which help us to do the same. Regards Prabhat

Hi All - I do have Designer access to the environment, however I'm unable to open a record summary page of all the records. Once I click on record link then I am ending up with below error.  Even, while I am trying to open Appian OOTB record 'USERS', once I click on user name then I am ending up with the same error. Any thoughts pls ? Do I need to be added any system groups to view the record summary ?

How can we add something like an "Upload" or "Preview Document" button on the form that submits (typically without validation), and simply chains back to itself - this will give the user the impression they have not left the form, but turns the document into an official object that can then be previewed.

Is there any way we can build an organization chart using Hierarchy Browser Tree Component where we get data from a data subset? I tired referencing the link - https://docs.appian.com/suite/help/20.3/Hierarchy_Browser_Tree_-_Contact_Management.html. But I was not able to download the Contact Management application. Any suggestion would be greatly helpful. Thank you.

i tried but i did not get exact output, any one try this .. a!localVariables( local!expression: "x+y-x*y", local!result: a!forEach( items: enumerate(len(local!expression)) + 1, expression: local!expression[fv!index] ), local!arryIndex: { x: wherecontains(touniformstring({ "x" }), local!result), y: wherecontains(touniformstring({ "y" }), local!result), }, local!etdata: a!update( data: local!result, index: { local!arryIndex.x, local!arryIndex.y }, value: { 10, 20 } ),local!etdata)

What is map function what it does and how we use it. I see in some interfaces it has been used in ruleinputs as a datatype.

I am  facing problem  in developing project. I made relation in two table in appian cloud database. But when i insert data foreign key id is not inserted in second table. see the below screenshot when document data inserted , request_id (2nd column) will be null. 

Hi all, I am trying to solve the problem  that HTML to PDF (Page Number and Custom Fonts) Smart service Doesn't  Support Arabic language when  pdf document is generated. will this issue be solved by changing the Font document? or it's a plugin issue?

hi here i have plugged in the sub-interface in the main interface but am not able to view that interface only buttons i can see from that interface  sub-interface is working fine