General

Hi, my trouble here is that I don't know how can I save true or false in differents boolean columns in my database. I tried something like that: a!checkboxField( label: "", labelPosition: "ABOVE", choiceLabels: { "Limpieza","Plaga","Manipulador" }, choiceValues: { "Limpieza","Plaga","Manipulador" }, value: {if(isnull(fv!item.inLimpieza),{},"Limpieza"),if(isnull(fv!item.inPlaga),{},"Plaga"),if(isnull(fv!item.inManipulacion),{},"Manipulador")}, saveInto:{ a!save( fv!item.inLimpieza, if(contains( save!value, "Limpieza" ), true,false) ), a!save( fv!item.inPlaga, if(contains( save!value, "Plaga" ), true, false) ), a!save( fv!item.inManipulacion, if(contains( save!value, "Manipulador" ),

a!localVariables( local!fieldName:"5", local!operator:">", local!value:"2", a!textField( value: fv!item.fieldName, saveInto: fv!item.fieldName, validations: { a!validationMessage( message:"test", showWhen: local!fieldName & local!operator & local!value ) } ) )This is an example of what I want to achieve, the operators can be different, the fieldValues & fieldName can be of the other fields. I want the showWhen condition to work even if I give it a string.

Hi, Our Company wants code signing enabled for all code and we use on-prem Appian. Is there any way this is possible in Appian.

What Is a function for showing array itoem in ascending or descending

Hello Everyone, I have created two schedulars through PMs that executes one by one. But sometimes the first schedular runs longer and in that case I want my second schedular to wait until the first schedular finishes. Can anyone please help me out how to acheive this? Thank you!

I know self doable feature to select time zone or internationalization setting accros all profile. But if we have many users and do not want to communicate users to do setting on their own. Is there a way to accomplish to do this. May be LDAP sync kind of?

When I am logged in as a member of Admin group the following returns a count that is different from,  when i am logged in as member of some group that is also a group member of cons!ALL_USERS Any idea why those count could be different  ? count(  a!groupmemers(     group: cons!ALL_USERS,     direct: false,     memberType: "USER" ))

Hi Everyone, what is the limit on number of rows in export to sql smart service. I had an requirement to export around one to two lakh rows in an excel. Any other way that i can acheive it if export to sql smart service had limit? Thanks in Advance!!!

Hi everyone,  I have a list of values as given below:  local!1: {a,b,c,d,e,f,g,h,i,k,l,m,n}, I want to do a loop to index a batch of value each time, for example the first batch is having index 1,2,3 (a,b,c), the next batch with index 4,5,6 (d,e,f),etc (batchsize = 3, start index +3 for each loop) I tried Enumerate() to determine the exact index of the data I want to get, but this function returns all values from 0 -> batchsize value. Is there anyway that I can get only the index I want, for example 1,2,3 of local!1 for the first loop, then 4,5,6 of local!1 for the second loop and so on?  Thanks a lot!

Facing error when testing card choice field in Appian Fitness version 23.1 Using the following format for card choice selection,  |click on card|FieldValue|choice|FieldName| 10:19:32.786 [main] ERROR com.appiancorp.ps.automatedtest.exception.ExceptionBuilder - Card Choice org.openqa.selenium.WebDriverException: unknown error: getting size failed to return xAny help would be appreciated. Thank you.

Do we have an efficient way to give warning during user upload the document in Appian? when he press "Upload" in file upload object, choose a highly restricted doc and open, then system can give a warning Popup show this is highly restricted doc, are you sure you want to upload? choose confirm then upload, cancel then purge the doc directly.

Hi community, I face an issue when I try to access safe link. I get the below error. Thanks in advance.

Is it possible to add/update Chrome Options while using Cucumber for Appian? Having an example will be very helpful.

