Foundation

Hi! I was trying to pass a local variable values (editable grid in which you can add several rows) to a process model, so that I can use the Write Records Smart Service At first, I did it this way: But I would like to know how to transfer this and save into my record (probably best way via process model) The entire code is: a!localVariables( local!grid, { a!sectionLayout( label: "LÃ%ADneas Factura", labelIcon: "list-alt-solid", contents: { a!gridLayout( label: "A continuación, incorpore las lÃ%ADneas de factura correspondientes y pulse el botón de creación", headerCells: { a!gridLayoutHeaderCell(label: "Factura"), a!gridLayoutHeaderCell(label: "Pedido"), a!gridLayoutHeaderCell(label: "Proveedor"), a!gridLayoutHeaderCell(label: "Material"), a!gridLayoutHeaderCell(label: "Precio Unitario"), a!gridLayoutHeaderCell(label: "Cantidad"), a!gridLayoutH

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 ?

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.

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?

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 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?

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 -- 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. 

Hello everyone,  I am getting a base64 value as a request. But I am unable to convert the base64 value into an image document. As a result record is not getting stored into the database table. Is there any way to convert the base64 string into document?

We are hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Actively hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

I have two process variable that is CDT type. I need to if any of the process variable is null then related to that process variable entity data not executed. Like this:  = {    if(    a!isnotnullorempty(pv!dependencies),             null,    a!entityData(             entity: cons!DSE_COMMUNITIES,          data: pv!communityAllocation  ) ),     if(    a!isnotnullorempty(pv!dependencies),             null,           a!entityData(               entity: cons!DSE_DEPENDENCIES,               data: pv!dependencies    )  )} But it gives error: An error occurred while trying to write to the data store [Tables]. No values have been written. Details: org.hibernate.PropertyVal

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Should able to Select only one radio button from the grid as shown in the below attachment. a!radioButtonField( label: "Sort On", labelPosition: "COLLAPSED", choiceLabels: { "Yes" }, choiceValues: {true()}, value: fv!item.sortOn, saveInto: {local!sort, a!save(local!sortIndex,fv!index), a!save(index(ri!input,"sortOn",local!sortIndex,{}),true())}, choiceLayout: "STACKED", validations: {} ) How to achieve this please suggest.

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( and(local!input1[fv!index] =1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( or(local!input1[fv!index]=1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( local!input1[fv!index] =local!input2[fv!index], 0, 1 ) ) ) )

Hi, Do we have any chance of removing the above highlighted mail ID and change to custom mail ID?? Thanks in Advance, Gousii.

Can I use same interface for 2 related actions . If a user is from group1 the related action as "group1 approval" and if user is from group2 then relatedaction is "group2approval".on approve of group1 ,some fields gets updated in db and upon approval of group2 some fields gets updated (like lastupdatedby ,status)  ,all fields are common in both the interfaces ,upon approving from group1 it shows status as "group1 approved" and if group2 approved then status as "group2 approved"

How to show multiple dropdown using the record type. The field in record type cannot be made multiple, only the record type can be made array. How to achieve this

Hi, I'm getting this Authentication failed when I replay the script. I made the user as an Admin account, added the CSRF token in the header but still the authentication fails. We have Okta SSO enabled for the application. I'm able to successfully pass through the Okta authentication via JMeter and the subsequent Appian request are failing with the above error code. Thank you for your input! Best, Manisha 

 Is there any way to check how each node of a process model is performing? Like how long a node is taking to complete. I know we have two(Default Process Model Optimization Metrics,Default Process Optimization Metrics) out of the box reports present in appian objects but can we use them if the process model does not have any attended nodes? or is there any way around to get this info?