Discussion Categories

Hi, I have written down a code to calculate this, please let me know if it can be more refined. a!localVariables( /*rule inputs local!StartDate, local!EndDate*/ local!StartDate:todate(ri!StartDate), local!EndDate:todate(ri!EndDate), local!WorkStartTime:time(2,0,0,0), local!WorkEndTime:time(10,0,0,0), local!StartTime1:totime(ri!StartDate), local!EndTime1:totime(ri!EndDate), local!StartTime2:if(local!StartTime1local!WorkEndTime, local!WorkEndTime, local!EndTime1), local!EndTime: if(local!EndTime2local!WorkEndTime,local!WorkEndTime,local!StartTime2), local!StartDateTime:datetime(year(local!StartDate), month(local!StartDate), day(local!StartDate), hour(local!StartTime), minute(local!StartTime),second(local!StartTime),milli(local!StartTime)), local!EndDateTime:datetime(year(local!EndDate), month(local!EndDate), day(local!EndDate), hour(local!EndTime), minute(local!EndTime),second(local!EndTime),milli(local!EndTime)), local!ElapsedDays:elapseddays( local!

Hello I am using Appian 22.4 version & Using Appian, I need to create Login Page which I did (Using Interface) but what configurations are needed to Validate it with the database and check if the Username and Password are correct or not, if correct and then only redirect it to DASHBOARD page Till now I have made the pages using Interface, but I am confused because END Users will be using Tempo/Site and not Interface Can someone please guide me on these issues

Hi All, These are the steps which we have done to generate the Doc. Step 1: Created a Docx using Create Dynamic Doc from Template. Step 2: In That Docx we have a table, we have a paragraph and we have an Image which populates dynamically which is like a signature.                                                                                                    «[#if signature?has_content]» Your sincerely,   «[#else]» No Signature added «[/#if]» Step 3: the Docx

Hi, I have a dictionary and I am passing the same into a sub-process and it is running n-number of times based on the count (n) of items in the dictionary. Now, in the sub-process I need to pass each item to a rule and get the data. How can I get each individual item from the dictionary. Will there be any counter which will get increased whenever sub-process was running. Thanks.

There are two column layout when you zoom out in the browser they move apart one to left another two right I want them to stick together Any solution for this 

Hi I Would like to know how we can execute Functions in Postgres from Appian. Can I achieve it by using Execute Stored Procedure Smart Service or a!executeStoredProcedureOnSave.  If these doesn't work is there any smart service or function in Appian that I can use to achieve this functionality. Help is Much Appreciated. Thanks, Srikanth 

Hi All, UAT environment were went down, from our Appian admin we received the tomcat.std logs with below error: 2022-11-22 14:05:56,714 [ThreadPoolTaskExecutor-147] ERROR com.appiancorp.process.workpoller.WorkItemListener - Error while trying to connect to send call 'completeWork'. WorkItem is going to Timeout in the requesting server: [WorkId: 71, EngineId: execution00, Request: ExpressionGroupRequest:2107325 as mm55767 by am85788, Response: ExpressionGroupResultResponse:2107325 type 117 daysToWait 0.0 canBeRetried false elapsed 7051.0] com.appian.komodo.client.FailedToSendRequestException: Unable to write request f2660200-f2bc-43bd-8c3a-858abfdedfc7 to localhost:5024 at com.appian.komodo.client.EngineSubchannel.lambda$internalSend$3(EngineSubchannel.java:253) at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:578) at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:552) at io.netty.util.concurrent.DefaultPromise.notifyLis

i am trying to display the text feald side by side but my requirement for one feald i want name another field i don't want name but the morgen is coming upside for the empty name feald... also i want to background color for the box layout is it possible if yes can any one suggest me and i am attaching my requirement and also i am attaching what i got... this is i am getting but i want another formet and also i want to change the font color and style can anyone suggest me for that

I have an application has a lot of objects I don't want to import. Most notably it has a data store which taking it will result in a massive amount of extra data types and baggage. All I care about is a process model I have copied.  All of its dependents have been brought in to a new application I am using to package up and import. I am getting some cascading and normal errors that seem to stem from me being unable to import the datastore.  What can I do to decouple this datastore from my application for importing? I already created a new datastore in my environment I am trying to move export it to and created any constants there that pointed to the data store entities inside it in the old application. In summary what do you do if you want to bring in portion of an app but don't want to bring in the data store entity it had?

I have a pdf of invoice details. Now I want to fill the user form from the pdf automatically by clicking. How to do it?

a!localVariables( local!chooser:1,{ a!columnsLayout( What I did here is I created 4 different interfaces (Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis) and now I want all these different interface inside one interface i.e The one I am working on which is facing this error. What I want is to use Radio button and when I click on 1st option I want the 1st interface(Create New Exam) to display and for option 2 the 2nd interface and so on. How can I resolve this error or maybe other way to bring the interfaces in one single one? Below is the code for the 5 the interface I am working on columns: { a!columnLayout( contents: { a!radioButtonField( label: "Exam Module", labelPosition: "ABOVE", choiceLabels: {"Create New Exam", "Manage Exam","Attempt Exam","Exam Analysis"}, choiceValues: {1,2,3,4}, value: local!chooser, saveInto:local!chooser, choiceLayout: "STACKED", validations:

If i delete tempo reports in lower environment same change should reflect in higher environment i.e auto deleted while deployment . Is this possible ? If not how to achieve this..Because I don't have production access to delete

I have created a single interface that is being called by two separate interface but the text in richtext display should be different only. Everything else will be as it is. How to do that?

Hi All, I am Unable to do Sorting on Columns in Records Data Source is Webservice (Using an Expression rule to fetch The Data). Sort Column is already added in Grid Section of Record. Also i have Tried initial and Secondary Sort option availble in Record Section . Secondary Sort: { a!sortInfo( field: OneDate ascending: false() ), a!sortInfo( field: twoDate ascending: false() ) } Initial Sort:  a!sortInfo(field: dateFieldascending: false()) Its Working only when record Loads for First time For next time when we click on column it is not working.   Thanks in Advance!!

Hi Team, how to validate below scenarios a!localVariables( i have A,B,C,D Values and local!name, if local!name = "X" then values should be A>B>C>D and if local!name = "Z" then it should validate A<B<C<D and in any other local!name value it should accept only numeric  values 

Hello, I was wondering, what would be a good way for a software development team to work on the same project and maybe even the same objects?  Thank you for sharing some insightsThomas

Good Morning Community, I've been experimenting with a simple interface where I need to clear the selected results when going to another page. I suspect it is in the index/batch size area, however I'm not having any luck. a!localVariables( local!selection : null, { a!sectionLayout( label: "Test Details", labelSize: "SMALL", labelColor: "#007958", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!gridField( label: "", labelPosition: "ABOVE", data:{ { ONE: "One", Pho: "Alpha", Is_Primary: "True" }, { ONE: "Two", Pho: "Beta", Is_Primary: "False"}, { ONE: "Three", Pho: "Gamma", Is_Primary: "True" }, { ONE: "One", Pho: "Alpha", Is_Primary: "True" }, { ONE: "Two", Pho: "Beta", Is_Primary: "False" }, { ONE: "Three", Pho: "Gamma", Is_Primary: "True"}

I want to show a record action (edit record) within a read only grid - this works as in its shows the auto generated button in each cell (I've orientated myself here: https://community.appian.com/discussions/f/user-interface/18614/recordaction-in-an-read-only-grid).  I wonder, if it is possible, to replace that button - e.g. with a text(/link) or an icon?

once I click on the document download link, getting this error , rather than document download...?

Hello, is it possible to change the position of an action button from left to the upper right corner (as it seems to be the default when pre-viewing a record type). My self-built interface with a read-only grid: The auto-generated list-view (which I like a litte bit more) Thank you in advanceThomas

20000000 is displaying as 2e+07.

Hello everyone,  I have a local variable that query data from data table.The data looks like below:  local!cases: { (clientId: 234,group: 55), (clientId: 600, group: 66), (clientId:234, group: 77), (clientId: 600, group: 88), (clientId: 234, group: 99) } I want to get the group name of only client number 600. Below is my code:  index(local!cases.group,wherecontains(600,tointeger(local!cases.clientId)),null), And got this error:  Invalid index: Cannot index property 'group' of type Text into type List of Number (Integer) Any one got an idea what the reason is? Thanks a lot!

Hi all, How can we embed External Interface into Appian, such as a Tableau dashboard which is Published on a Web Server. i have used webContentfield(). a!webContentField( label: "Tableau Dashboard", labelPosition: "ABOVE", height: "MEDIUM", source: "xxx" ), i am getting below error

Hi, Is there any function or a recipe to get all the basic users. Please help

Dear Sir/Madam, I'm a newcomer with Appian RPA. And I'm trying to build a very simple process with steps for studying like this: Open a Google Chrome -> Search a keyword ex: 'World Cup' -> Then click a hyperlink or something like that. I have tried to find a document that similar guided end-to-end steps but not found so far. Could anyone have or suggest me anything else for newcomer? Thanks so much in advance.