Foundation

Facing issue while verifying the data store entity. Error message says that it is unable to find the table column or the table itself.  I tried creating the new table "NZ_Test" to my DB server and CDT of same table with new Data Store "NZ Test DS". Still getting the same error.  Note:- The test connections are successful with the data source. Also, we had a version upgrade from 21.4 to 23.2 recently. Is this causing the issue? Attaching the screenshot of CDT and Data Store for reference.

Hi All, We are getting below error in log file but the mentioned process id or process model id are not available in the system. Can anyone please help me out her? "WARN  com.appiancorp.process.workpoller.WorkPollerIntervalLogger - Work Item 23 has been executing for 681 minutes and 38 seconds. Process Id: 538395847. Process Model Id: 451. Thread: Appian Work Item - 91897 - WorkID 23 - execution02 - process 538395847 - model 451 : ExpressionGroupRequest. Stack trace: " Thanks in Advance.

Hi All, Does anyone know if in appian is possible to show "..." and it you put the cursor on top you see rest of text? when we have multiple values for one column of one specific record. For example I have a grid with multiple columns and one of them for each records has multiple values , like the user record has a column with "favorite colors" and each user has 3-4 colors. In grid I want to display only first color and .... so the height of row is not so big. thanks in advance

Hi All, i am facing below issue while start process in debugging mode. The process getting stuck at write data store entity node and i could see under process details tab 'Unattended'. can some one please explain what went wrong here? i do not see any error just process getting stuck at there and data not loading into DB.

