Discussion Categories

Hello, I have submit disabled, validate set to true, required set to true but the required message only appears on one field when clicking save button. Here is my code for the amount to refund field:   a!sideBySideItem( item: a!textField( label: "Amount to Refund", labelPosition: "ADJACENT", value: if( local!updatedStatus = "Closed - Full Refund", a!currency( "USD", local!data.paymentAmount ), a!currency("USD", local!refundAmount) ), saveInto: local!refundAmount, refreshAfter: "UNFOCUS", required: if( local!updatedStatus = "Closed - Partial Refund", true, false ), required

Does appian support wild card certificates? in the form of *.dev.orgname.com

I have created a rule to display date time how to resolve it ?

I have a REST service that posts a lot of data to a table in Appian (136k+ rows).  The problem is the primary key in the service is not the same primary key that Appian is using.  I cannot match the keys because, the service's key is unpredictable.  Government data, yea!   For my REST post I simply need it to find the record with a matching value (if it exists) then update it, or else create a new record. a!localVariables( local!value: cast( 'recordType!{b44d0eeb-090e-4c8f-b858-1f684423adbc}DCQ Weekly Extract', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, /* *In

Hi All, I need to connect and post data in to an existing table in share point. How to connect with that existing table and in where can i find those details in microsoft documentation. Thanks, Ganesh.

log file name where all user data exist which contains when user got created and deactivated.

How to get an Active and Inactive users in appian .. also what was the time when  they got deactivated.

Hi All .I hope everyone is doing good. I have a scenario , but not sure if its possible / correct/not . Please let me know if any one has any ideas or any suggestions. Scenario: I have used navigation pattern in interface . This uses different interfaces in choose function and get the data accordingly .  Is it possible to do it in a single interface instead of using multiple interfaces or can we use a single grid ( instead of calling a!grid and the data for all the remaining status) and call the value in local variable and pas the local variable and get data accordingly .........! Below is the code for an idea what i am describing about . Any ideas / suggestion please let me know. Thank you in advance [emoticon:c4563cd7d5574777a71c318021cbbcc8] { a!localVariables( /* The selected navigation section */ local!activeNavSection: 1, /* The navigation sections */ local!navSections: { a!map(name: "Requested"), a!map(name: "Inprogress"), a!map(name: "Delayed&q

Hi, I am working my way through the associate developer learning path but the environment is currently down. What languages would you suggest brushing up on? I have an undergraduate certificate in programming and have recently completed a bootcamp. I have experience in - html/css - js - ruby - rails (a long time ago) - python (my favourite) - django - react Thanks in advance!!!

I have a question about the text() function.When I used "#" in the second argument to text(), the following behavior occurred.When I tried to match the digits and separators to the format,the numbers after the decimal point changed.The documentation says that "#" is a format for numbers,but does it also convert the numbers themselves? ・document docs.appian.com/.../fnc_text_text.html ↓exmapletext("12,333,333,333,333.12","##,###,###,###,###.##")　→　"12,333,333,333,333.11" is returned.

Hi  Team, I am trying to generate the excel with 100 columns in the same sheet. Since there is a limit of 50 columns per sheet I am trying to use the same service two times so that I can generate the required columns. But the issue is it is either generating the remaining 50 columns in the separate sheet or replacing the first 50 columns with the second 50 columns. Is there a way where i can generate all the columns in a single sheet? Thanks

hi,  I am trying to split a map based on user input  local!data: { a!map(id: 1, name: "Alice", age: 10, city: "New York",school:"NewYork"), a!map(id: 2, name: "Bob", age: 12, city: "Los Angeles",school:"NewYork"), a!map(id: 3, name: "Charlie", age: 13, city: "Chicago",school:"NewYork"), a!map(id: 4, name: "David", age: 14, city: "Houston",school:"NewYork") }, if I give input : age  I should get two  local!data1:{ a!map(id: 1, name: "Alice", age: 10, ),a!map(id: 2, name: "Bob", age: 12, ),a!map(id: 3, name: "Charlie", age: 13, ),a!map(id: 4, name: "David", age: 14, )}  and  local!data2:{a!map(city: "New York",school:"NewYork"), a!map(city: "Los Angeles",school:"NewYork"),a!map(city: "Chicago",school:"NewYork"),a!map(city: "Houston"

It has been a missunderstood because I scheduled the exam for today 12 AM but in my country 12 AM means at the morning, not at the evening so my boucher is no longer valid to take the exam anymore. Do you know if is there any solution to reschedule the exam to another day with the same boucher? Right now, the state of my exam is "Not show" and is not longer valid. Thanks in advance.

I have a scenario where the users is viewing an interface from a record action.   Before they click submit to complete the record action I want them to click a button that will call an integration and that value returned will either allow them to submit or not (it is a backend validation process).   Everything I am trying I run into issues because the refresh variable.The code: a!localVariables( local!loggedInUserVar:fn!loggedInUser(), local!isLoading: false, local!isValid: a!refreshVariable( value: if( local!isLoading, rule!UWM_Map_Calculate_Data( caseId: ri!case.caseId, loggedInuserVar: local!loggedInUserVar ), false ), refreshOnVarChange: local!isLoading, refreshAlways: true, ), a!columnsLayout( columns: { a!columnLayout( contents: { a!sectionLayout( contents: { a!cardLayout( conte

I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES". I started in our dev environments creating a CDT from Table/View and verifying the datastore. I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same. Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to. Thank you!

im executing a process that is returning this i dont understand why there is a comma before the result of the map which is returning errors in other nodes how can i fix this?

Hi All, For any reason I can't imagine, if you run this instruction in a rule; fn!extract("<a>some text</a>","<a>","</a>") you will get {"some text"} as a result, which is what I expected. But if you run this one fn!extract("<p>some text</p>","<p>","</p>") you get nothing as result. Another example of this strange behaviour: fn!extract("<l>some text</l>","<",">") returns {"l","/l"}, which is fine fn!extract("<p>some text</p>","<",">") returns nothing, which is inexplicably to me Any idea on why is that happenning?. I've tested that on Appian v25.1 Regards!

Hello,I am attempting to import OpenAI Sample Application.zip file into an environment version 25.1, and am getting the following error:The selected package was exported on version 25.2.0.60 and it cannot be imported or inspected on the older version 25.1.175.0. (APNX-1-4154-001)

I want to generate a table inside a word doc, below is the config of the smart service "Text Doc from Template": 

I am currently at the "Configuring Event Records" section, but the "Generate Event Record Types" button is not available for selection. I searched in the help forum, tried all the solutions provided, but none of them worked. This message always appears

We used type! to create local constants in case of CDT, but is there something similar for record types?

Hi Team, I am stuck at one point. If possible, please give your opinion. Requirements: I have a process model with a user interface. First, I started the process model and filled in some data, but I discarded the process, so the current process ended. However, the next time I trigger that process model, it should show the previously filled data, even though it was not stored in any database, as I discarded it in the first instance

Hi team , I am using record data  as source for KPI but the field name in y axis taking lot of spaces. If you see y axis taking lot of spaces ,is there any way to minimize the space

Hi Team, Where should we see the additional configurations of the web api we create like rate limit, timeout, payload size limitations, retry threshold etc? Is it modifiable for cloud environment? Along with that, I also have few other questions below:  1. when we expose our data via API, as an additional security, do we have any methods to black list/white list system IPs? 2. what's the good practice regarding rotation of authentication credentials in web api? 3. what is the typical response time for webapi?  Thanks in advance!

Hi Appian Community, Quick question: Is there any way for Appian Gen-AI to tell us how many tokens are used for a particular task, from input to output? I believe there isn’t, but just in case, I wanted to ask. The purpose of this is to analyze token usage so developers can be better informed. Thank you!