Discussion Categories

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

Hi All,           I have a requirement that to display the month name & Year  from two particular dates .Is there any direct function or please give any valuable suggestions on the same. Ex:11/2021 --10/2022  It should display Nov2021,Dec 2021.....Oct 2022 Thanks & Regards Saidivya Minna.

Expression evaluation error [evaluation ID = a6b59:bf472] in rule 'ofm_repairsection' at function a!buttonWidget [line 222]: An error occurred while executing a save: java.lang.IllegalStateException: A Value should not be the result of activation What exactly this error mean.....

Hi everyone, I just created one interface which queries data from a record type, to build a dashboard.  I want to call that interface into a bigger interface, in which if I click the card field, the dashboard will show up. This existing interface is using a!cardLayOut for displaying other field, and I couldn't find any solution to call the new interface into it, as the a!cardLayOut link parameter only accepts  a!documentDownloadLink(), a!dynamicLink(), a!newsEntryLink(), a!processTaskLink(), a!recordLink(), a!reportLink(), a!safeLink(), a!startProcessLink(), a!submitLink(), a!userRecordLink(), or a!authorizationLink(). Is there any way I can work around with it?

the

Is it a bug or is there some other reason why my users cannot see records in Tempo or other places when I explicitly gave them permissions in the security configurations? Is anyone else having this problem.  I don't want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.  I have given permission on the record type, data store, site, interface ... They still cannot view the record type, even though the tab is visible in Tempo

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

Example:  Rule input has no. of items 24, I want to retrieve in batches of 10. i.e at 1st I need to get top 10, 2nd time next 10 items and 3rd time should get 4 items

I have created a Connected System that uses OpenAPI.  I then created an Integration that uses the OpenAPI CS to call a User Authentication API that returns a service token.  That token is then used to authenticate  other APIs that are available for the application.  Every API must have the token referenced in the header in order to authenticate.  I am trying to create an Expression Rule that can be used as a wrapper to call the User Authentication API and return the token.  I would like to use this rule as the Header value when creating additional integrations for the other APIs so that the authentication can occur every time the integration is called.  When I test the expression rule, I get an error that reads: "The jsonText parameter must not be null or empty." Here is a screen shot of the Integration, which works when I manually insert a valid bearer token: Here is the expression rule that fails: It seems like the API is

I'm trying to open a summary page in site by using a hyperlink from dashboard and I'm getting the following error "An error has occured The field [e40--------] does not exist.(APNx -1---)"

Hi all, may I know, how to extract the xml data in an xml file Thank You

Hi everyone,  I'm quite new to process model things, so there were something that I have heard of but didn't understand.  1. What is process model engine? Is there any documents about it? 2. How to set the sub process to be executed on the same engine with its parent process? And is there any benefit on that?  Really appreciate your helps!

Hi all,  strucking here to give validation for a URL. If users gave hhpts:// so the flow was getting  error here because of that  not proper link format.  So kindly, suggest Validation for URL .  Thanks in advance.

Hi team I'm needing some help to force an answer in a dropdown field where a given answer is selected in another dropdown field.  Here is a screenshot of the editable grid. I want to force "not used" in the "how important" column when "never" is selected  in the "how often" column The software names are returned from an existing table. This is how the answer table is set up: Answer Table id Name questionID 1 Daily 1 2 Weekly 1 3 Monthly 1 4 Quarterly 1 5 Annually 1 6 Never 1 7 Vital 2 8 Important 2 9 Useful 2 10 Not Useful 2 11 Not Used 2 The questionId corresponds to the two column headings. Here's the expression for teh editable grid: { /* For the Software Title Column*/ a!richTextDisplayField( value: a!richTextItem( text: fv!item.softwareID.name, color: "ACCENT", size: "MEDIUM", style: "STRONG" ) ), /* For the Frequency Of Use and Vitality Columns*/ a!forEach( item

I am facing issue in apian, as I need to get the data which is present in cloud data base store to my appian process modeler in CDT form of every data, how to do that could you suggest your ideas on it  mainly i need to get the data which is present in cloud data store to into my  appain  ui  inteface . every data which is present in cloud data store (table) need to come one by one in array form . 

Hi, After adding For Each function to rows in my editable grid, the rows not showing in UI. How to make my rows visible?.

Hi everyone, How to query in appian Not between in these date from oct 1 to oct 5, I would like to show data that not between on these date?

I am creating a new record with id, as soon as I click to create I want to redirect to that particular record summary page but it's going our site home page, Can anyone help on this Thanks in Advance

Hi all,What is the best way to reduce Intergration's execution time.  Time 4,153 ms Prepare: < 1 ms - Execute: 4,152 ms (Send|Wait|Receive: 3,925 ms) - Transform: 1 ms Thanks

Hi All, I am getting an error while adding a new page (which consist  a rule input  ) in the site . Previously I was able to add the pages with rule inputs but from today its showing error. Please help me to rectify this error.

Hi all, I notice that the HTML Display Functions plugin is not listed on the app market and therefore may not be supported in the future, but I'm sure that many of us have it deployed in our environments for one reason: the function ncolumntable(). For anyone looking to remove this plugin, I'm including here an expression rule that I wrote to perform a similar task, and it also has the benefit of having no limit on the number of columns. Given a list of column headers, a list of Dictionaries, Maps, or CDTs containing the data to display, identifiers for fields in the data (optional - if blank, a!keys() will be used to determine the list of identifiers for each row of data), and some optional formatting parameters, this rule returns HTML code to generate a table displaying the data. This expression rule has the following parameters: columnHeaders (List of Text) data (Any Type) columnKeys (List of Text) headerColor (Text) evenRowColor (Text) oddRowColor (Text) /*

Is it a bug or is there some other reason why my users cannot see records in Tempo or other places when I explicitly gave them permissions in the security configurations? Is anyone else having this problem.  I don't want to run around with expressions if the option exist to give them at least viewer permission in the security configuration.  I have given permission on the record type, data store, site, interface ... They still cannot view the record type, even though the tab is visible in Tempo

Update #1: I still wasn't able to get this working with a!recordActionField(), but instead I included it by adding the Related Action shortcut on the view configuration. This seems to be a bug with the User Record Type. Update #2: Passing the UUID with the user() function as the identifier was the solution! Thanks Dan. I created a custom view for Appian's User Record Type (the same record that displays when you click on your user icon and go to "Profile"). I have a related action that takes the user to a custom form to update some details. When I trigger the related action using a!recordActionField(), the following error is thrown and the process does not start: An Error Has Occurred The specified User related action does not exist or you do not have permission to view it. However, when I trigger the same related action by visiting the out-of-the-box "Related Actions" view on the User Record, it starts the process successfully

I have created RPA process that run in an Azure VM, it only works properly while I was logged into VM, otherwise it shows blocked status in RPA console and didn't execute the RPA process correctly, How can I troubleshoot this