Discussion Categories

I have an integration requirement where the system to which I want to connect Appian with needs an Authorization Header which is in the format as: Signature keyId="<8>-<4>-<4>-<4>-<12>",algorithm="hmac-sha256",headers="(request-target) host date",signature=”**” Has anyone done this kind of integration? Note: The swagger provided doesnt have any authentication details in it.

Hi everyone Here's my scenario: I need to use a Group Browser object for the user to be able to select a group from a list . I can set the initial group as All Users, but that includes groups that may not be selected, such as Administrators. It would seem my easiest method would be to create another group which lists only the desired groups, but I've been told that nesting groups within groups is bad practice. Any thoughts? Blessings Stephen 

Hi everyone, Happy 2023. I've got a question about service accounts: we've got a single environment with no Dev + Test + Prod set up. Just one environment a number of devs at our company all use. A sort of "sandbox" where we have a number of applications. As an example, if 10 of us each had their own application that had an RPA object and a Connected System object (ie: for Portals).... would we need 20 different service accounts with 20 different API keys? Or, can we use 1 service account (+ its API key) for everything? Many thanks,Uel

Hello, I'm new to Appian, and I'm trying to build main page report which is quite similar to this "Form steps". However, each step has to show specific interface by using rule!tInterface1. My question is how can I check the validation for all of these steps at the end of the report and show a summary for all of the errors, e.g. "Step1 has an error". P.S. an error sign appears by "default" in the section that contains an error, Can I check if the section has this sign or not? Thank you in advance!

I was working through one of the modules, went and had a meal, and suddenly the curriculum itself is gone. I have the linked bookmarked so I know it is not a URL error. Even if I just google "Appian curriculum" and try to find it, the link that would ordinarily take me to the developer page says 404 not found. 

As I'm going through the Appian Developer course I have noticed that some information is missing when trying to pass the quizzes. I am completely stuck on Expressions. Is there something else I should be doing besides the Developer course? 

Hi All, I have numbers between 100-200 and I want to display the 5 multiples and 5 included numbers. Sample output: 105,110,115,120,125,130,135,140,145,150,151,153,154,155,156,157,158,159,160,165,170,175,180,185,190,195,200

By clicking on relation action button present on summary page, user should redirect to summary dashboard of newly created record . Is there any possibility like this? Can anyone pls suggest me a solution for this?

please tell me how to validate email address without regex means with the help of like function .  I am writing this expression : like(ri!email,"*@gmail.com")  but i want to validate every field like first character should not be digit and all .help me to sort out this 

Hi, everyone I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code. If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it? Thank you.

Inside Summary View of Record when clicked on Related Action to edit the record, dialog box is not displayed inspite of that task is getting assigned in tempo inside task tab.