a!cardLayout( contents: { a!localVariables( local!allWeather: rule!IMS_QR_getWeather(id: null), local!otherWeather, { a!cardChoiceField( label: "Weather Choices", labelPosition: "COLLAPSED", data: 'recordType!{0d9629bd-6e75-4c05-94e2-edfb817cb378}IMS Ref Weather', cardTemplate: a!cardTemplateBarTextStacked( id: fv!data['recordType!{0d9629bd-6e75-4c05-94e2-edfb817cb378}IMS Ref Weather.fields.{5a76435e-3c34-4bfc-9d4a-639d0639076a}id'], primaryText: fv!data['recordType!{0d9629bd-6e75-4c05-94e2-edfb817cb378}IMS Ref Weather.fields.{6264f67e-0086-4b15-a25c-b738d8a2aac1}labelEn'], /* To be replaced by translation set */ icon: fv!data['recordType!{0d9629bd-6e75-4c05-94e2-edfb817cb378}IMS Ref Weather.fields.{513cbb34-3b72-4a09-a21e-adba417682bb}icon'] ), value: ri!mandatoryIncident['recordType!{b1f5fef5-db37-4e8e-826d-7f8c578856be}IMS Mandatory Incident Rep

I want to introduce in an interface a series of fields that will collect text, with rounded edges, but I can't find any property that allows me to do so. Would anyone know how to do it or if another component is more useful?

I want to implement the Chat bot in my interface but I am not getting Records chat input component. 

How can we achieve this

Whenever theres's a CDT not found in the namespace it has been given, appian reverts its components to the previous version automatically:- CDT with propper namespacing - CDT without propper namespacing (notice the upper case PEOPLEFUNCTION at line 2 and the alert the interface is showing already) - When we save the file, then the code changes the components to the previous version (notice richTextItem_18r1 at line 7): This behavior works with Buttons and RichTextItems as far as we found it  CODE for replicating ita!localVariables( local!a: 'type!{urn:appian:ps:PEOPLEFUNCTION}SecurityRoleMap'(), { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!richTextItem( text: "Some text", color: "ACCENT", size: "MEDIUM_PLUS", style: "STRONG" ) } ) } ) Special thanks to: [mention:2817a4e7a26c4849b30fddb9463db79d:e9ed411860ed4f2ba0265705b8793d05] , [mention:2095d

Hi, I have a user input task within a process model, in which I activated the "save draft" funcionality...My doubts are: How much this draft will live in Appian?If the form has attached documents, what happen with them?  Thanks in advice

Hi, I have a concern about the text() function after Appian Upgrade 23.4.  The code: text( gmt(todatetime("01/09/2023"), timezone()) + intervalds(12,00,00), "dd-mmm-yy hh:mm:ss") & " AM'" The output: "01-Sept-23 12:00:00 AM'" /resized-image/__size/640x480/__key/communityserver-discussions-components-files/11/Screenshot-2024_2D00_01_2D00_02-at-6.08.20_2F20_PM.png The output keeps returning "Sept" instead of "Sep" and this is only happening for the month of September. The other months are returning the first 3 letters.  Does anyone know how to resolve this? 

I want to build functionality where when user lands to my Appian site , Show Dialog Box upon login with following details: 1. Message in the Dialog Box - “Please set your local time zone in Settings. Ignore if already done.” 2. There needs to be checkbox after the above saying "Please dont show this again"  3. Ok Button - If the user clicks on the checkbox in Step2 before clicking on the Ok button then the dialog box should appear again when the user logs in next time.

if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[1], rule!CR_APP_CA_PDF_genericRuleForNtb( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[11], rule!CR_APP_CA_PDF_genericRuleForContractExtension( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[12], rule!CR_APP_CA_PDF_genericRuleForRemedialAndSAMHandoverManagement( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if( ri!actionTypeId_int = cons!CR_CREDIT_ACTION_TYPE_IDS[2], rule!CR_APP_CA_PDF_genericRuleForCashCollateral( cif_int: ri!cif_int, requestId_int: ri!requestId_int, duRequestId_int: ri!duRequestId_int ), if(

Hi All, In a interface i am showing all the  product details  of a single order id getting from a record using a editable grid which is coming from the assistant buyer  to Buyer , buyer should give his approval or rejection by selecting products in a editable grid along with his comments for each product in the grid how to achieve this  product id product name quantity price assist buyer comments buyer comments 1 biscuit 1 20 please approve 2 chocolate 2 30 please approve 3 ice cream 2 50 please approve

I have to create such a functionality where I have to show a search bar using which CA can drag and drop the document into interface. And the dragged documents should be put in a grid having delete icon besides them. How can I achieve this functionality in Appian interface.

Hello All, We are migrating our db from Mysql to Postgre.  Postgre uses some different datatypes as compared to mysql (eg. boolean) Has anyone worked on the migration of the whole db to postgre, if yes can you please provide few steps on best way to do it?  Esp the cdt(xsd) part. Database we have migrated, but we are finding hard time in updating the cdts. Thanks in advance!!! 

Hi All, As part of practice and POC purpose. There was requirement like i have created three drop down fields on UI and also there are also Three tables created DB(Tables- States, Cities, Towns). Sates- drop down and City-Drop down working as expected based on selected state value cities were displaying but based on selected City value towns drop down field values not showing up. null parameter was passing when i checked local variables. i tried different ways but not able to achieve this. could you please help on this.   below code for reference a!localVariables( local!stateData: rule!KT_getStateDataById(), local!stateName: property(local!stateData, "state",null), local!stateId: property(local!stateData,"id",null), local!cityname: rule!KT_getCityByStateId(stateId:ri!stateid ),  local!townname: rule!KT_getTownNameByCityId(cityid: ri!cityId), { a!sectionLayout( label: "", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a

I run a small cleaning business in australia, so I need to collect reviews/feedback from customers, but I want to avoid negative reviews, so I am trying to create a page on my website that has buttons for redirection based on what customer choose. But the problem with a page with buttons is, users can anytime come back to the page and click again on other button to leave negative review, so it will backfire. So, I seriously need a fullproof method to use redirection method so I can collect positive reviews on GMB and negative feedback on a form so I cam improve on those points. Is there anyway I can use any platform different from Wordpress for my feedback page? Or can create a completely different feedback page with html? (also I don’t want Google to index my feedback page so my competitors won’t see my method). Any help on this is appreciated. Solution needed ASAP. Customer Feedback Sample Page I need help with: https://superiorcleaningandpest.com.au/customer-feedbac

I am using the Fill PDF Smart Service from the PDF Tools plugin. I have a fillable PDF with an image field that I am trying to insert an image into. The image is stored in the knowledge center. I have the PDF Field value in the data tab set as such.  { {"name": "image", "value": todocument(pv!documentId) } } However, it is not filling the field and there are no errors when running the process for debugging. Please advise.

in interface ,i  want a textbox in which i want to paste some mail addresses and then i need to validate those email address

Hi - We are currently working on building a chatbot. As part of that we tried to mimic the traditional chat UI by leveraging Appian components. However, we are facing an issue displaying the latest message entered by the user on a card layout. A scroll bar appears in this scenario and we need to manually scroll it. Also, Auto height on card layout doesn't work as chat window getting bigger. Any alternative approach or a way that we can take care of auto vertical scrolling on a component? TIA

How to navigate from one interface to another interface ??. Can any one suggest how to do it??

Hi, everyone!I have a problem, I'm designing an interface where you can attach a file but the file must have a nomenclature. Example:INVENTARIO (always) PRESENT MONTH PRESENT YEAR INVENTARIO DIC 2023 But I tried with the follow code:a!localVariables( local!var: { "ENERO", "FEB" }, local!var2; { a!fileUploadField( saveInto: local!var2, value: local!var2, label: "File Upload", labelPosition: "ABOVE", validations: { if( fv!files.name = {"INVENTARIO" & upper(tostring(datetext(today(), "MMM"))) & upper(tostring(datetext(today(), "YYYY")))}, { "Ingrese un documento nombrad correctamente." ), } ) } ) Add to Phrasebook No word lists for English → Spanish... Create a new word list... Copy Add to Phrasebook No word lists for English → Spanish... Create a new word list... Copy TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese

a!gridColumn( label: "Status", sortField: "status", value: if ( fv!row.isTesting, a!iconIndicator( icon: "STATUS_NOTDONE", ), a!iconIndicator( icon: "STATUS_OK", ), )