Discussion Categories

Hello I'm trying to build interface where 2 tables are connected.Now for the first table I have interface where user can click on record action and create the record, but for the next table i want user to go under the summary of the first interface and then create record for second table which have relationship many to one with the first table. Is there a way to create record action with just pulling the ID from the summary to be associated with the second interface.So on press it will auto populate the ID where it has one-to-many relationship and user will enter rest of the information and click create.

Hi  I am using the group function to get the attributes related to the group  group(<groupId>, <property>) I am using this in an interface used on my site.  But what I have come to notice is when logging into my site as a basic user, there seems to be an issue where in the user has insufficient privileges for group() function  Can anyone please help me in this ?  Error Screenshot  

Hello I'm trying to get the task id from my read only grid with selection function of grids. I'm trying to store the task id in rule input, but what this is doing now is when I select one row it's storing all task id's in the rule input not only the single which I have selected and it's not updating the selection in the UI it's refreshing and the selection is gone. And when I load the interface by default it's showing 1 selected.I want to be able to select one row pick the task id store it in rule input and show in the UI that the row is selected, then the same if I select another one save the task id and update UI if something is unselected remove that value from the rule input and update the UI.pageSize: 20, selectable: true, selectionValue: local!report.data[1]["c19"], selectionSaveInto: a!save( saveInto: ri!test, value: local!report.data["c19"] ), showSelectionCount: "ON", rowHeader: 1

Hello,  I am having trouble getting validations to show up using a multiple dropdown component. When I pass in "Show Validation" for validations, nothing is shown on the component. When I do this for a dropdown component, it works as expected: My message is displayed with red text underneath the component. How can I show validations underneath the multiple dropdown component? Thank you, Nicholas

Is there any way to get the list of all the process model ids in an application.

How can we fetch only not null cases from this index function.pls share the detailed query

These two functions are returning the same thing.is there any difference? 

Hi Everyone, I'm currently working on a group of applications that represent different departments of the same company. We've  also implemented a Landing Page for unifying the access to a single link. The challenge I'm facing is a request to be able to return to the Landing Page from each department site. Since for each department we're using different Site objects, it's not possible to have a 'Home' on the top ribbon that allows to return to Landing Page. We can return to the interface but the other pages/page groups remain visible and the request is to have them hidden. Obviously we can create a custom link or button somewhere in the site to allow the users to return to landing page but I haven't found any good front end ideas to do this in an organic manner. By the way, the users don't prefer the icon that shows the different sites on the top right, they even requested it's removal but I don't think that's possible.  Thi

Hi, I have a word template in which Signature is a field.  I am capturing all the fields of this template in an Appian form.  I am capturing signature using signature field, I am using the XML functionality to populate the fields in the word template.  I am able to populate all the fields, but how can I populate the signature which is stored as a document in Appian.  Can you please help me? Thanks

HI All, I need some support in the  Appian reports, wherein i trying to the display the columns charts based on the custom filter set outside of the chart configuration.Is it achievable , if so can you plz guide me the steps or the method to be followed. thannks and regards, manoj yadav

Hello Team, In data model of a record not able to add or create a table.

how can I generate in this format randomly "4SpPsO&CybFwb#KeoocAeS0WFb&EPn+A*WH$g%#4" can you suggest the logic in Appian?

{ 'a': true, 'b': true, 'c': false, 'd': false } The code above should dynamically be converted to  { { 'a': true }, { 'b': true }, { 'c': false }, { 'd': false } } is that possible? Thanks in advance

In a hypothetical scenario, I have two Record Types. 'Program' is a parent Record Type of 'Course', linked by 'Program ID'. (i.e., one-to-many relationship between Program and Course) In the Program Record Type, I need to have two Views; one for Program, and another for Course(s). To make it clear, the need here is to have the View "tabs" sitting next to each other on the UI for an easy navigation between the two views. Extending on these Views, I'd like to also add the 'Create', 'Update' and 'Delete' Record Actions for both Record Types. So far so good. Where I've been stuck in my implementation is figuring out a way to pass in the 'Program ID' to the Record Actions for the Course. I have no problem invoking the Record Action using the a!recordActionItem() function, but I'll need to somehow pass in the 'Program ID' to tie newly created Courses to a Program. Am I stuck here because this

How to integrate python script into appian robotic task? I have to create an Appian BOT to convert doc file into pdf. I have created python script for that. I dont know how to intergrate it into appian rpa. can anyone describe whole process of conversion ?

Hello Team, Here i'm trying to display record data in read-only grid. Interface Definition: Expression evaluation error at function a!gridField [line 2]: An error occurred while retrieving the data for "MS Typology". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. Can someone suggest what steps would i need to take

