Discussion Categories

Hi, I am receiving date in the format like : 25SEP  I want to format it in this format : 25th September  Is there a way to do it ? 

In the Appian Designer, we can see the NEW tab which shows all the design objects like process model, record type, Data type, interface, etc.  Can we customize that view i.e. can we restrict the limited objects to a specific group of users? Please let me know that will be most helpful.

can we calculate batchsize based on datalength(Bytes) from table and amount of data we retrive from Appian query  ? because i have a requirement to send data from multiple tables to API Ex: For one table i have table with 235417 of data in that and datalength is (18366464 Bytes) . As we know we can retrieve only 1MB(1000000Bytes) of data at a time from query entity , So i am expecting my batch size should be dynamically decided based on datalength(18366464) and amount of data retrived at a time (1000000bytes) to send whole data in chunks . If i give hardcore value as 10k or 5k this may again cause issue for some other table with large data or large column . So my thought is it's better to decide batchsize dynamically based on tablelength  

Anyone know how can I change from this format: "mm/dd/yyyy h:m PM" to this format: "dd/mm/yyyy h:m PM". I only want to switch the order for the day and month.  I have tried the following expression, however this way it doesn´t show PM/AM. a!gridColumn( label: "Fecha Recepción", sortField: 'recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion', value: if( isnull( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'] ), fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], datetext( fv!row['recordType!{b6fc6108-1f5d-4cbe-9c5c-08da4b1d58f3}CPF Maestro Recepciones.fields.{4fa92044-3c8b-438b-b77e-30bf88efbae3}FechaRecepcion'], "dd/mm/yyyy hh:mm" ) ), align:

Hi! I´m using an enviroment from a partner to practise. When I want to start with the exercise of chapter "Design appian Records, part 1" ask me to look for "AS_Vehicle" in the application (topic 4). I don´t know why in my environment I don´t have it. Could you tell me how fix this? or can I import this from some place? Thanks!

Hi, is there an easy way to know how many times and where a component (for example a!hierarchyBrowserFieldTree) was used in an Application? Many Thanks

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

load( local!crAppComments_cdt: rule!CR_APP_QE_getCoventsAndConditionsCommentsBasedOnFilters( requestId_int: ri!requestId_int, cif_int: ri!cif_int, sourceName_txt: ri!sourceName_txt ), { a!boxLayout( label: ri!sourceName_txt & " " & cons!CR_APP_LAB_COLLATERAL_COMMENT[1], isInitiallyCollapsed: true(), isCollapsible: true(), contents: { a!sideBySideLayout( showWhen: not( contains( ri!buttonAction_txt, cons!CR_APP_TXT_READ_ONLY ) ), items: { a!sideBySideItem( width: "10X", item: a!richTextDisplayField( align: "RIGHT", value: a!richTextIcon( linkStyle: "STANDALONE", icon: cons!CR_APP_TXT_ACTION_ICONS[2], color: "ACCENT", size: "MEDIUM", caption: "Edit", link: a!dynamicLink(

hello, im trying to implement a rule that takes as an input (number:decimale) and return and italian readout of that number for example(21762161120,58)the result will be this way (ventunomiliardisettecentosessantaduemilionicentosessantunomilacentoventi/58) 

I have the following error, I am trying to display a card info on vehicles. Expression rule works properly. Please help me on how to understand this error. Thank you.

<html>   <head>     <title>Appian Embedded Interfaces</title>     <script src="">example.appiancloud.com/.../embeddedBootstrap.nocache.js" id="appianEmbedded"></script>   </head>   <body>     <h1>Appian Embedded Interfaces</h1>         <appian-action processModelUuid="example uuid" ></appian-action> In the above code I replaced src and Uuid with my cloud server url and uuid of my process model I have followed the embedded interface document provided by appian to configure this. i have also added cors in admin console as chrome.google.com ERRORS : 1."from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource." 2."Failed to query server. Status Code: 0"

Hi all I need one suggestion please let me know if anyone have an idea Question: I had data in array ex: a!map{ (id:1,idTwo:1,value:text), (id:1,idTwo:2,value:exam), (id:1,idTwo:1,value:yes) }, I need to combine the value when id and idTwo are same Expected Output: { (id:1,idTwo:1,value:textyes), (id:1,idTwo:2,value:exam) } Thanks In Advance

I am getting this error while debugging PM How to resolve this ? 2019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/20232019-00129/23/2023

I am querying data and getting all the desired data  from DB. And Ids are one of them.Now I need to move these data from expression rule to process model after doing required changes in the rule. These Ids are like {123456, 345789, 567890, 120078}. I stored them in map like map(id: {123456, 345789, 567890,120078}). But when I am trying to extract these Ids from the map using indexing  and use with a process varible, which is an integer type with multiple checked, to store data, it is storing like {123,456; 345,789; 567,890; 120,078}.  Kindly help me to get my Ids as they are without these unnecessary commas

Hi does anyone know how can we perform AnalyzeId operation in appian using textract connected system? I cannot see this operation while configuring integration

I am getting error like Premature End of file while generating Pdf how can i resolve this ? a!localVariables( local!voucherDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getVoucherDetails(batchNum: ri!batchNum).data ), local!batchDetails: if( a!isNullOrEmpty(ri!batchNum), null, rule!GAI_getBatchDetail(batchNumber: ri!batchNum).data ), local!date: today(), local!xmlData: if( a!isNullOrEmpty(ri!batchNum), null, concat( "", "", ri!batchNum, "", "", local!date, "", "", index(local!voucherDetails, "description", {}), "", "", index(local!voucherDetails, "claimname", {}), "", "", index(local!voucherDetails, "fundsource", {}), "", "", index(local!voucherDetails, "fundamt", {}), "", "", index(local!voucherDetails, "invoicedate", {}), "", "", index( local!voucherDetails, "invoicen

Hii, I have a requirement to generate pdf file based on count, For ex- If i have a local that have 2 item (count) then 2 pdf page should be generate if 3 item then 3 pdf page should be generated how can i do that ?

I made some changes in my interface through the Edit List function but when I save changes and update the interface, this changes do not apply to the read-only grid. I tried to eliminate this read-only grid and add it again and this way the changes were applied.  Example of the changes and the interface are the following: The changes to apply in the interface are the following: And the interface remains unchanged (notice the "€" sign is not applied): Does anyone know any other (less sophisticated and destructive) way to update the read-only grid and directly apply new changes? Thanks! 

Hi Expert I want to find members from two groups. can anyone help me how to write expression rule for that? Thanks 

Hi, I have a read only grid with recordType as data source. The total records are N, more than 5000. I have the need to show a column in the grid with a progressive index, from 1 to N. Is there a way to achieve this using the recordType and without loosing some functionalities like user filters, excel export, etc.? Thanks!

Hi, We are planning to implement a requirement where we need to scan a product page that contains 3 barcodes. And read data from those 3 barcodes. The current barcode field, scans one barcode at a time. To achieve same , we can keep 3 barcode components in UI but this is not our expectation from UI point of view. Is there any way we can read details from all 3 barcodes at once (without user taking photo/scanning it 3 times individually) ? Thanks,

Hi Champs, I have a site where one of the page names is little, bigger. So, on the site the name is showing truncated. Can I increase the width of the same so that it will show the full name of the text. Regards, Ghanashyam

My use case is i just want to get all the employee details whose birth month is suppose i pass 7 in rule input.How can i achieve it?

Hi All,  I have multiple values like this, I need to show single data ,How Can I show single value using expression rule, Is there any way to do ? Please help on this on priority.

I am uploading a csv file with a cdate type column, I changed the format in the csv to be "yyyy-mm-dd" which coincides with the format shown in cloud database. However when I upload it the column with date is not uploading correctly. The rest of the columns are OK except for that one. Any help would be useful. Thanks!