Foundation

Hi All, I need to show one validation that - throw error if they enter anything apart from 0 to 9 and .  How can we achieve that using some functions in appian Can Someone suggest for this?

a!localVariables( local!items: { a!map(id: 1, value: "a|b"), a!map(id: 6, value: "a|b"), a!map(id: 8, value: "a|b") }, local!sortedData: { a!map(id: 8, value: { "a", "b" }), a!map(id: 2, value: { "a", "b" }), a!map(id: 8, value: { "a", "b" }) }, a!columnsLayout( columns: { a!columnLayout( contents: { a!forEach( local!sortedData, if( mod(fv!index, 2) 0, a!multipleDropdownField( label: "Item" & fv!index, choiceValues: { "a", "b", "c", "d" }, choiceLabels: { "a", "b", "c", "d" }, value: touniformstring(fv!item.value), saveInto: { fv!item.value, a!save( local!sortedData, append( local!sortedData, a!map( id: count(local!sortedData) - 2,

Hello, We are using the send File Over SFTP node and we have a doubt if we set the following attribute to true, would it take the user and the pass defined in the third party? We do not have a private key. We ask this question and we do not test it directly because in the development environment we cannot and we have to promote the environment to be able to test it but not to go up blindly, if someone had fought with this it would be of great help. A greeting and thanks in advance

Hello, I have a record that includes a filter search functionality. I want to add a Help Tooltip on the interface to indicate which columns can be searched. I prefer not to use placeholders, as there are multiple columns available for searching. Please suggest an approach.Thanks 

I have an integration that calls an api which downloads document from external system. How can I implement a link that user can one click download the document that is returned from that api? like documentDownloadLink(), but I guess it can only be used for downloading documents that are stored in Appian? My requirement is that user don't want Appian to store the documents copy, so I can only call the api to get the document

Document preview field not giving the document preview, showing the following error. By clicking one the link in the error the document can be downloaded successfully. How can this be fixed

Hi All,We want to know how Appian licensing works. Lets say the current license is for 3 applications and 50 users. So what happens if we have built more than 3 applications and onboard more than 50 users. Also what does this 50 users mean?? Does it mean number of users who can access appian concurrently or only 50 users can be onboarded? Does onboarding more users/applications cause any performance issue to the overall application?

I have a use case to not to allow the user to download the pdf document but he should be able to view it.Do we have any possible ways to achieve this with or without the PDF Viewer in Appian?

Dear Appian Community,Working on the Step-by-Step # 5 exercises, after have completed the Edit Record List section, I saw the image displayed for all records was the generic image, I opened the Cloud DB and confirmed the Image column in table AA Vehicle is Null. Could you please let me know how can I fix this issue? Maybe running a script to load the content of the table again or something like that. Any help would be greatly appreciated.Thanks in advance,Jose Castellot

Hi I am uploading documents while raising request after submitting the request the documents which i uploaded is showing in different order means the doc was not showing according to the order i uploaded  there was query rule which was showing documents by extracting from DB the query rule itself returning document details in different order like below there was no sort defined in query rule too kindly provide your thoughts on the same logic in query rule

I'm not able to receive mails sent from send email service to my outlook .I don't see any errors as well . can someone please help.

Map mailList of Text String - 3 items "test@gmail.com:1"(Text) "test2@gmail.com:3"(Text) "test3@gmail.com:3"(Text) period"01/2024"(Text) Map mail "test4@gmail.com:4"(Text) period"01/2024"(Text) above is the result of expression rule i want to remove mail  and make value like test@gmail.com as key and numbers that are after : as value  and leave period as is  Map "test@gmail.com:1"(Text) "test@gmail.com:1"(Text) "test@gmail.com:1"(Text) period"01/2024"(Text) can i get result as this 

In what scenario i can go for MNI?how to configure it??could anyone help me out on understanding it clearly.

I have changed authentication type to OpenID connect  in Connected system. when I'm trying to deploy it to other environment I don't see any keys to change in Property file .Can someone please help .can I deploy it directly without property file?

I am trying to understand when the appian save data type should be used, reading the documentation I do not see a clear example of use. Can someone tell me if they use it and when? This is the associated documentation https://docs.appian.com/suite/help/24.4/using_interfaces_in_appian.html#creating-reusable-custom-components docs.appian.com/.../Appian_Data_Types.html

i have this query to run in database table to export some data,but its throwing an error like this: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'LIMIT 0, 25' at line 45 below is the query: SELECT DISTINCT ITS_MATTER_NUMBER, REQUEST_DATE, REQUEST_TYPE, REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NUMBER, COLLECTION_VENDOR, RECEIVER FROM ( SELECT DISTINCT ITS_MATTER_NO AS ITS_MATTER_NUMBER, TO_CHAR(CREATE_DATE,'MM/DD/YYYY') AS REQUEST_DATE, REQUEST_TYPE, CFA_DM_ED_REQUEST_HDR.STATUS AS REQUEST_STATUS, CUSTODIAN_NAME, CUSTODIAN_WWID, JNJ_MATTER_NAME, JNJ_MATTER_NO AS JNJ_MATTER_NUMBER, CFA_DM_ED_COLL_VENDOR.COMPANY AS COLLECTION_VENDOR, CFA_DM_ED_PROD_RECEIVER.COMPANY AS RECEIVER FROM CFA_DM_ED_REQUEST_HDR LEFT OUTER JOIN CFA_DM_ED_PROD_RECEIVER ON CFA_DM_ED_REQUEST_HDR.REQUEST_ID = CFA_DM_ED_PROD_RECEIVER.REQUEST_ID_FK LEFT OUTER JOIN CFA_DM_ED_COL

I have requirement to show a specific page of a document in the document viewer component. Is there a way in Appian to achieve this?

Appian Community Team, I have a Site which 5 Interfaces in it. Please see below screenshot for reference. If I want to add KPI, where should I add it? Is it to all individual interfaces or should that be added onto the Site Page? If its on the Site page, can you guide me here please. I am new to Appian and I am open for suggestions here. Regards, Mahesh

Appian Community Team, On the Appian Home Page, I see Reports in the Menu. Can you please fill me in with details on what that is for? How I can have some of my Site Reports appear under Home Page Reports Section? I am new to Appian, I have developed a Report in Interface using PieChartField, can I have that Interface appear under Home Page Reports Section? I have provided screenshot for what I am referring to on the Home Page. Regards, Mahesh

I conducted a test where I copied a tab character from Notepad and pasted it into an Appian text field. Appian recognizes the tab character as a special character rather than treating it as empty spaces. How can I configure or validate this so that Appian treats tab characters as empty spaces? Any insight would be appreciated.

I'm having an issue where the browser data loss popup shows up when I click on a a!safelink from a form. The link is configured to open a mailto window in a new tab, so no data loss should be occurring. I'm wondering if there is a way to disable this popup somehow, my assumption is no, but I wanted to check here and see if anyone had any suggestions.

in dropdown i have to show default values then it has only single value if dropdown has multiple choices i can show then value will be null ex: here detail has many values this i have to show as it is no change in this  this dropdown has single option so need to show that by default 

Hi All, I have a paragraph field (* Required field) in an interface. When I input Enters or Spaces or Tabs only and no other characters it is consider as a value and not firing the validation error. For user it looks like empty values and validation didn't fired. Need a validation so that Enters or Spaces or Tabs only are not considered as va[lues. a!paragraphField( ..... validations: ??? ...... )

This is the code i wrote my requirement is to im fetching the data's from DB  lets say i have 11 data in total , i need it in a dynamic column in gridField like (no of col can be : 2,4,6) local!data : DB datas, local!noOfCol : (3,4,5) -> any number (const), so based on the col number the total number of data have to be grouped and run in the loop in a gridField using GridColumn i need to run the loop  the data should be look like this in the ICON wise.it is done in Columns layoutexpample local!a : { {1,2,3,4} ,{5,6,7,8},{9,0}}, output in gridColumn in Left to Right1 2 3 4 5 6 7 8 9 0 null nullCode a!localVariables( local!data: rule!LH_QRC_getLookupDetailsByFilters(categoryList: "ICON"), local!noOfCol: 4, local!groupedData: a!forEach( items: enumerate( ceiling(count(local!data) / local!noOfCol) ), expression: index( local!data, enumerate(4) + (((fv!index - 1) * 4) + 1), null ) ), a!gridField( data: local!groupedData, columns: a!forEach( items:

i have 2 drop down. 2nd drop down is dependent on 1st value  so i have to show default value in second one once the user select value in first dropdown when i has only one option in second dropdown   this value i have to default once the value is deleted in first dropdown