Hello there,  I have been overall enjoying the Cucumber for Appian framework however it has severe limitations and some design decisions that I wish to change.  First of all I do not agree with the decision to place the Tear Down inside of the actual example steps. This is not good best practice as it means if you exit a test for whatever reason before the test finishes the chrome driver will not tear down. Instead this should have been put in the @after within the test running class. Can I still tear down in the @after? How would I go about calling the actual tear down method, I am fairly good with Java but I am not a developer and the code is very complicated.  My second question is that I need the ability to at times pass random values as fields for the my steps. For example our project involves "duplicate checks" and without being able to dynamically generate these fields I am stuck having to edit the test script each time. I know it's technically pos

Hello, does anyone know how I can make a custom picker to save the value if it is not in the list? The code is that: a!pickerFieldCustom( label: "Tipo de entrada", labelPosition: "ABOVE", maxSelections: 1, suggestFunction: rule!ERYM_FiltroComponente( filter:_ , labels: local!tipoEntrada, identifiers: local!tipoEntrada ), selectedLabels: a!forEach( items: ri!expediente.tipoEntrada, expression: index(local!tipoEntrada, wherecontains(fv!item, local!tipoEntrada)) ), value: ri!expediente.tipoEntrada, saveInto:

Hello Community Users I am not able to rename the web apis in Appian Designer though it is mentioned in documentation that we can rename web apis?  Any insights, why? Btw, I am able to rename other objects.

I have a read only grid with data sourcing from a record type. One of the columns in the interface has a record link field enabling it to drill down into a record summary. Is there a way we can redirect back to the interface from the record summary view? Ask is to have a cancel button that will take the user back to the read-only interface where the user started.  safe link is not an option.

a!localVariables( local!data: a!localVariables( local!dateList: todate( union( index(ri!taskProductionList, "asDate"), index(ri!taskProductionList, "asDate") ) ), a!forEach( local!dateList, a!localVariables( local!dateData: index( ri!taskProductionList, wherecontains( fv!item, todate( index(ri!taskProductionList, "asDate", {}) ) ), {} ), local!taskProduction: if( and(rule!INO_isBlank(local!dateData)), "-", ( ( todecimal(local!dateData.taskId) / todecimal(local!dateData.taskDuration) ) * 100 ), ), if( rule!INO_isBlank(local!dateData), { taskId: 0, taskProduction: 0, taskName: "-", asDate: "-" }, { asDate: fv!item, taskId: if(rule!INO_isBlank(local!dateData.taskId),0,local!dateData.taskId), taskName: if(rule!INO_isBlank(local!dateData.taskName),0,local!dateData.taskName), taskProduction: local!taskProduction, } ) ) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: a!richTextItem( text: "Selected

Hi, is there an option for a modal pop-up in Appian? Like when a pop-up will appear and the entire screen will be greyed out except the pop-up and until you select any option in the pop up the screen will remain greyed out. Can anyone let me know if possible then how can it be done?

I have two local variables storing list of numbers: How can I get coordinates from this like 1,1 2,1 3,1 4,1 based on column and row value together?

Hi, Is there any functionality in Appian to show pop-up?? If not, how can we show a pop-up without using interface and button confirmation?? Thanks in advance, Gousii.

Hello Community,Is there any way to convert a pdf or word document into base64 string or binary format ? TIA Arun

What is the difference between functions todatasubset() and a!dataSubset()  ?

I need simple solution for document to binary conversion within appian. As request body I should be able to pass a document into a binary format while calling a REST API POST method. I've followed below links and those are not helpful for me. https://community.appian.com/discussions/f/general/20675/convert-any-document-to-binary https://community.appian.com/discussions/f/integrations/14913/web-api---send-binary-string-of-document https://community.appian.com/discussions/f/integrations/18923/convert-appian-document-to-base64/75414#75414 https://community.appian.com/discussions/f/general/19821/problems-with-a-binary-document

I have a DB table with Data. I have transpose the details in front end. Please help me how to do that. Below are the screens shots for reference. In Database table is like below Desired in Appian Interface