Discussion Categories

Hi! I have created a node with the SyncRecords Smart Service My record to update is called: "CPF_Lineas_Pedido" My primary key is a concat() from another two fields of the record: "CONCAT_PEDIDO_MATERIAL" (f.example, "Pedido1-Rueda"). This primary key is saved in the first interface of the process The process variable which I use to "Collect" the primary keys is correctly saved:  And as you can see, all the values are the same as the records primary key By now, all the field (in which I have created/updates via Query Database Smart Service) changes are correctly saved in my DB, but not sync (I have to do it manually to see the results in my Site) Do you think the problem is because I´m using a complex primary key (Text and concat value)? What can I do to fix and automatize my sync?

Error : Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PLZG0] : An error occurred while executing a save: Expression evaluation error: Cannot update List of Dep_Record; length of assign value list (0) does not match length of the list to update (1). Desc: Have attached a file and when trying to detach the same file I am facing the above error.Please check and suggest. Code : a!localVariables( local!minimumRecord:1, local!bulkUpload: a!refreshVariable( value: a!forEach( items: enumerate(local!minimumRecord), expression: 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD'( 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{c4a92bde-e02b-4695-a292-2ff46a89c88e}createdBy': loggedInUser(), 'recordType!{f0769d64-67a8-4b44-897d-1f9e28718b03}EMP_RECORD.fields.{de5c9d80-f57b-4035-a8f0-98af6439584e}createdDate': today() ) ) ), { a!forEach( items: loc

While saving the process variable data in script task getting following error: Error writing to process variables (rank, for variable 'pv!sectionfieldmapping'., type, for variable 'pv!sectionfieldmapping'.) (Data Outputs)

How can I make my RPA in Appian accurately select the gender dropdown option based on input data in a user input form? The robot is currently unable to click the dropdown correctly, and I'm looking for alternative methods to ensure accurate selection based on input.

i have added a link in a selectable grid, when we select that row then the link should be enabled how to configure that

I have starting quarter, ending quarter ,startyear and end year. Need to get the quarter names dynamically in x axsis. For example, 01-10-2020 (4th quarter) to 08-09-2023(third quarter) Xaxsis categoreis should be Qtr4,Qtr1 2021, Qtr2,Qtr3,Qtr4,Qtr1 2022,Qtr2,....Qtr3 2023 Please any suggestions.

Hi I need to find out if a particular date which is stored in record type is from the previous month.  For example today in September I'm finding that 7th of August 2023 date (Already present in record type) is from August month.  How can I achieve this?  Please give me the suggestions. Thanks.

Hello! I need to know if it's posible to use a dynamicLink with the space bar or only can be used with the enter key? Thanks

Hi everyone, On a process instance, I'm trying to Write on Data Store Entity a string value with the following characters: Ω μs. But instead, I have the following error: "javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: java.sql.SQLSyntaxErrorException: (conn=364712) Incorrect string value: '\xF0\x9D\x9B\xBA\x0A ...' " The field where I'm trying to store the value is varchar(4000), in Appian's database cloud mariadb.

Hi! I have created an editable grid with data of a record. To store the data, I created a local variable whose value is obtained by querying the record (local!DatosLineas)  Now, I would like to configure two things: 1) By now, the values of the grid are saved in the SAME RECORD (to which I executed the query). I want to show the values of the previous Record (CPF_Lineas_Pedido) but I would like to save the values in another record (f.e. CPF_Lineas_Recepciones). How can I do this? 2) I would like to add a new column, which must show no info (empty) and be filled in manually by the user. I want this values to be saved in the same new record as the point 1) (CPF_Lineas_Recepciones) ¿How can I add a new empty column to my local variable or to the grid? I have doubts because it is something "apart" from the query, independent. And I want the values to be saved in another record.  My code is below: a!localVariables( /*mirar para incluir colum

Hi All, How to validate an email address for users which are in same organization. If I am working in a abc organization and I want to validate that if users is not a part of an abc organization should show me invalid email address in textfield object in appian and if it is a valid user of that organization doesn't show me an error. Example: 1. hdhdh@abc.com 2. xyz@abc.com 3. adrfer@abc.com From above examples that users who is a part of abc organization then in textfield show me invalid email address. So my point is in one organization I need to validate users if it is valid no error should show in interface if it is not valid user then show me an error. Please guide me how to achieve these in a!textfield() function under appian 22.2 version?

Hello, I have an issue with the card choice layout. Consider the following code: a!cardChoiceField( label: "What's the number of possible answers?", labelPosition: "ABOVE", data: { a!map( id: 2, icon: "dice-two", primaryText: "2", secondaryText: "Two" ), a!map( id: 4, icon: "dice-four", primaryText: "4", secondaryText: "Four" ) }, cardTemplate: if( rule!UNI_FN_getPageWidth() = 1, a!cardTemplateBarTextJustified( id: fv!data.id, primaryText: fv!data.primaryText, secondaryText: fv!data.secondaryText, icon: fv!data.icon

Please find the below screenshot of dropdown, in this dropdown we have few values (ex: "a","b","c","Other"). Whenever I select "Other" option in the initial time it is allowing me to Save. but after Save, whenever I'm trying to Select second time in different dropdown as "Other" option then it is throwing below error. Can anyone please help me with this?   Error: Interface Definition: Expression evaluation error at function a!forEach [line 521]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 622]: A dropdown component [label=""] has an invalid value for "choiceValues". Duplicate items are not allowed in the choiceValues array, but choiceValues was [id=, name=Casing & Cementing, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=HSE & Environmental, point=1, fluidPoints=1; 1; 1; 1]; [id=, name=Logistics, point=1, fluidPoints=1; 1;

How I make link for any page of my project . These are below  interfaces . I am in MyRequest page. How i visit to  last "Task " interface page from MyRequest page Work.....My new work.....My  task.....Task . "Work interface" is parent interface then "My new Work" is inside  the Work interface.Then "My task" interface is inside the "My new work" then Last "Task interface " inside "My Task" interface Ther are not in Records....

Actually I am having editable grid which is shown below .. contains components  dropdown and  file upload field and Text Field  I want to preload the required values of dropdown , when user opens the page he should see the grid with selected dropdown values. as shown below  all other functionality of grid will work as it is .. like removing adding new row .. please find the code-snipet attached (in the snipet Local!required Documents .. is just an id label we are storing in lookupref Table  so we can get from there) local!selectedDocuments: if( a!isNullOrEmpty(local!data), { 'recordType!{e5935b72-2349-43df-bd15-908d316468be}PRO Lead Documents'() }, local!data ), local!requiredDocuments:{198,199,191,193}, a!gridLayout( label: "", headerCells: { a!gridLayoutHeaderCell(label: "Document Type"), a!gridLayoutHeaderCell(label: "Document"), a!gridLayoutHeaderC

Hi all, I'm trying to see what is the best way to assign a minimum character number for a text component in a interface?

HttpResponse statusLine: "HTTP/1.1 200 OK" statusCode: 200 headers: Dictionary Date: "Thu, 07 Sep 2023 12:24:23 GMT" Content-Type: "application/json" Content-Length: "317" Connection: "keep-alive" Server: "Apache" Access-Control-Allow-Origin: "*" Access-Control-Allow-Headers: "origin, x-requested-with, accept, content-type, Authorization" Access-Control-Max-Age: "3628800" Access-Control-Allow-Methods: "GET, PUT, POST, DELETE, OPTIONS" contentType: "application/json" body: "{ "Apttus__APTS_Agreement__c" : { "success" : "false", "errors" : { "message" : "Upsert Agreement Failure:\n\nError Status Code: INVALID_FIELD;\nError Message: OBJ: Apttus__APTS_Agreement__c - Foreign key external ID: CO-UK-977-6935 not found for field Name in entity Protocol__c\n" } } }" Hello All,  We are getting this above error while sending data to third party system using POST MENTHOD. What mi

Hi  I want to create an interface in which a user can click on a button which will open the editable child interface and the edited values can later will be saved into the parent interface. how can i achieve this.

Hello! I am trying to figure out the best way to manage the Breadcrumbs Pattern, but I can't seem to grasp the way it is intended to be used. { a!localVariables( local!currentNodeId: 4, /* This variable would normally be retrieved with a rule like rule!getBreadcrumbsForIdentifier(identifier: local!currentNodeId). */ local!nodes: a!forEach( items: enumerate(local!currentNodeId) + 1, expression: choose( fv!item, a!map(name: "Home", identifier: 1), a!map(name: "My Documents", identifier: 2), a!map(name: "Strategy", identifier: 3), a!map(name: "2018 Road Map", identifier: 4) ) ), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!forEach( items: local!nodes, expression: if( fv!isLast, a!richTextItem(text: fv!item.name, style: "STRONG"), { a!richTextItem( text: fv!

Hii ,  I want to add value but getting erroe like - Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error [evaluation ID = PBWBF] : An error occurred while executing a save: Expression evaluation error at function 'todecimal' [line 285]: Could not cast from Record Field to Number (Decimal). Details: CastInvalid how can i resolve ? here is my code - a!localVariables( local!application: rule!GAI_getApplication(applicationId: ri!appId).data, local!grantorProjectActivityEval: ri!grantorProjectActivityEval, local!yaProgTypeId: cast( typeof(5), ( index( rule!GAI_getRefProgramType(programTypeAlias: "YA").data, 'recordType!{9d188bef-069b-4767-9d00-29432411f0cc}GAI Ref Program Type.fields.{4c3d4dd0-1f33-4086-9aee-27a44d619e83}programTypeId', null ) ) ), local!refGrantorProjActivities: rule!GAI_getRefGrantorProjectActivity(fkProgramTypeId: local!yaProgTypeId, ).data, local!metricTotal:rule!GAI_Add

I want to execute store procedure as soon as i called the rule and in this store procedure i am trying to update some of the field on the basis of conditions. At the very first time it is working perfectly fine but after 4-5 minutes something wired is happening. It is updating all the rows data and not considering the condition which we have written in the procedure. Example: SQL query which we are executing: "update projectProject set isEditMode = 1, isEditCurrentUser = @currentUser, isEditTimeStamp = GETDATE() where IDprojectProject = @projectId " 2nd time it is not considering the where condition and updating all the project. I know it is already been written that executeStoredProcedureForQuery function could run more than once, do not use it with stored procedures that modify data to avoid unintentional changes but i am not able to find any other solution. Below is the code which i am using in rule. a!localVariables( local!data: a!executeStoredProcedureFo

Hi! I´m trying to do the following query with the "query database" smart service: UPDATE CPF_LINEAS_PEDIDOSET FACTURADA = true where ID_PEDIDO = ac!pedido and MATERIAL = ac!Material The variable ac!Material can be multiple (f.example Material 1, Material 2). This is because in a previous step in the process model, the user can enter several rows. Because of using a list of string in the clause "WHERE" (I´m using it as a filter), I think I´m returning the following error: How can I fix this? Thanks a lot!

Hi, In the process model I am not able to get all data as the output. To replicate the issue please find below details The process details Could you please help me in this

Hi! I have created a process model in which the user can add new rows.  I´m saving the value of the different materials (pv!Record....material) in a process Variable ("MaterialesDefi") In this pick, you can see the value adquired and saved in the process variable. In this case: zz;vv The fact is that I want to use this materials in a WHERE clause (SQL syntax),and it is not working. Even though I tried to use a function like SUBSTITUTE() when assigning the value, trying to substitute the ; for the ",", the result of the pv is always the same I know that to use it in a where clause, I must use the operator "in" and also the string should be (string1,string2). But I haven´t managed to do so, the value of the pv! remains like untouchable What can I do?

Hi! I have made a process in which my Invoice Lines (Record 1) are set with the status "Billed" in the end, after passing multiple logics. Now, I would like to query the Purchase Order Lines (Record 2) from my process model and set their status to "Billed" too. In this case, I have to apply the following conditions: 1) The Purchase Order ID is the same as the used in my process  2) The materials of the Order Lines are the same as the ones created in the process I have been trying with the query database smart service (update-set-where) but it gives me problems when trying to filter by a more than one string (materials) How can I afford this "update" in my process? Which smart services do you recommend me to use?