Community

Hi Team, I came across a use case where I have a Document Repository where Excel files were dumped by an external system and wanted an Appian BPM process to automatically picked the file, convert it into CDT, parse it/massage it (based on business requirement) and then do further processing with the data. Please note that these excel are dynamic in nature (templates are yet to be standardize) and have macros in it. As I am new to Appian world, was wondering what may be the best approach to handle this by using Appian capabilities. Would request if someone can put some light and thoughts on how to handle this. Thanks and Regards, UM

Hi, so when i was testing the summary view interface using a query rule to get customer info by iD. I got this kind of message. How to solve this? Thank you Expression evaluation error at function a!eval_inputMapWithTypes_ruleInputCast [line 42]: Could not cast from List of Variant to SJ Customer. Details: CastInvalidCould not cast from List of Variant to SJ Customer. Details: CastInvalid

Hi All I have the following selectable grid layout. Here my requirement is  I have a status field with two types status's 1) Completed and 2) Not Completed In a rule input I'm maintaining the status Field Initially the status for all the grid rows will be Not Completed. What ever the rows I have selected those status value should be updated as Completed, if i uncheck some rows. those should revert back to original status Not Completed Please help me in this. Note : Grid rows are dynamic Thanks in advance

it is required that outcome produce by the app can be extracted with a specific reporting format for regulators?, Excel and PDF for extracted data is expected. The idea is to avoid any manual manipulation of the output/final report

Why does the count() function return a 1 if I pass in a null? so when I run count({null}) this returns a 1 but to me I would logically think 0. Was hoping for someone to explain this to me, Thank you.

Hi All, I'm having a button "COMPLETE" i want to put a shown condition on it in the following basis I'm having an array {"Completed","Not Completed"}, If both the values in that array are in completed status then only i want to show that button. Could you please help me with the logic. Thanks

Hi All I have a requirement to export data into excel with headerin the first column and value in the next . How to achieve this in appian?

when i created record type object from data store entity the data is not shown in the record eventhough the data is present inside the database but when create record from using process model data shown in record.so, pls tell how can i solve this that data will shown in my record?

Hi Team, I'm having a requirement to make the below milestone object to Dynamic.  Here  Not Assigned, InProgress, Completed are fetching from one table and Review, Rejected are fetching from another table. The milestone object should be like below. Please help me  Thanks in advance

Hello, I have a requirement to retrieve a value (CustomerCode) for a signed in user based on a group attribute. When a user logs in, we will be using this value for row level security. The problem is that users can belong to multiple groups, and not all the groups have the attribute value CustomerCode.  The only way I have been able to do this is using the unsupported try function which I know is not acceptable. getgroupattribute returns an exception if the attribute does not exists. a!localVariables( local!a: "mpierson", local!b: getgroupsformemberuser(local!a), local!d: a!forEach( items: local!b, expression: if( try( fn!getgroupattribute(fv!item, "CustomerCode"), "" ) "", fn!getgroupattribute(fv!item, "CustomerCode"), {} ) ), local!d ) Is there a supported way to handle exceptions?  Is there a better way to store attributes for groups of users? We are trying to not have to maintain at the user level.

HOliday landing page

1. How to change record user filter placeholder text from default "any" to text what I want? 2. How to set multiple default options when using record user filter? Thank you

- trying to add a query-filter to the read-only-grid - error message: - the field "PJ_ID" is type TEXT, - the value of the local!selectedRows: - it works fine when working like below:  -field "id" is type INTEGER

Hello, I have a read-only grid that is displaying results from an integration that is stored in a variable.  I also have a folder that contains documents that are related to the grid rows.  I would like to dynamically display the related document in a new interface/window. I am able to configure the documentDownloadLink, but would like to display using the documentViewerField instead. Here is the current interface. Please be kind, it's my first attempt and have been playing around a lot. I've hard coded the document value for now but will be using finddocumentsbyname to retrieve the document id. = a!localVariables( /* Set up the initial paging and sorting values */ local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1000, sort: a!sortInfo(field: "submitTimeUTC", ascending: false) ), CardCode: "C25000", local!id: finddocumentsbyname( searchAllContent: true, documentNameToSearchFor: "A_R Invoice*- 7649" ), /* Call the extern

In using the date componentI would like to ask about how to change the input format and how to select the year? Basically right now to input date by typing, the format should be like "05/07/2021" but, want the format to be like "2021/05/07". Also, if want to select the year 2027, is there a way to do it instead of clicking the "->"(right arrow) button repeatedly? Thank you.

This Error is coming while adding Validations to the date and time in Maintenance Information

I am working on an interface like above  and each time a component is added or configured, it takes about 10 to 30 seconds to load. Is it normally this slow? Or is there a way to speed up. + The interface form is requested by the customer, so separating the interface into  parts will not be a selectable choice. Thank you.

Hello Everyone, I am trying to use Automate my development into Automation. What are the steps I need to follow before I start my automation and do I need any plugins if so how they work? Please let me know if anyone has the guidelines and the process to follow. Thanks, XXXX

Hi From may 1st the certifications patterns are changed, I wanted to know what are the topics that will be covered in Certified Associate Developer Certification exam

Hi Appian community! I have created an interface which allows users to add bicycles to a fleet. I now wish to create an interface that modifies a bicycle's condition and location (to different citibike style docks) if needs be - what would be the best way to go about this and how do I import the existing data I have? Thanks

I see that there is a excel download button in read-only grid. And can use filter to download what I want. To go one more step from that and want to download only the selected rows to excel. How could I do it?  Would be great to have example too!! Thank you

Hello Appian. From new update gladly I found that News view, related actions view could be removed. but the summary tab remains. Can I make the summary tab button(?) invisible? or at least change the name summary to something else? Thank you.

Hello Appian. Is there a way to merge columns like the picture below? Like using colspan simply in HTML, how can I merge columns and make table like above? Also if want to use two header lines? is it possible?

Hi All, I am trying to read one xml data into CDT fields. I am able to it in expression using torecord(xpathdocument(cons!FF_XML_TEST2,"PersonName"),'type!{urn:com:appian:types;XML}FF_Xml_CDT'()) and output: Type FF_Xml_CDT Value Formatted Raw Expression FF_Xml_CDT first"Faisal"(Text) last"Faridi"(Text) But when I am doing it in Process model CDT variable is getting updated. I have attached full steps with my codes. Could someone please help where I am going wrong? XML Lines: <PersonName> <first>Faisal</first> <last>Faridi</last></PersonName> [View:/cfs-file/__key/communityserver-discussions-components-files/62/All-Print-Screens.docx:320:240] Thanks Faisal