General

Hello, I'm trying to parse a pdf that contains data in a table format and table data cells contain decimal values. However, some cells are blank and contain no data. When I use getpdftext() function to parse the data, the delimiter between 2 adjacent cells and between 2 cells with a missing cell value in between is always a <space>. Due to this, I'm unable to map the correct values to the correct column/header. Let me know if someone has an approach to resolving this issue. Thanks,

Hi everyone, I would like to know if files in appian folders are deleted by default (and if so, how often) or not. Also is it possible to change this time setting if there is? Is it possible to find any related documentation on this part? Thanks all in advance.

Multiple Excel formulas are not working. For example xlookup when used is not giving value in preview mode means data is not going to the database hence output also not generated properly.

I added a tab component to an interface I was building and added 4 additional tabs to the 3 that come with it automatically. I had all 7 formatted the same and working perfectly fine as each was clicked. However, I discovered that I had missed a needed tab that meant to go in the 5th slot, so I added another tab, moved it up to the 5th spot in the component configuration section, and then went through that it along with the 3 that moved down were all updated and formatted correctly. Now however, when clicking through the tabs, only the first 4 tabs become selected and show their given information below it, the new tab along with the others that moved down the list are selectable now, clicking on them just updates the page but does not change the selected button. I've been through the code and everything looks as it should I think, does anyone have any thoughts why it wouldn't be working now? Coding for the tabs: a!localVariables( local!selectedTab: 1,

I have a dynamic link in my code and I want to increment the link as soon as we click on that link icon and value should display below that icon. For Example: initially icon link value should be 0 and once I click on that icon link value should get updated to 1. Can you help me how to achieve this? a!localVariables( local!pagingInfoWell: a!pagingInfo( startIndex: 1, batchSize: 4, sort: a!sortInfo( field: 'recordType!{78f32b7c-4150-4c84-baf2-6b2d421a715d}RB Retro Note.fields.{5021c120-a5cf-4752-85fe-a3268542bc23}id', ascending: false() ) ), local!pagingInfoImproved: a!pagingInfo( startIndex: 1, batchSize: 4, sort: a!sortInfo( field: 'recordType!{78f32b7c-4150-4c84-baf2-6b2d421a715d}RB Retro Note.fields.{5021c120-a5cf-4752-85fe-a3268542bc23}id', ascending: false() ) ), local!refresh: a!refreshVariable( value: cons!RB_RETRO_REFRESH_COUNT, refreshAlways: true() ), local!retroNotesWell: a!refreshVariable(

Hi, I'm very new to Appian and postgresql. I'm trying to explore how to connect these two and I came across "Create Connected System". Could someone please guide me in order to establish some sort of connectivity it'll be greatly appreciated. Sharing both here. 

Hi! I have two records with different record actions in separated process models (create purchase order vs create invoice). In this case, I would like to be able to initiate the process of invoice creation based on the purchase order data (id, supplier, and other data passed automatically to the create invoice interface) My trouble here is that I need to do this from the summary view for each purchase order ID (until now I had a different action in each record view).  I was thinking about creating a button in the summary view, but I don´t know how to pass the variables in a correct way or the best practice here. Which options do you recommend? Creating a button and link it to the proccess model to create the invoice? Create a related action? My process steps would be something like this: 1) User clicks in the summary view of the purchase order 2) In the summary view, there should appear a button to make an invoice with the PO data 3) The data collected should flow to