I have a grid  where i implemented custom check box,  a!gridrowLayout { contents:{ a!richTextDisplayField( label:"", labelPosition: "COLLAPSED", value: { a!richTextIcon( icon: "square-o", link: a!dynamicLink( saveInto: { a!save({local!selectedIndex},fv!index), a!save(local!selectedrows, append(local!selectedrows,fv!item)) } ), linkStyle: "STANDALONE", showWhen:{if(and(local!editProcedures,tointeger(local!selectedIndex) <> fv!index),true,false)}, color: "SECONDARY", size: "MEDIUM" ), a!richTextIcon( icon: "check-square-o-alt", link: a!dynamicLink( saveInto: { a!save(local!selectedIndex,null), a!save(local!selectedrow, remove(local!selectedrow,wherecontains(fv!item[ recordtype!fields.id],local!selectedProcedure[recordtype!.feilds.id))), } ), have drop downs and text fields below  } Now , if i edit the row and select teh check box, it saves the updated value from the row to local!selectedrow, bu

Hi  When i am trying to access one particular interface in dashboard options getting the error like below could you please suggest on it  Error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = f4ac9:0c850] in rule 'amd_pendingtaskgrid' (called by rules 'amd_dashboard' > 'amd_dashboard_requests') : Rule 'CS_joinassigneearray' has 1 parameters, but instead passed 5 parameters. a!gridTextColumn( label: "Assigned To", field: "c23", data: if( local!datasubset.totalCount = 0, {}, apply( rule!CS_joinAssigneeArray, local!datasubset.data.c23 ) ), alignment: "LEFT" ), code in rule!CS_joinAssigneeArray: joinarray(rule!CS_getTaskOwnersNames(ri!assignees)," | ") in data local variable we are getting process report in that one particular column called Assigned to details we are getting and passing that to rule available in apply condition. Tried checking in process report in

for the text field need to give validation, when user enters the value along with text,number,special character then need to show the validation like  only alpha/letters but how can i show this, text field will allow alpha numeric and special character as well

ValidationGroup is not working as expected, when applied against a file component. It is validating entire form and not restricted to fileUpload component only.  Requirement: When user clicks on "Upload File" button it should only validate file specific validations. PS: I did try setting Validate: false for button component. But it did not work.  Thanks for help in advance a!fileUploadField( labelPosition: "COLLAPSED", target: tofolder(ri!appianFolderId), instructions: "Please click on ''Upload File'' button to upload the file in system", validationGroup: "UPLOAD_VALIDATE", validations: { if( and( a!isNotNullOrEmpty(fv!files.extension), contains(cons!VALID_FILE_EXTENSIONS, upper(fv!files.extension)) ), "", "File extension is not supported" ), if( fv!files.size > cons!FILE_SIZE, "Attachment file size is more than 10 MB", "", ), }, value: ri!uploadedDocument, saveInto: { ri!uploadedDocument }, maxSelections: 1, ), a!buttonArrayLayout( buttons: { a!buttonWidget( l

How to pass parameters dynamically to HTML to pdf smart service?

What is the best way to study for the Appian development process models section ot the exam.  I have score very low in this section of the exam,  Thank you for your help.

Hi All, I am trying to fetch data from Oracle DB using a query rule with batch size as -1, but the system is throwing the following error : Expression evaluation error at function a!queryEntity [line 2]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [DataTypeName], query: [queryentity expression], order by: [[Sort[primaryKey asc]]], filters:[((Ts= TypedValue[it=9,v=3000-01-01 00:00:00.0]) AND (Valid= TypedValue[it=3,v=Y]))]) It had data of 147 rows and if I use batch size of 100 with start index 1 it's sometimes working but when I use startindex as 101 it's always failing with the above error.I am facing the same issue with some more tables from the same Oracle schema.Here I am attachinga!queryEntity( entity: cons!DSE_TABLE_NAME, query: a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1, ) ), fetchTotalCount: true ) the sample Code I have used.

I want to create a password protected zip and while executing this plugin, it creates the zip but it is not password protected zip file. Also, while I trying to extract the files from zip, getting error for all the files in zip. I am facing the same issue with another plugin (Zip Utility -> Create Zip File) from same provider.Please check the screenshots below: 

I want to update a specific row in my recordtype with data in one of the columns as follows:  Here I am using my id (the primary key of the table) to specify which row I wish to update, in this case i want to update case number 80 and update the casestatus column with "accepted", however upon doing so I get the following error:  I am guessing that my syntax is incorrect, but I can't seem to figure out what I am doing wrong exactly.