Good day, I'd like to implement a search function in an interface, but I'm struggling to make it work. Once the user types in a search term and presses the search button, the appropriate results should return. The code :  a!localVariables( local!search: false, local!searchTerm, local!searchTitles: { "Amadori", "Telpark", "Microsystem", "Kone" }, local!searchData: a!dataSubset( data: rule!JT_CONS_CASE_STUDIES(), batchSize: - 1, startIndex: 2, sort: a!sortInfo(field: "title", ascending: true) ), local!searchField: index( local!searchTerm, wherecontains(local!searchTitles, local!searchData) ), { a!sectionLayout( label: "", contents: { rule!JT_uiCaseStudyDashboard(numberOfColumns: 3) }, showWhen: local!search, isCollapsible: true ), a!sideBySideLayout( items: { a!sideBySideItem( item: a!textField( labelPosition: "COLLAPSED", placeholder: "Search Use Cases", value: local!searchTerm, saveInto:

Hi, I have a requirement to send certain email based on few business rules. Also based on some logic ,we need to send email by passing priority High or Low dynamically. But with the send email smart service which we have , its a dropdown and we can't pass this value via expression editor. Any way to achieve ?

On file upload I want to change [Document:1234] to fileName.png.Here is what I have currently I've tried various expression inBut whatever I do, I don't get the filename saved in a variable.Things tried include (but I may have done them wrong): using a a!map using the document(documentId,"name") however [Document:1234] is not a number using a!replace(pv!file,"Document:",""), and that did not work I simply need to get the Document Id value so that I can use the document() function.I feel that I'm running out of things to try.Here is my input

Code snippet below shows a filter for field test whose value is reviewing. a!queryFilter( field: recordType! a.fields.test operator: "=", value: "Reviewing" ) How can I filter field test whose values are "reviewing" or null?  I should be able to get rows 1 and 2 test 1 reviewing 2 3 resolved

In DB I have some records with only Date and some records with date& time Example: 2/1/2023 1:22:31 PM 10/17/2023 11/15/2023 7/07/2022 6/17/2022  2:22:32 AM 11/17/2022 9/28/2022 9/28/2022 i need to filter it out with only date but where ever time records available those records unable to filter it out a!queryFilter(field: "date",operator: "=",value: ri!date) can someone help me with this

How to index values from Record Type. For Example: how to index location from this 

Any idea on how to cast cdt to record type

I have a simple stored proc as following. DELIMITER $$CREATE DEFINER=`dbadmin`@`%` PROCEDURE `Test_TruncateTable`(IN `spTableName` TEXT) MODIFIES SQL DATA COMMENT 'Truncates staging table.'BEGIN TRUNCATE TABLE spTableName; END$$DELIMITER ; The procedure won't get executed, it throw's following error. #1. #2. I tried changing the IN parameter to VARCHAR etc. but no luck. In past I have wrote more complicated procedures having multiple parameters however never run into the above mentioned error. 

Hi, Can someone guide me on the requirement. I would like to know what type controls I can use to achieve this. 1. Display the data in a grid format with a link under Sno column data. 2. "ADD" button on top right. When the user clicks on that I need to show a separate screen with F. Name, L.Name, Address text fields and allow to click on "SAVE". Once user clicks on "SAVE", data should save to the database and come back to the below screen. 3. If user clicks on the data link under the Sno, then I need to open show a page with F.Name, L.Name, Address with text fields and need to load respective data, once if they modify and click on "SAVE", I need to save the updated data and come back and load the below page. ADD Page EDIT Page

Hi All, I have an external report where i will be pulling data into Appian. When am storing fields into Appian i could see space is replaced with "non breaking space". for ex: IN Appian DB: In External report: Can anyone suggest why this is happening ?

Hi, what we need to do if process model is consuming a lot of memory and due to  this appian environment getting very slow.I have already set archive (3) day from data management tab. Is Manually delete processes that have already been completed or cancelled is a another good option?

Hi All, We encountered a challenge with the Radio Button Component. Under certain condition it is loosing or 'forgetting' the selected radio button. We are using it to display the status in a workflow. Based on the users role and the status the entity is in, only certain options can be selected, so we are adjusting the choices. Below is a code example what we are doing. As you might see, if you select option 3, it stays only a split second on the UI and then the selection disappears. And yes - we alreadyhave submitted a support ticket to Appian, but it looks like the component will not be changed.  Any suggestions how to overcome this? We have our own ideas, but would like to see first what the community will contribute.(We will publish our version tomorrow). Thanks a!localVariables( local!selection:1, local!choices:a!refreshVariable( refreshAlways: true, value: if( local!selection = 3, {1,3}, {1,2,3} ) ), { a!radioButtonField(

Hi, Is it possible to pass the entity name dynamically or using the table in query entity? May be have some rule which will take the table name and return the data store entity. Regards, Mukesh

Hi all, I want to replace each "trackerID" from local!test - local!test4 variables with a correct trackerId from local!Ids. Current values in dummyCDT are indexes of their corresponding IDs in local!Ids array.local!Ids values are {24912; 24913; 24914}  a!localVariables( local!test: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 1), local!test2: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test3: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 2), local!test4: 'type!{urn:com:appian:types:DBS}DBS_Tracker'(trackerID: 3), local!dummyCDT: union(union(local!test, local!test2), union(local!test3 ,local!test4)), local!Ids: index(ri!tracker, "trackerID", null), a!update( data: local!dummyCDT, index: "trackerID", value: index( local!Ids, local!dummyCDT.trackerID, null ) ), ) Is it possible to achievable this way?