Discussion Categories

a!buttonWidget( label: "SUBMIT", submit: true, style: "PRIMARY", loadingIndicator: true(), showWhen: local!activeStep = length(local!steps), confirmMessage: "Do you want to continue and submit data?", confirmButtonLabel: "SUBMIT", cancelButtonLabel: "CANCEL" ), Hi All, I have a form for the user to add some required/ optional fields, right now my confirmation message in the submit button shows before it validates the required fields. So it shows confirmation message, and then  shows the red field validations- instead I would like to see those validations immediately once I click the first submit, instead of after the confirmation message.  Is there a way to show the confirmation message after the button itself has validated that all required fields are filled in the form? or show confirmation only when all required fields are filled in

Hi , Can anyone please help me with this issue! Thanks for the help in advance. I have an interface , i have used a!gridfield(). In the grid of the column is the date received. The error says that at function a!gridfield cannot apply operator[LESS THAN] to field [Daterecieved] when comparing to value [TypedValue[it=7,v=2024-09 -27] a!gridColumn( label: "Average customer rating", backgroundColor: a!match( value: tointeger(today()-todate("9/11/2024 12:00 AM")) whenTrue: fv!row < 10, then: "NEGATIVE", whenTrue: fv!row > 20, then: "SUCCESS" default: "NONE"),Here in above value: I am calling fv!row[recordtype!abc,daterecieved] , above is just a single value. Thanks for your responses . But Sorry my bad , its actually fv!value which i have given. Below is the code: a!gridField(label:"Rating Grid",data:local!data,columns:{a!gridColumn( label: "Average customer rating",sortField: reco

is there any way to cast from record type to map for me it  didn't worked cast( type!Map,{'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field'('recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{f5fe89e3-be39-448f-b18d-61ab47caa97b}escalationFieldId': 14069, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{cbe43a10-86dc-41f2-a4f9-4beea7e8fc4a}escalationPathwayId': 387, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{3437a64f-dac3-407a-a089-7e9d64dca973}isRequired': true, 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{571d49da-e656-4d6e-b6d3-bcfe8392f1b1}visibilityStatusLookupRefId': fn!tointeger(null), 'recordType!{5996ab3d-2bdd-4f15-b862-b5e940227d63}XEP Escalation Field.fields.{166243bd-ab58-4b6c-a50f-613b8c6e48c9}autofillSourceFieldName': "description", 'recordT

Hey everyone, when i was doing the step by step i encounter this problemand because of this i cant find the AS_VEHICLE table to continue the exercise.Can someone help me please?

I have created an interface for Job On boarding application. I put cards as choices to record Candidate Status whether Selected/On-Hold/Rejected, what I want is after selecting anyone of the cards It throw Confirmation message like "Do you want to Continue?". Whether it is possible? If possible, means give me a solution for that.  ps: Due to server issue I have not get the exact cards. This is for reference

Hello all, want to compare all constants from one environment to other environment, we have more than 15K constants and want to add in one package, is there any way to add all constants in one package?  Thanks, Bhushan J

Hi Everyone,  I recently created test cases for 100+ expression rules. When I tried deploying to higher environment, even though the deployment was successful - the test cases are not deployed for all expression rules. Only 2 expression rules got their test cases while others did not. Looking for some reason why this might happen?

Hi, I've one scenario where i need to display data as per the filter selection, and in filter i have a date range field where user can selection up to 2 years range and data would be displayed on grid as per the filter selection.please suggest best way to do display data on grid and to export data on excel.I am using record type, and i have a date column at backend.

Is it possible to use a third party vulnerability scanning software to scan Appian code for vulnerabilities? I saw a similar question asked 7 years ago and the answer was no and just wanted to verify that nothing has changed in that time. 

Hello, I am an APPIAN newbie and during my day to day activities get to query the backend data. Sometimes the app's request table in the SQL database shows a task assigned to a group and is displayed as follows: [Group:442658].Question is: how can I track the actual Group by this number, and lookup its name and members? What is this number, is it a UID? What permissions I need to have to query this information in the APPIAN designer? Thanks in advance.

Hi All, Currently I have an interface where we allow the user to upload documents, we wanted to see if it was possible after the user clicks upload they can see the actual document before the submit the form, that way they "make sure" it is the correct document. Is this possible in appian at all? thanks in advance

Hi, we are having a problem executing an expression rule, which contains an a!queryRecordType, where we have: - 1 grouping field - 1 measure field - 4 filters,  on a batchsize of 500 items. In detail, every time we try the rule from expression rule the result is correct but when we insert it in a script task from process model it randomly gives wrong results (correct measure corresponding to wrong group fields). A delay of 1 minute after last node has also been inserted in the process  activity. What could be the problem? Thanks,  Francesca

Hi Team , I am getting this error in the grid field Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!gridField [line 173]: A grid component [label="Search results"] has an invalid value for "columns". A grid column [label="Relationship Manager"] has encountered an error. Expression evaluation error at function 'like' [line 229]: A null parameter has been passed as parameter 1.

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

I have an integration that I save the output into a DataSubset object and want to use to update a table in the database with a Query Database task. The DataSubset is as followed: DataSubset startindex null ... data [List of Dictionary - 1,000 items] Dictionary EMPLOYEE_ID "1" PAY "Hourly" ... In my Integration task, which is the first task, I save the output to a Result variable (which is type of DataSubset). Now in the next task, I add a Query Database task that I want to use to update a table where the EMPLOYEE_IDs match Would it be: "Update users set pay = ac!Result.data.PAY where employee_id = ac!Result.data.EMPLOYEE_ID;"? This doesn't seem to work. What am I doing wrong or what's the right way?

Hi, We are trying to configure SAML SSO with Azure AD for a customer with Appian cloud. We need the Service Provider Signing Certificate and Service Provider Signing Certificate Password but we are not sure if this information is provided to us by the IDP, if we need to ask Appian for it through a support case or create a self-signed certificate as described here community.appian.com/.../kb-1108-how-to-create-a-self-signed-certificate-for-saml-authentication. I have reviewed the documentation for SAML configuration docs.appian.com/.../SAML_for_Single_Sign-On.html but I cannot find further information about these two fields. Thanks in advance

Hi All, We have requirement  that when we configure URL in interface that should allow access to microphone and camera. Existing webContentField() doesn't support this. Code snippet for reference a!webContentField( source:"">whereby.com/XXX)  Any pointer regarding will be helpful Thanks

Hi all, I'm a beginner of Appian, and I am required to change the font size of header in read only and editable grid... Is there any way to change them? According to richtextdisplayfield, this seems to be only applied to value... not label in grid column... I need your help. Best regards,

Hello Community,I'm facing "An error has occurred during the execution of the smart service activity."  while executing Robotic smart service. I have uploaded some Macro Files and passed as an input. But, Robotic Tasks smart service execution is failed. When I passed similar kind of Macro files then it executed well earlier. I'm unable to figure it out. Can anyone help me on this. 

Hello Community,I'm facing "An error has occurred during the execution of the smart service activity." error while executing Robotic task smart service. I have uploaded some Macro files to perform RPA, but its unable to execute, showing the mentioned error before execution itself . I'm unable to figure it out. Can anyone help me on this.

can someone provide the best answer for  this Appian ACD exam question it has many answers 

"I'm encountering an issue with updating an array in costAdjustments. The current code is setting the LengthOfMonth field to 6 for all items in the array, but I only want to update specific entries." a!save( local!newEstimates2, local!newEstimates2: a!forEach( items: local!newEstimates, expression: a!update( fv!item, "costAdjustments", a!forEach( items: fv!item.costAdjustments, expression: a!update(fv!item, "LengthOfMonth", 6) ) ) ) ) This isn't exactly what I need. What I want to do is loop through newEstimates and pull data from local!uniqueContractPeriods, which contains three rows of data with the fields: period, periodType, startDate, endDate, noOfMonths, and noOfDays. When the contractPeriodNum in costAdjustments within newEstimates matches the period in uniqueContractPeriods, I want to update the LengthOfMonth in newEstimates with the value of noOfMonths from uniqueContractPeriods. Below is the code I&#3

Hi! When I use an integration in a process model, I get the following error:The integration execution time exceeded the configured timeout.However, the service I invoke through the integration works fine, only the Appian integration gets the error even if it worked as expected. How can I fix this? Is there a way to give it more time so it doesn't get error by timeout?

Hi Appian Developers (and Community of course), I hope that somebody from the Apprian Dev Team could answer / provide info. I'm using the Styled Text Editor Component component (a!styledTextEditorField) to display content stored as HTML (display only, no edit required). I'm wondering that is the exact maximum allowable value for the Size limit parameter?  When I set 100K, it prompts "You reached the maximum character limit. Remove characters to continue." (it is an email conversation stored as html and it is expected to be large in size). When I reduce it to 99K (set value for Size limit parameter to 99K), the error is gone. Obviously, it lays somewhere between 99K and 100K but I would like to know what is the maximum allowed, to be able to display as much as possible of the text. Or does it maybe depend on the encoding - single-byte/multi-byte? However, the documentation states "... The parameter value is about equal to the number of charac

I have an interface with a link(Open URL ex. https://) that opens a new tab/window. The new tab/window initiates a process, and I would like this window to close automatically once the process is completed. Is there a way to achieve this in Appian? Any guidance or code examples would be appreciated.