Foundation

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process after the submission of first UIT. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected. anyone knows what's the reason for this to happen ?note : the script task is not an actual API call but just an expression rule with some dummy dataThanks

Hi All,I have few records and out of those if i am trying to open any sync enabled records it's taking more than 30 mins ,not only opening if i am trying to sync these records it's taking forever.At the same time if i am trying to create or update any value for these synched records using "Write Records" in process model it's taking minimum of 15 mins, in some cases it's throwing "system encountered an error" , but when I checked in the database the write happened quickly (<1 min). We are using Oracle Database.We are not quite sure why this is happening,any leads /ideas? Thanks in Advance.

a!localVariables( local!map1: {    a!map(Id: "Map 1", key1: "A", key2: "C", key3: "C"),    a!map(Id: "Map 2", key1: "C", key2: "A"),    a!map(Id: "Map 3", key1: "C", key2: "B", key3: "C") }, local!map2: a!map(     Key1: "ky1",      Key2: "ky2",    Key3: "ky3" /*This list can be very long e.g. Key4: "ky4", Key5: "ky5" etc.*/ ), /*code here*/ /*desired output starts - swap the keys based on mappings in map2 */ /* {   a!map(Id: "Map 1" , ky1: "A", ky2: "C" , ky3:"C"),   a!map(Id: "Map 2" , ky1: "C", ky2: "A"),   a!map(Id: "Map 3" , ky1: "C", ky2: "B" , ky3:"C"), } */ /*desired output ends*/ /*Is it possible ?*

I have an expression rule will return 2 types of record type - Case - Error depends on if there is any error occur during the expression rule process so when I get the result from the expression rule, I do need to know what type is the returned value, how can I achieve that? I tried to use typeof(), but it does not work. I am wondering if I need to use type!, but I do not know how to write a valid reference using type!

I've got a requirement that needs a expandable readonly grid, I saw Expand/Collapse Rows in a Tree Grid - Appian 24.2 in other post but this is a gridLayout which seems can't be paged But I want the grid to be paged and expandable, the collapsed rows should be just same to the main row that can be selected and has recordactions in every row How can I implement this

  I have an Interface with Cancel and Submit button. This interface also has Rule Inputs defined for Cancel and Submit. I also had defined a process model for this Interface. I have kept the process model screenshot as well to this. When I am testing the Process Model, program always goes to "Import Excel to Database node", this happens even when I hit Cancel button the Interface. I feel the button clicks are not sending/capturing the correct values onto process model. Can you please let me what am I doing wrong here?

Hello there! Here is my use-case: I have a large record type (80'000 rows), which users want to be able to filter and export to Excel. It works pretty good, but my platform admin is kind of obsessed by the health of the platform. He is afraid that many user export the whole set of data at the same time, putting the server CPU into heavy load. So it is required to limit the number of records a user can export. Did anyone ever have something similar to do? I know the limit is set to 100'000, but can we decrease the same in some Appian administration setting? I see no property in the gridField to do so, e.g. to set "showExportButton" to false if the size of the dataset exceeds a given value. Is there any? I think it would be possible to obtain something with something like a readOnlyGrid or so, but I would like to avoid it for the pain of handling filters (and pagination?). Please help!

My project exists as three environments hosted on three separate URLs with three separate app names (dev, test and production respectively).  I want to make changes to my interfaces that only render in certain environments (mainly dev) so that they don't interfere with the client's UI experience.  I was wondering if there was some sort of metadata or variable that I could use to identify them for conditional logic.  I know pp! variables do something similar for processes.  Also, using string fragments from the unique parts of the URLs might work too, but I wasn't sure what methods are the current gold standard.

I am trying to build a custom export to excel icon which should download all the filtered records to excel. I can see a smart service i.e. write data store entity to excel but that is not useful in my case since i am using record type not cdt, hence no datastore exist in my case. Please let me know do we have any possibility to achieve this or not? I think just like data store entity there should be some feature related to record type as well but i cannot see that plugin.

Hi all, i have a related action that simply update a value in a record. Everytime i click on the action a loading page appears, like this one in link: see attachment/resized-image/__size/640x480/__key/communityserver-discussions-components-files/13/pastedimage1732014098437v1.png I want to not show it, i want to be able to see my site after the action.  Any suggestions? Thanks in advice

I have a requirement to convert date to text in this format yyyy-MM-dd.  First i used this function  datetext(local!date,"yyyy-MM-dd). but it didnt work for all users time zone. so i handled timezone by adding GMT function ie  datetext(gmt(local!date,usertimezone(loggedinuser()),"yyyy-MM-dd) This time it worked for all time zone.  But when i try to execute in the script task in process model, date is coming as -1 day. I also verified override with user time zone setting in PM is already checked.  Could you someone explain why it is not working. I am attaching snapshot 1. Admin console  2. my timezone setting  3. expression rule . I am getting expected result in expression rule  with different time zone. 4. PM timezone setting  5. result in PM script task when above expression rule is executed. Anyway, i was able to find out simplest function ie text (local!date,"yyyy-MM-dd).

I am creating a cardlayout button that uses an a!startProcess link (which is shown below). On the initial grid page, I have a cardlayout button that when selected initiates a Create/Update Process model that users can update or create records for. The process model takes in a dynamic input for what type of file to create, and what location the file is associated with. The main issue is that once the user either cancels the form, updates a record, or creates a record, the form does not refresh to the initial page with the cardLayout and grid view of all the current records within the database. The data is added to the database and shows in the grid view when the user manually refreshes the page. However, the task does not exit out of the form to enter/update/cancel data. I also double checked the create(update)/cancel buttons and both have submit as true. I am not sure why the process doesn't close and refresh the initial page the process was initiated from.I should also add that th

I am using Record List on one interface. I have two questions here: 1. Can we color the Record List Header that has column names? 2. Can we freeze the Record List header when I am scrolling the bar down?

Hi, I have a process model where a rule is processed in a script task running parallel to a user input task. At the second AND gate, there are two possible scenarios: First API Call Path Reaches the AND Gate First: The API path reaches the AND gate before the user submits the task. This scenario works as expected, triggering the next chained User Input Task (UIT) in the process. User Submits the Task First: The user submits the task before the API path reaches the AND gate. In this case, the next UIT is not triggered as expected.the API call is not an actual API call but an expression rule with dummy data in output

Hi,  I have a requirement to remove attributes with null values from a cdt, so that downstream system can consume it properly.  Given: {a:null, b: 10, c: "", d: 20} Expected: {b: 10, d: 20} Please let me know if there is an easy way to do this. 

Engine start-up fails after running the start.sh|bat script. Although port 2181 is free While attempting to start the ZooKeeper server using the start.bat command with the -p <password> -s all, 2024-11-14 15:51:17,675 [myid:] - INFO [main:o.a.z.s.q.QuorumPeerConfig@177] - Reading configuration from: C:\appian243\appian\services\conf\zookeeper.properties...2024-11-14 15:51:18,707 [myid:0] - INFO [main:o.a.z.s.NIOServerCnxnFactory@660] - binding to port 0.0.0.0/0.0.0.0:21812024-11-14 15:51:18,711 [myid:0] - ERROR [main:o.a.z.s.ZooKeeperServerMain@91] - Unexpected exception, exiting abnormallyjava.net.BindException: Address already in use: bind at java.base/sun.nio.ch.Net.bind0(Native Method) at java.base/sun.nio.ch.Net.bind(Net.java:555) at java.base/sun.nio.ch.ServerSocketChannelImpl.netBind(ServerSocketChannelImpl.java:337) at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:294) at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSock

Hi Folks, How can we make appian act as middleware where frontend is built in another tech and all the business logics should be performed by appian. Thank you for suggestions!

I just tested 3 time without any changes .each time the ms getting changed. How do i know what is correct

Can I have multiple validation groups for the one sail component?  Considering I have Field A, Field B, and 3 buttons. Field A is mandatory for 2 buttons Button_A and Button_B. How to achieve this? { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Name", labelPosition: "ABOVE", saveInto: {}, required: true, refreshAfter: "UNFOCUS", validationGroup: { "Button_A", "Button_B" } ), a!textField( label: "Mobile Number", labelPosition: "ABOVE", saveInto: {}, required: true(), refreshAfter: "UNFOCUS", validations: {}, validationGroup: "Button B" ) } ), } ), a!buttonArrayLayout(

Hi, i have a scenario where if condition is true means then it has to display validation message but it was displaying in attribute format instead of message kindly suggest on this

I have a gridLayout, and I have an addRowLink where user can add row to the grid, I want to have a row counts limit like 10, when there are 10 rows, I want the link to be disabled and user can't add more rows. How can I disable an addRowLink

a!localVariables( local!num: 12345, local!reversed: 0, { a!forEach( items: local!num, expression: a!localVariables( local!reversed{local!num: quotient(local!num, 10), local!reversed: ((local!reversed * 10) + local!num), local!num: mod(local!num,10)}, ) ) })

can anyone tell me the difference between this two function's cause i unable to find any

UI

i need to display the new row with the null details in the editable grid in the interface but i am unable to do it,