Foundation

Hi Experts, We got a specific scenario from our client where we have to keep our process waiting until a time provided by user matches with the server time. So from the UI user is providing date in one field as &quot; MM/DD/YYYY&quot; and time in a different field as &quot;HH:MM:SS&quot; and timezone in another field.The process node must only gets triggered or move to next node only when time provided by user matches with the server time.I&#39;m using below code but its not working as expected a!localVariables( local!split: split(ri!endSearchTime, ":"), local!day: day(ri!endSearchDate), local!month: month(ri!endSearchDate), local!year: year(ri!endSearchDate), local!endSearchDateTime:datetime( local!year, local!month, local!day, local!split[1], local!split[2], local!split[3] ), todatetime( if( local!endSearchDateTime - ((gmt(local!endSearchDateTime) - local!endSearchDateTime) - rule!TEST_ER_TimeZoneOffset(ri!endTimeZone)) < now(), now

I have a Process Model that creates a record. That record has a field &quot;record types&quot;, which can be A, B, or C. Based on which record type is selected, I would like to create a record from a related table with additional inputs. I have tried following this documentation:&nbsp;https://docs.appian.com/suite/help/23.1/Write_Records_Smart_Service.html#create-records-and-related-records,&nbsp;but there is a lot that it leaves out.&nbsp;Here is an example. If the Record Type is A, the process forks down to &quot;Create A record&quot;.My problem is creating the A record. The A table has a 1-1 relationship with the Record table.Some specific questions I have are:What should&nbsp;the process variables be set up like for this?&nbsp;How should the &quot;Create A record&quot; Data section be set up for this process?Both tables have Auto Incrementing IDs, is any additional setup needed for this on the actual Appian platform? If so, what?Are there any additional services or processes needed

I am training the document in the reconciliation task. i am able to read all the text fields. but unable to read the check boxes. What could be the reason? Thanks in advance

Hi everyone, how can I obtain the list of the extension of files that are shown in an interface by the document viewer?I checked the documentation and there are no indications or lists about the formats allowed.

Hi, I have a constant which contains array of text, I want to check if a given value is in the array subset of that constant. For that I&#39;m using- contains( { cons!TA_CITY_LABEL[1], cons!TA_CITY_LABEL[3], cons!TA_CITY_LABEL[4], cons!TA_CITY_LABEL[7] . . . and many more }, local!label ) I wonder if there is any solution to it as I have to write the name of constant again and again and I&#39;m checking this multiple times on different datasets.

I have an expression rule which is containing a data with multiple values, I am trying to insert that data to dropdown choice labels and choice values but I am not able to do that.Can anyone help me to configure that?

I have file(docx,pdf) and i have to retrieve or extract comments from the that.

Hi Expert, I have made a expression rule which is returning datasubset . For eg: This is my query entity returning data. Col A &nbsp; Col B&nbsp; &nbsp;Countcolumn a &nbsp; &nbsp; &nbsp; &nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 d &nbsp; &nbsp; &nbsp; &nbsp; e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 g &nbsp; &nbsp; &nbsp; &nbsp; h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Now i want to repeat row based on count column.How can i achieve following output: Col A &nbsp;Col B a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; e d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;e g&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; h Please help.

Has anyone been able to run FitNesse for Appian with a Password File? http://fitnesse.org/FitNesse.UserGuide.AdministeringFitNesse.PasswordFile Here&#39;s what I&#39;m seeing.&nbsp; All runs use the following command java -jar fitnesse.jar -a "passwords.txt" where the passwords in each file are cleartext or encrypted passwords.txt users.properties Result cleartext cleartext good encrypt cleartext good encrypt encrypt Invalid argument encrypt no user=password line error encrypt no file error cleartext no file error When it&#39;s run, the authenticator&nbsp;says MultiUserAthenticator (password.txt) versus PromiscuousAthenticator (users.properties).&nbsp; But, the above tests seem to indicate that passwords.txt is being ignored completely and FitNesse is only using users.properties. I hope someone can shed some light on this for me.&nbsp; Thanks

We have a requirement to showcase end users the deployment details like we developers can see in the deployment tab inside designer.&nbsp;Business Users wants to see the incoming deployments for a specific application, time, number of Objects , Object details, object versions etc.&nbsp;Is there any way we can achieve this ?P.S I have installed log reader plugin to read deployment logs but unable to see details

Hello: I have the following code and the &#39;assessment score&#39; (which, for now, is a value generated by a rand() function) changes value when I click on the &#39;Show details&#39; icon.&nbsp; Is there a way to prevent that from happening? Thanks! a!localVariables( /* We load the employee data into this variable. If you are populating this variable with a query, you would put .data at the end before passing it to the grid. */ local!employees: { a!map( id: 11, name: "Elizabeth Ward", role: "Senior Engineer", team: "Front-End Components", pto: 15, startDate: today() - 500 ), a!map( id: 22, name: "Michael Johnson", role: "Payroll Manager", team: "Accounts Payable", pto: 2, startDate: today() - 100 ), a!map( id: 33, name: "John Smith", role: "Quality Engineer", team: "User Acceptance Testing", pto: 5, startDate: today() - 1000 ), a!map(

I want to do something like this: CONST MIN_YEAR&nbsp;= 15 int[] yearOptions for int i = year(date)-MIN_YEAR to year(date)+1 { yearOptions.push(i) } How can I do this in Appian?I suspect this need to be an expression rule and the number 15 may change while I&#39;m working on the interface.

Zuuuup, people ? So, I&#39;ve been developing a process model (not from begin, some other guy started development before me) and, sunddely, everytime I click on the drop with variables, all tabs in chrome with an Appian url rise an error about &quot;out of memory&quot;. I&#39;m trying to click on this drop:&nbsp; Is it something knowed? I mean, may I or someone else missunderstanding some config ? Thanks anyway for your time spent reading my question !