Hello All, We need to show the generated docs in the interface, and if there is any error in the document generation need to show an error to the user. Document creation takes time so we created the PM to generate the document and used the process report for the generate document process model. We are using queryProcessAnalytics in the interface with a refresh variable to check the "generate document" process status. We need to stop re-querying the queryProcessAnalytics if any error is received from the process report, used the below code to achieve this. local!processReportData: a!refreshVariable( value: if( true(), /*Some conditions*/ a!queryProcessAnalytics( report: <<process report>>, contextProcessModels: <<process model to be checked>> query: a!query( /*c1 - processStatus (1=Completed)c3 - process Idc6 - errorMessage*/ logicalExpression: a!queryLogicalExpression( operator: "AND", filters: a!queryFilter( field: &quot

I'm having this issue while trying to search anything at the "all objects" search box. I don't know why this is happening only in the development environment. Can someone help me ?

Hi All, Can we add hyperlink in tooltip?If yes can any one provide as the solution.

Hi , i am getting this error after selecting a dropdown value :- Expression evaluation error [evaluation ID = GUC5I] in rule 'td_additemforbasicdetails' (called by rule 'td_tenderdetailsmaster') : Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!dropdownField [line 57]: A dropdown component [label=""] has an invalid value for "value". All selected values must be present in the choiceValues array, but value was 37 and choiceValues was 32; 34; 36; 37; 38. How can i resolve this ?

How to use error() function and what is the  best use of error function

Good morning, We have to generate a pdf from a given template (we are using the pdf doc from template node), this template will be filled with text fields that we get from the database but we also have to attach a loaded signature to the end of the pdf in an image that we obtain previously.But we were not able to load it inside any of the tags that the template has, we have tried to mount the two pdfs separately and then do a merge but this would not work for us because as I mentioned we need the image to be in one of the template fields.Has anyone had this same problem? Greetings and thank you

Hi All, Hello Team, There seems to be major issue post Appian was upgraded 23.2 to one of our environment yesterday. All the test scripts for our application are failing since it seems yesterday's update have introduced new locators. Same issue was observed by other Appian users as well which can be seen on community page https://community.appian.com/b/appmarket/posts/cucumber-for-appianAre there any solutions which can help prevent happening this? Or is there any way Appian communicate to us letting know that there will be a change in locators? I could not find it in release notes

I really like how Appian is evolving over the last coupe of years since i've stared using it. It is good to see regular release with new feature but there are a few that I'm really missing in Appian and could be game changer. At the same time i would like you community what you are looking for to be added to Appian? My most missing features: 1. More flexible filtering options for Grid. I would like to filter by any column in place having only values that are available if filter is added on other column. It should work similar how you can do it in Excel or in most tables on the web with simple JS dll.  2. More control over Grid appearance. It would be good to be able to decrease the font size, spacing, padding and margin to make table more compact. It also would be good to prevent word wrapping and have more control over column width if text is long. 3. Possibility to write expressions as Java/Python code within Appian if there is such need. 4. Dedicated component for navi

hi Team, we are going to use OKTA Authentication to login into Appian and BOX, DocuSign and Salesforce Connected System. But we got a Question from my internal Team that can we the OKTA Access Token with in the Session for connected System for Authentication.  Please help me in understanding can this be done? Thanks & Regards , J Vinay.

Hi Team, Is there a way to dynamically execute the record actions within Appian, with the action name saved in DB.  I'm aware that we can dynamically execute the process model by passing in the UUID (which can be save in DB as a text) but the business ask is to open up a task/UI in a dialog box which cannot be achieved through a!startprocessLink. And this was why we configured the PM as a record action and opened it as a dialog. Is there any means to dynamically execute the record action by retrieving its name from DB. TIA

I am getting values from database and I am displaying it and the filter is working fine. Now the Requirement is i need to add NULL Name in dropdown and display those names that are NULL. I am using append(local!dropdown,"NULL Name").  local!dropdown-- It has a rule that is used to display Dropdown value. My doubt is I need to Display NULL Name dynamically, i.e: if any value is Null then only i can see this option in dropdown. I am using below code but its wrong(as am comparing directly with NULL and value can be like: {Name1,Name2,Name3,Null}) can someone help me on this local!dropdownList: if(local!dropdown="NULL", append("NULL Name"),local!dropdown)

Hi, As the log files are generated in Appian and we too can view and download them. But I have a doubt about a few. Can you please solve them? I listed my questions here:     1. What is Appian Default log clean-up configuration?     2. What is the log generation frequency?     3. As the log files are generated and stored, do they delete automatically or can I delete them manually?  Thanks.

Hi All, If we go with the Appian Cloud Database Encryption,(https://docs.appian.com/suite/help/23.2/Appian_Cloud_Database_Encryption.html#default-encryption-for-tables) 1.  What is the performance impact - the article mentions small performance impact. Has anyone done this and what was the impact on performance(specific in milliseconds,seconds)? 2.  We have views defined in application which are used to display some dashboards on UI - will these be impacted as well? 3.  As per article,the phpMyAdmin will continue to show data as before encryption so how do we verify that encryption is working correctly

am getting this error in PM, but i didn't find the issue.. i guess it's in user input node is throwing the warning. can anyone tell me what might be the issue

Hello, Does Appian allow for backwards compatablility with applications OR objects? I put one interface object in a package, and tried to import it to another appian environment that was not running the current version. I got another error displaying this: Is there something wrong with the object itself or does happian just straight up not allow backwards compatability?thank you

How does appian generates valid web address link in portal? what happens in the back-end?can we generate valid web address using SAIL?

Hi All I have requirement to get the values between  square brackets iam achieving it with the help of  extract function but when i was trying to insert the brackets after entering value and if my text value has uneven number of brackets it is erroring out   can you suggest is their any other alternate way to achieve this 

Hi All, I have requirement to read content of PDF having Table and Paragraphs which is structured and unstructured and store it into TABLES without any manual intervention. I have used the Appian inbuilt feature doc extract but its not providing me accurate reading capability like some fields are readable but some are not.  https://docs.appian.com/suite/help/23.2/evaluate-doc-extraction.html We would like to stick with Appian as it keeps the doc in Appian rather than using Google  Any suggestion will be helpful Thanks