Discussion Categories

I have enhancement requirement , I have editable grid and when user add new row to the grid it should be inserted before the last row ,  Is that possible if yes can anyone help to get started with? Below is my existing code   a!localVariables( local!feeDetails: ri!feeDetails, local!minimumFee: reject( fn!isnull, a!flatten( a!forEach( items: ri!feeDetails, expression: if( and( toboolean( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'] ) = toboolean(true()), tointeger( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId'] ) = tointeger( ri!selectedScenario['recordType!{94f6f945-ec9c-4178-8b3f-684a5547bb00}PRC Scenarios.fields.{ad9e991c-6487-437f-8665-fe15a96eba42}prcScenario

Hi there, I hope you all are doing well. Has anyone been able to successfully install a local version of Appian on a Mac(M2, M3, M4 chips)? If so, what documentation did you use and how did you go about it?  Many thanks.

docs.appian.com/.../appian-cloud-database-administration.html Does anyone have additional context on the reasoning behind these recommendations?  My client has hard data segregation needs and plans to use multiple schemas to address them, but we want to know more about what problems we might expect to run into.  We're using the cloud database. The biggest issue reported to me so far had to do was a problem around using compare and deploy to update stored procedures (ones that reference multiple schemas), but they found a manual workaround to mitigate that issue.  I'm curious if there's any other notable issues that can be expected or if there's any loss of other capabilities we're unaware of at this time. Thanks

Hi, I'm trying to make a form that involves quite a few layers of child records. Let's call the record types formHeader, lineItem, and itemEvent. The important part is that there are many itemEvents in each lineItem, and there are multiple lineItems in the formHeader. The idea is that you fill out the form by completing the header portion, and then there's a nested table where you can add lineItems and itemEvents. One of the issues is that those are quite detailed, so I wanted to open a modal where in step one I fill out a lineItem and then on step two I create its itemEvents in a table format, much like how related actions seem to work. The issues I'm running into are some of the stipulations. Some of the info on lineItems reflect information in the formHeader and is dependent, so I need the context of the formHeader to be available, so a create action doesn't really do the trick. I tried to get around it by creating an update related action on the formHeader and i

I have an integration with S3 bucket, which is a type of modify data. This integration pull the documents and store in folder. Now I need to provide a link to user, so that user can click the link and get the documents download. How can I do it in a single click.

Hello, again. This is a strange one.... and I'm on version 24.1.281.0 I have two expression rules... one generates some error messages (or none) and the other deals with the errors.  However, in the scenario where the first expression rule generates no errors, the second one still thinks there are errors. Expression 1: (called SH_ErrorGenerator) a!localVariables( local!stringArray: {"a", "b"}, local!error1: "", /* value from another expression rule normally */ local!error2: "", /* value from another expression rule normally */ local!error3: {""}, /* value from another expression rule normally */ local!errors: { local!error1, local!error2, local!error3 }, local!allErrors: cast( /* make sure this is list of string not list of variant */ typeof(local!stringArray), reject(a!isNullOrEmpty, a!flatten(local!errors)) ), local!anyErrors: and(not(isnull(local!allErrors)), length(local!allErrors) > 0), { errors: local!allErrors,

Hi everyone, I am encountering the following error while accessing a Record Type in one of my applications: “The configured database table is invalid. The XXXX_RF_EMP_DETAIL_STATUS table does not exist in the configured data source. Change the database table to continue.” Could anyone please guide me on how I can retrieve the missing database or what best practices I should follow in the future to ensure the database is properly saved and linked? Thank you in advance for your help!

Hello everyone, I'm having trouble synchronizing my main recordType which is called "RSD Solicitud Desembolso". I am using a Web API to perform a database save using a writeRecords()  The error it shows me is the following :  But the registration was successful in the database. :  The recordType is stuck on synchronization and doesn't change from that state; I've attached an image of the record configuration:  I don't know if the problem is due to some data type; currently in my table --> recordType I am using values ​​of type number, text, decimal, integer

Expression evaluation error [evaluation ID = 490fd:7fd56] in rule 'gse_scl_uiviewintakedetailsv2' at function a!gridLayout [line 1230]: A grid layout component [label=""] has an invalid value for "rows". The row layout at index 1 contains a component that is not supported in the grid layout. What would be the cause for this Alert.  UI is not breaking up anywhere.. got this in email

Hi there! Say I have several record types that have a postal address.  For each record type, I have to do an advanced search on the address related to the record type I would like to use a rule to create the filter, and use the rule instead of repeating the code each time. But for this to work, it looks like I have to pass each field as a separate input to my rule. a!queryFilter( field: ri!inputFieldCountry, operator: "=", value: ri!searchCriteria.country, ), a!queryFilter( field: ri!inputFieldDistrict, operator: "in", value: ri!searchCriteria.district, ), [...] Is it possible to only pass the *relationship* as input, and then say to Appian to look for the field within that relationship? I don't think it's possible, but sometimes I get surprised by some Appian magic. Here is what I tried, to no avail yet. a!queryFilter( field: ri!relationshipToAddress[{recordfieldCountry}], operator: "=", value: ri!searchCriteria.country, )

I am testing this rule by trying to update my record type. however for some reason it is returning a an integer that is the value that I am trying to update. Any help is apricated ita!localVariables( local!data:a!recordData( recordType: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership', filters: a!queryFilter( field: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{20c3732a-c9e3-4d09-8ece-06beb9f53d90}lpID', operator: "in", value:{118692,101081} ) ), a!update( data: local!data, index: 'recordType!{ccd6b9b1-562c-469f-b3e9-5c14e5166ace}FAM Limited Partnership.fields.{ede49a0e-54ac-4093-ad01-60fb29d13449}agentID', value: 123 ) )

How to get the document ID from Appian documents.

Hello- I am trying to build a plugin for my appian cloud version 25.3, I need to know to open up the input & output annotations,  1. Can you please let me know what is the jar we need to use for these annotations in the latest version 2. Also to build a plugin what are the mandatory SDK jars we need & from where can we obtain them. import com.appiancorp.suiteapi.process.annotations.*; import com.appiancorp.suiteapi.document.Document; public class SharePointChunkedUploadSmartService extends AppianSmartService { @Input(required = true) @Name("Document") private Document appianDocument; @Input(required = true) @Name("DrvId") private String driveId; Regards ANK

Hi everyone, I have an interface built using a PanelLayout. The left panel contains a sidebar with several navigation links. The right panel displays the selected content (different interfaces). The issue I'm facing is that when I open a page from the sidebar, everything works fine — the new content loads on the right and the sidebar stays visible. However, inside that loaded interface, I have more links (for example, to open details or other sections). When I click one of those links, the page reloads completely and the sidebar disappears. What I want is for those inner links to update the right panel within the same page, keeping the sidebar fixed and visible at all times. Is there a way to handle this navigation within the same interface (e.g. using local variables and conditional visibility), or any best practice for managing nested navigation inside a PanelLayout? Thanks in advance!

We have a requirement to integrate our appian workflow to cafexUI where that UI will get the active taskitems in the form of report and when they open and action any record the relevant taskitem in appian should be closed and the process model should be progressed to next nodes successfully and complete. We need approach and Error handling. We created an API which will call a!Completetask smart service which will complete the task however we have activity chaining in the process model of the task which will reopen the taskitem based on the integration node failure or it will complete when success. we need to know how to handle this?

Hi  I am getting the above error message when trying to open the particular interface in application. As per my requirement for a particular service list of 3 fee details with 4 column value will be generated and in that  i have to show 3 column in 3 row and one column should be single value . My interface configuration is attached below . I am passing all the necessary fields from parent interface yet I am getting the error .a!localVariables( local!feeDetails: ri!feeDetails, local!minimumFee: a!forEach( items: ri!feeDetails, expression: if( and( toboolean( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{be1056cb-8331-4446-8fa4-3081fc64bc73}isactive'] ) = toboolean(true()), tointeger( fv!item['recordType!{f6895dd9-7b01-4146-a52e-be727fef79d3}PRC Vmap Service Fee.fields.{30de7239-941c-401f-ad56-2672421eba71}scenarioId'] ) = tointeger( r

I am encountering a very strange situation in Appian. I have a parent interface that has a choose function determining which child interface to display. Within this choose function there are 5 interfaces. When I attempt to access the parent interface I am presented with the following error.   However when I go into the interfaces listed in the error, I am presented with no error at all. Strangely enough when I remove a different interface in the choose function, not the one listed in the above error, the error vanishes. Within this second interface there is also no error. I would really appreciate some guidance here because it seems like Appian is conjuring an error our of thin air. On top of all that, this error is only present in our test environment and not our dev environment. Below are some additional screenshots. Choose function with all 5 interfaces: Configurations that do not generate the error:  It almost seems like the interaction between the first and last in

I have a folder containing several RAR archives that I need to convert into ZIP format for easier sharing and compatibility. Manually converting each file takes too long. Is there any reliable software or method that supports batch RAR to ZIP conversion on Windows? I’d prefer a tool that maintains file integrity and doesn’t require extraction. Any recommendations or step-by-step guidance would be appreciated.

I have a requirement in Appian.Let's assume I'm logging in from India, so my Appian application time zone is set to IST. However, the requirement is that — regardless of the user's time zone — all date and time values should be displayed in CST on UI How can this be achieved in Appian?

Hi Everyone, I'm faced this error  Query execution was interrupted (max_statement_time exceeded) two days in the model. Process model calls a SP which truncates the table an reset the autoincrement value of the primary key. This models runs twice in a day and this node failed in first run of the day for two days by throwing this error.  I'm aware why this error comes but nothing much to fix in the SP and also table didn't had much rows as well its around 800 rows. It might be DB usage might be high at that time but how i can confirm that from logs please let me know for suggestions. Thanks, Bhargavi P.

Hello everyone, I have an expression rule where i am querying the record type and after querying i need to apply certain condition to further filter the data. And in the Interface, I stored this rule in the local variable. If I pass the local variable to a grid Field data in the read only grid. It's throwing me this error. I tried recordData(), but after querying the record, I need to apply certain condition to further filter the data.Is it possible to use local variables inside the record type.

The results are in, and we’re excited to share what our developer community had to say about their Appian experience this year. Participation has doubled compared to last year, and the findings speak for themselves: nearly 90% of developers would recommend Appian, reporting high career satisfaction and growing enthusiasm for certification across the community. Check out our blog post to explore the full findings and share the highlights with your Appian network.  Want to help shape next year’s results? Join Appian Community today!

While i am practicing , i created a record type and when i am trying to generate record event types , i am getting an error " You must have edit access to at least one of the applications this record type is in to generate event record types ". Please suggest here, because i am the application creator , still i am getting the error.

I have the following code snippet from an interface expression that is not updating the refresh variables. I have confirmed that local!refresh updates on record action as it is supposed to, but I cannot get local!selected_tasks or local!expired_tasks. I have tried multiple different configurations of the refresh parameters inside a!refreshVariable() as you can see from all the commented out portions, but none of them seem to work. I removed all of the record type references in the code, but I assure you they are there in my actual expression. Any insight would be greatly appreciated.local!refresh: a!refreshVariable( value: rand(), refreshAfter: "RECORD_ACTION" ), local!selected_process_ids: if( a!isNotNullOrEmpty(ri!clientSignOffProcess), ri!clientSignOffProcess[], null() ), local!selected_workflow: ri!clientSignOffProcess[], local!selected_tasks: a!refreshVariable( value: a!queryRecordType( recordType: , fields: { }, filters: {

This may be an odd request, but can I call deployments api v2 in the lowest environment (dev) to get the export log files associated with a package? I ask because in Admin->Infrastructure, we have enabled incoming and outgoing external deployments only for our 'next' environment (SIT), and adding new environment doesn't allow self-reference. My connected system seems to be failing and suspect that enable incoming / outgoing is only set for 'SIT' environment. The motivation for the ask is to grab the export logs of a package at the dev level to load in unexported precedents for further processing. Thanks for any insight, Eric Casteel