Discussion Categories

Hi Guys,       I had some react Ui application I want to use it in the Appian interface how can I do that? without custom plugin is there any anyway? Many thanks in advance

Is there a way to use ReactJS UI components in Appian?

I created a new Schema/Database in our cloud database. . However, when I try to connect to the database in my new application (Data Store), it does not show up.

I've often had the request from clients for task notification customization: - Send to a mailbox not necessarily tied to an Appian user (they are using a shared mailbox or the user has not yet been created in Appian) - Send custom template The workaround I've been using is a little convoluted where I start a sub process on a timer before the task is initiated, it queries a task report to go and get the Task ID to be able to construct the task URL to put in the email. Would be nice if we could just customize this directly on the task itself without resorting to the subprocess/timer/task report approach.

Hello everyone, I am using the add row dynamic link in the editable grid interface for the child interface. I have field as story points for the parent interface and also have story point for child interface. Lets say I have story points 5 for the parents interface. Is there any way to automatically pop up another row without clicking the add row dynamic link when the child interface story point is not equal to 5. Lets say parent interface story point is 5. So if I put 2 as story point for field in child interface another row will pop up without clicking the add row dynamic link.

Hi there, right now in Appian what I know is that if we need to go to certain record, we have to keep clicking ">" until we get there.  Could anyone let me know how to implement the page drop down, so we can directly get to the record by choosing the page?   Regards, Lin

I recently got an error that said this:"The list of records to be saved must not be null or empty: TypedValue[it=3145,v={}] Data: TypedValue[it=3145,v={}] "But how can I identify which field or type its referring to?I assume that "it=3145" is a particular type or field identifier but I don't know how to look it up. I wish it would should an actual name in the error message instead of an ID / "it".

Hi All, I have multiple sections where the user can upload document and for each section we have "add document" button like below, I have to validate for document size if it is more than 10MB,and this validation is for add document button.I am not getting how to validate the document based on index using fv!files. Because of this,if user adds more than 10MB in 1st sec and adds less than 10 MB in 2nd sec,for both section it validates for "Add Document" button. Please help me how to resolve this.

We have a requirement where we display/hide the related actions for a particular record based on the approval or rejection of tasks. We are observing that the even though the record grid data is getting refreshed when we click on the refresh button, but the related actions are not getting refreshed. Please find a sample snippet of the code:- a!gridField( labelPosition: "ABOVE", data: a!recordData( recordType: recordType!SampleRecord, filters: rule!SampleFilterRule() ), columns: { a!gridColumn(), a!gridColumn( value: a!recordActionField( actions: { a!recordActionItem( action: recordType!SampleRecord.actions.SampleAction, identifier: fv!row[SampleMetric.identifier] ) } ) ) }, validations: {}, spacing: "DENSE", borderStyle: "LIGHT", shadeAlternateRows: false, rowHeader: 1, refreshOnVarChange: ri!refreshVariable, refreshAfter: "RECORD_ACTION", showSearchBox: true, showRefreshButton: true(), showExportButton: false,) What can I do to resolve this?

Where to set reply-to in send email smart service?

Hi, I want to send sms to mobile number for authentication. Can anyone know best possible way?

