Discussion Categories

A cancel button has to save one rule input and one local variable value. If we click on the button once only the rule input changes but the local saving happens only after 2 nd click. If we remove the rule input then it is working. But we need both ri and lccal variable to save its respective values at the first click of button. PFA for the code snippet. Help me on the solution a!buttonWidget( label: cons!PHSREC_BTN_LBL_CANCEL, style: "NORMAL", value: 3, saveInto: { local!currentPage, a!save(ri!buttonAction,cons!PHSREC_BUTTON_ACTION[6]) }, validate: false, showWhen: local!currentPage = 1 ),

I have a card layout as below. Can anyone help If there a way for the button to not have that extra space before and after the rich text no matter what magnification or resizing of the screen is shown. a!columnLayout( contents: { a!cardLayout( tooltip: "Only Assigned Status Tasks will be processed", contents: a!richTextDisplayField( align: "CENTER", value: { a!richTextItem( text: "ACCEPT TASKS", color: "ACCENT", style: "STRONG",

Dear Community, Good Afternoon.. I have built a case management app based on a tutorial named "IT Ticket Journey". But, due to some issues, i was unable to create a record. Attached screenshot of the error for your reference Request you to kindly look into this and guide us to a solution and also where i went wrong during this  process ?

 i want activity name in different rows if i have 5 activity name then come in five rows , like above activity i am using doc to pdf plugins is there any way to archive this thanks 

We initially developed our Application on cloud and now we setup the complete database at on-premise and I was not able to connect from cloud Environment. Need help ?

Hi all, I'm trying to use a single dropdown list to add multiple users to my grid, right now when I Select one it saves it, but if I select the dropdown again it will overwrite my first selection, how can I over come this? Basically I want to select -> save , select again -> save and so on.

Appian 23.2 We have MariaDB as a default Database. We have our SQL Server Database hosted in AWS. Can someone please provide me with the steps to create a new Data Source? Can I directly go to Admin Console -> Data Sources ->New Data Source -> Add SQL Server Details? or any additional steps that we have to perform? Thanks

Hi Team, users: "username1; {username1; username2}" =>type text how to get the output as 2 items username1 {username1; username2}

Hi All, Is Spell check is possible in Appian? Regards,Sandeep

Hi All, I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table . I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service. any ideas of what could it be?

a!gridColumn( label: "Conformance", sortField: "adherence", value: a!richTextDisplayField( label: "Adherence", value: { a!richTextItem( text: if( rule!INO_isBlank(fv!row.adherence), "-", fixed(fv!row.adherence, 2) & "%"/*text(fv!row.adherence /100, "##.##%")*/ ), link: a!dynamicLink( value: fv!row.employee, saveInto: { ri!selectedEmployee, a!save(ri!selectedEmployeeRow, fv!identifier) }, showWhen: and( and( not(isnull(ri!showDynamicLinks)), ri!showDynamicLinks ), fv!row.adherence 0, not(or(fv!row.employee.isTeamLead)) ) ),

Hi All  I have successfully configured a single sign-in solution that is working perfectly for our clients. I am also configured Attribute Mapping like Create New Users Upon Sign-In and Update User Attributes Upon Sign-In it works fine, but when it comes to Group Membership Synchronization I add one group(AD Test) in Azure Ad in which one user will be added and the same group added(AD Test) in appian under the group type (A Brand) when i try to access the appian With that user credential, I am successfully get the acess the appian  but no user will be added to the appian group(AD Test). Could you help with what I did wrong here? 

Hi Everyone, Is there any alternative to the executive stored procedure smart service which is depricated?

I am working on a project where I want to use or() function. While using the or() function I found one bug when you write any word starting with the letter "T" in the or() function you will get a true return and for any other word then "T" returns false. I am adding some images for more clear discussion. in this, I used random words starting with the letter "T" using words other than the "T"

"I've been providing the correct file path to the 'Open Excel File' action in Appian for a robotic task, yet I keep receiving an error indicating an incorrect filepath. Has anyone else run into this problem? I'd be grateful for any advice on how to troubleshoot and resolve this error."

I am trying to remove user (System Admin) from all the groups he is part of by using "Remove Group Members" and "Remove Group Admins" in a process and running it as MNI one for each group but still the user was not removed from any group at all.I made the PM lane as Run as whoever designed this process model and I am also a sys Admin but still the Smart service is not working.Am I missing anything here?

I am looking to hire an appian developer to build a BPM app on my website, to model, publish, and view simple process maps. if anyone here is interested and can provide sample work please let me know how to contact you. i can discuss it further on a zoom call.

Was the issue with Appian being unable to select the scheme in SQL server for recorded types/data stores resolved in 23.3?   Is there an ETA when this issue will be resolved.   This really slows down development on my team and makes appian much harder to use if you are pointing it to a database that has multiple schemes on it.  

Hello, I need to improve the accessibility of an interface that includes grids. In HTML, the "caption" tag can be used to provide additional description or context to an element, such as a table. However, I can't find a direct way to achieve something similar in a grid in Appian. My question is is there any way or recommended approach to add additional description or context to a grid in Appian?

Hi All, We have a scenario to extract data from PDF. In interface we have a screen to upload file and on submit starting a process using a!start process to extract data from that file. It is working fine from developer mode. when we add that screen to site document is not passing to that process, we are getting error like invalid content ID. Thank you. Priyanka

Hi everyone, i wanted to learn rpa so working on some poc, i have taken a simple example where i am logging into some website doing search and try to fetch the search result into process variable. i got the following error. what is the solution for this error?

Hi All, Scenario is we are connected to a PostgreSQL that has a custom data type, from which we we're able to create a CDT on Appian end and manage to verify it on our Data Store. for the custom data type on Postgre, we transform it to a text and it went well. However when doing a specific query to that specific field, thats where the issue persist. Can you advice on this? Data on Postgre Error when doing a query on the specific field

Hi! I have an interface in which the user can add new Rows. When the user clicks the "Completar creacion pedido" button, the values stored in my local variable are correctly passed to my rule input "recordLineasPedido".  I leave here my structured code: a!localVariables( local!LineasPedido, { a!sectionLayout( label: "LÃ%ADneas Pedido", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de pedido correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Linea Pedido"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutHeaderCell(label: "Importe Total"),

DB view associated with CDT but don't have primary Key. We used DB View in a!ExportDataStoreEntityToExcel to extract data(20k Records) into Excel File and getting an timeout Error. Is there any way to apply Composite Key for few columns on CDT to extract data to Excel without errors ? In Appian Best Practices mentioned that there is a way to apply composite key but no example. If anyone knows the solution please replay here. Thank you.

Hi, all -- I am working on a mock-up with an editable table that is not hooked up to any database. I want to make one row unselectable while keeping the other rows able to be selected. Is there anything I can put in the expression to achieve this effect for UI purposes only? Thanks.