Discussion Categories

just wanted to know the step how to trigger an record action from submit button

As there is so much white space shown .. how to prevent in interface ,extra white space

Hi  I want to add two user filters in record the data to those two filters is two columns data from DB when i tried was getting error like below  And the data have duplicate values but need unique values only kindly suggest for this also a!recordFilterList( name:rule!ATRFA_translateLabel(field:"wbs"), options:a!forEach( items:cons!ATRFA_ENTITY_SETTLE_REQUEST, expression:a!recordFilterListOption( id:fv!item.wbs, name:fv!item.wbs&" ["&fv!item.wbs&"]", filter:a!queryFilter( operator:"=", field:"wbs", value:fv!item.wbs ) ) ) ) Error: The Requested Record Type Is Not Available The WBS user filter expression for record type ATRFA_Settle_Request failed to evaluate. Details: [Expression evaluation error at function a!forEach [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!recordFilterListOption [line 7]: Invalid index: Cannot index property 'wbs' of type Text into type

If I want to develop look alike application as IDP in a simple way. What are things need to be considered in designing, development?

Is Appian supported with multi-factor authentication for the created applications? i.e. end-users will be required to login with 2FA whether SMS OTP, Email, or Google Authenticator. I found a link here in the community, however, it's broken.

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

Hi, Is there a way we can provide a link in an interface to download the data in an excel from a recordtype. Thanks

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.

Hii Team, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Currently we are trying to use webhook for getting back the signed document from adobe. But in the creation of webhook itself, we are getting an error that &quot;webhook URL is invalid&quot;. We have tried becceptor with adobe for testing purpose. So it worked there . But when we tried with our production environment&#39;s webapi URL, we weren&#39;t able to create webhook.&nbsp; We have provided the webapi URL as webhook URL in the format mentioned below, [https://:[apiKey]@webapiurl].&nbsp; But still we are getting that error message. Can anyone suggest how can we resolve this? &nbsp;&nbsp; Thanks in advance.

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

Hi Experts, How to use Index Function to extract&nbsp; whole row data from a list of records based on one record field value? We want to extract one row data from local! data where one fieldname : id has a value: 100051

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

The way I understand it is that the idea of Record Sync&nbsp;is to replace the functionality of database views by creating relationships between tables which work like joins in views. That being said, a big part of database views is joining transactional tables which store ref IDs with ref tables to get the display values. Would it be considered an anti-pattern to create a record type for a ref table and join that to the transactional record to display a ref id&#39;s display value, or is that under the intended functionality of Record Sync

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.

I have CDT with following fields While using a!toJson , it is&nbsp;EXCLUDING fields which are having NULL values except fields with TEXT datatype. Expresion: -&nbsp; a!localVariables( local!data: &#39;type!{urn:com:appian:types:RS}RS_dummyCDT&#39;(id: 1, name: &quot;abc&quot;), a!toJson(local!data)) Result: &nbsp; Note:&nbsp;If I use parameter&nbsp;removeNullOrEmptyFields as true, it also excluding text fields which are null a!localVariables( local!data: &#39;type!{urn:com:appian:types:RS}RS_dummyCDT&#39;(id: 1, name: &quot;abc&quot;), a!toJson( value: local!data, removeNullOrEmptyFields: true )) Result: While using a!toJson_17r1, it is returning all the fields of the CDT irrespective of NULL values. Expression:&nbsp;a!localVariables( local!data: &#39;type!{urn:com:appian:types:RS}RS_dummyCDT&#39;(id: 1, name: &quot;abc&quot;), a!toJson_17r1(local!data )) Result: I want to get the data the way we are getting result while using&nbsp;a!toJson_17r1. i.e. I want to get all the fie

Hi, There is a stored procedure that updates the database and soon after we trying to sync records in a subprocess.Sync of all records and related records based on identifier is done.It has been observed that certain processes are being paused while others are completed fine. This is random behavior and no error on process model. Please let me know if any solution regarding this. Thanks, Bhavika