Hi Appian People! I have this code that split the value inside the CDT. So for example I have a CTD: 'type!{urn:com:appian:types}T_Sample'(  name: "Person",   place: "City1,City2,City3"   ) When splitting the value, the output should be like this in an array form: Expected: ["Person"; "City1,City2, City3"] But the actual result I got is:  ["Person"; "City1"; "City2; "City3"] the place where split in different index where it shouldn't be. This is my current code local!splittedCDT:split( stripwith( tostring( ri!cdtVal ), "[] " ), "," ) local!updatedVal: a!forEach( items: local!splittedCDT, expression: replace(fv!item, 0, find("=", fv!item, 0), "") ), Is anyone could help me with this? Thank You ahead.

Can anyone please tell what does value column denotes for row 2 and 3 from the above image(Appian Health Check Report). In row two value is mentioned as 616383, Is that something related to total memory consumed or something else?

Hi, I am using a Navigation (Lightweight) pattern. When the user clicks on the left menu for example 2nd menu item, I am able to load the respective page. But, when I try to save the data on the 2nd menu item page, after saving it is loading the first menu item page. It is not staying in the same page. Any advises here please.

I have an interface with some dropdowns  The idea is the user selects a drop down which then informs the next drop down list.i.e. drop down one changes the list shown in dropdown two - thats fine and working well,The issue I appear to be having is getting the rule input value to change at the same time for the second drop down (values are expression rule driven) it appears to only update a step late for example if the user selects xyz and this is value of 27 then the ruleInput value will not update until the user changes the selected value to say abc with a value of 88 and then the rule input updates to 27!!! My real annoyance with this is the local variables show the correct values which means that for whatever reason this is not being pulled into the Rule Input at the same time!!!I have taken the time to reconstruct this issue without any specifics below: - Rule inputs: "dropOneRI" as in int"dropTwoRI" as an int"problem" as an int a!localVariab

In SQL I would write something like this:SELECT * FROM parent WHERE parent_id NOT IN (SELECT parent_id_fk FROM child)or SELECT * FROM parent WHERE NOT EXISTS (SELECT 1 FROM child WHERE parent_id_fk = parent_id) In Appian expression language I can find children with no parents by finding records with null in the relationship as described here:https://docs.appian.com/suite/help/22.4/fnc_system_a_queryfilter.html#using-a-relationship-reference-in-the-field-parameter The example in the documentation is like so: a!queryRecordType( recordType: recordType!Employee, filters: a!queryFilter( field: recordType!Employee.relationships.teams, operator: "not null" ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100 ) ).data However this is not what I want, I want to find parents with no children.I think it might look something like this: a!queryRecordType( recordType: recordType!Parent, filters: a!queryFilter( field: recordType!Parent.fiel

I know that Appian may not be the best environment for this, but I'm wondering if this is possible. It is possible to create a simple shopping site using Appian? The table design is simple enough: CATEGORY- categoryId- name- description ITEMS- itemId- name- description- price LOOKUP_CATEGORY_ITEM- itemId- categoryId CUSTOMER- customerId- firstName- lastName- street1- street2- city- state- phone- email CART- customerId- itemId I've done this many times before in different languages/environments.This has MANY TO MANY, MANY TO ONE, aggregations and design/ui considerations with this project.I've deliberately ignored the payment portion/part of the project.  

Hi sample Input : {a,b,c},{100,200,300} sample output : a-100,a-200,a-300,b-100,b-200,b-300,c-100,c-200,c-300

I have a condition where i wanted to do null check if either of the IDs are null it shoudn't write to database. I am using this code in task output. remove( wherecontains( or(a!isNullOrEmpty(pv!primaryId)), a!isNullOrEmpty(pv!selected) rule!NV_constructCDT( formId: pv!form.FormId, primaryId: pv!primaryId, secIds: pv!selected, ), )) Do you have any ideas to optimize this implementation? Thank you

Zuuuup, people ! So, I'm trying to execute a process in background when a user does click a button, for example. Wanna execute it without leave the page or open a new one. For now, we're using a startProcessLink and this behavior leads user to a page that goes back to home page. Any idea to manager this situation?

Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below: Batch Size = 1000; Data Source Name = "jdbc/Appian"; Database Field Names = {  "EQUIPMENT_NO",  "MATERIAL_TOT",  "SUPERIOR_EQUIPMENT_NO",  "SUPERIOR_TECH_ID",  "CALCULATED_ACTIVITY",  "NEXT_LEAK_TEST_DATE",  "HAL_SERIAL_NO",  "ISOTOPE",  "SORT_FIELD",  "AMI_DOCUMENT_NO"}; Excel Document = pv!sapInventory; Excel Header Names = {  "Equipment",  "Material/TOT",  "Superord. Equipment",  "Superior TechID",  "Calculated Activity",  "Next Leak Test Required Date",  "Halliburton Serial No.",  "Isotope",  "Sort field&qu

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18}Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

I need to setup an intergration between UiPath and Appian, and have learned that by using the "Appian Activities" utility and "UiPath Connector" plug-in, the connection between the two could be done. Meanwhile, I also notice that when searching related information through Appian Document, UiPath seem to be associated with RWM to some extent. I would like to confirm that whether I need a RWM in order to finish the setup. Does anyone have any idea about how RWM function within the process indicated as the picture above.

in an a!imageField() is there a way to remove the white border that is put around the image when it's put in the interface? 

Previously we were using a hyperlink as a record link to open up a summary view,as per the  customer's requirement the design has been restructured (not using record and record link)and currently we are using dynamic link as a hyperlink to open up a summary interface.The Problem here is that,when we use appian's inbuilt export functionality, as we are not using the record link as a hyperlink,it is just appearing as a text instead of link.Is there is any other suggestion you would give here in order to get back that link in the exported data?