Hi, How can I disable &quot;show objects&quot; icon which is appearing&nbsp;at the bottom right of Appian site.

Hello, Does anyone know how can I populate the&nbsp;node input &quot;Custom Cell Values&quot; on the smart service &quot;Export Data Store Entity to Excel&quot; with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?&nbsp; The same can be accomplished with plug-in &quot;Export CDT To Excel&quot;, considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Hi All, Is there a possibility of Highlighting a field , when it is updated. we have a scenario, where a user updates some fields of a record&nbsp; and send it for approval. The manager should be able to see the fields updated as Highlighted, based on which he can take decisions. Warm Regards Vineeth

Hi, I&#39;m getting below error with the below code. Please help me in resolving this a!localVariables( local!selection, local!selectedProduct, local!rowSelectionIndex, local!docCodes, local!removedPropertiesList, local!finalNotificationProperty:a!refreshVariable( value:ri!finalNotificationProperty ), local!removedPropertyIdList:a!refreshVariable( value:ri!removedPropertyIdList ), local!documentCodes, /*local!tempDate,*/ a!sectionLayout( label: "Product Details", contents: { a!gridField( label: "Read-only Grid", labelPosition: "COLLAPSED", data: ri!finalNotificationProductDetails, columns: { a!gridColumn( label: "MK/V", value: fv!row.mkv_txt ), a!gridColumn( label: "Generic Name", value: fv!row.genericName_txt ), a!gridColumn( label: "Trade Name", value: fv!row.tradeName_txt

Hello, Does anyone know how can I populate the&nbsp;node input &quot;Custom Cell Values&quot; on the smart service &quot;Export Data Store Entity to Excel&quot; with the result from the query that is performed on this node ? So basically, a query is performed on the DSE, then on the same node is it possible to map an existing template on specific cells with the result of that query?&nbsp; The same can be accomplished with plug-in &quot;Export CDT To Excel&quot;, considering an existing template and populating specific cells with CDT values. So, since this one is deprecated and Appian advices to not use this plug-in, how can we accomplish the same with this smart service ? Any ideas ? Thank you in advance

Hi, I have the below scenario. I have a master table to which I have to save the data initially. Later if any of the child tables have data then I need to store into respective tables. Also, I have to save the master table autogenerated key column into the child tables. Can someone advise, if I have to use any specific smart services to achieve this. Thanks in advance.

Input: &quot;MAHESH, Output: {&quot;M&quot;,&quot;A&quot;,&quot;H&quot;,&quot;E&quot;,&quot;S&quot;,&quot;H&quot;} how to approach this?

Hi, form is not getting opened and displays the below error: Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = 74a54:998fd] in rule &#39;fpl_frm_etmf_upload_doc_readonly&#39; at function a!forEach [line 427]: Error in a!forEach() expression during iteration 3: Expression evaluation error at function rule!DMD_UT_FormatDate [line 443]: Could not cast from Time to Date. Details: CastInvalidCould not cast from Time to Date. Details: CastInvalid The&nbsp;&nbsp;rule!DMD_UT_FormatDate&nbsp;is having the formation as&nbsp; if(isnull(ri!dtDate),ri!dtDate,text(ri!dtDate,&quot;dd-mmm-yyyy&quot;)) The parameter&nbsp;dtDate is a date field. Could someone tell me why user is getting this error. Thanks Faisal

Hi Community , I had started to do a project where the use case is without using the rule input I have to get the data and write it in the database. As a start I created all the basic steps of creating the record type and generating the record actions where as an result automatically process model and interface&nbsp;are created.&nbsp; I tried to map the record type fields via local variable in the interface such that when I moved over to the process model I can&#39;t able to write up the data in the database . In general&nbsp;I wanted to publish a portal such that when I tried to add pages ( Interface ) , a error occurs like rule inputs variable can&#39;t be used , So I started to prepare the above use case and to solve it. So kindly guys help me out with proper steps to handle over interface and process model. Thanks in advance..!

So we have a portal where the entire interface is in a!formLayout. Within the formLayout is a section that contains a billboard. We want the header to span the entire width of the page, but billboards don&#39;t do that, they have a margin on the right and left side. I know a!headerContentLayout allows the billboard to stretch the entire width of the page - so I figured I&#39;d change the interface to a!headerContentLayout, put the billboard in the &#39;header&#39; parameter, and the a!formLayout in the contents array. But a!headerContentLayout does not support a!formLayout as shown in this error I receive: The contents contain a component that is not supported in the header content layout. Received: FormLayout&nbsp; Is there a way to make the billboard/header stretch the full width of the screen in this situation? Thanks for any help!

We are trying to get an excel document from a SQL Query and we are getting the following error:&nbsp; Export SQL To Excel An error occurred in executing an Activity Class. We tried to rewrite the SQL sentences using quotes but it keeps failing the same way. SQL Sentence:&nbsp;SELECT `ORDER_BY` AS `EMPLEADO`, `PLATO`, `IS_PAN` AS `PAN`FROM `SL_ORDERS` INNER JOIN `SL_LUNCH` ON `SL_ORDERS`.`LUNCH_ID`=`SL_LUNCH`.`ID`WHERE `SL_ORDERS`.`ID` IN (&#39;1&#39;, &#39;2&#39;) AND `SL_ORDERS`.`DIA_SEMANA`=&#39;1&#39;We know the problem is from the SQL sentence because if we put a typical Select * table without anything else works, so everything else is fine in the input section.

Import excel to Database smart service not including any rows where row is less than batch size.i am uploading an excel with 121965 rows in it with batch size 1000.now the problem is Appian is only considering 121000 rows and excluding last 965 rows. can anybody help?