Discussion Categories

I have to create such a functionality where I have to show a search bar using which CA can drag and drop the document into interface. And the dragged documents should be put in a grid having delete icon besides them. How can I achieve this functionality in Appian interface.

Hello All, We are migrating our db from Mysql to Postgre.  Postgre uses some different datatypes as compared to mysql (eg. boolean) Has anyone worked on the migration of the whole db to postgre, if yes can you please provide few steps on best way to do it?  Esp the cdt(xsd) part. Database we have migrated, but we are finding hard time in updating the cdts. Thanks in advance!!! 

hii all, in a editable grid i am fetching backend data by selecting a product name ,if i have selected product name then in next field the respected product description should come , after filling all the fields in editable grid i am going to submit and updating a data base , here every field  of editable grid is storing except the product description, respected product description is showing in the grid layout but its not storing in to data base ,but if i edit that product desciption and  submitting then its storing in the database . please help me  my requirement is to fetch product description by selecting a product name in grid and storing it in to the database thanks and regards, b ramesh babu

I am trying to return some values in a web API of mine where I call an expression rule that maps the vales that are wanted. The thin is I used index() function to cast the values like this  childId: rule!A_QE(index(fv!item, "id", null()))['recordType!{record}Record.fields.{record}.childId'], where the item is going through an iterative loop to fetch each list. in the web API it is getting returned as:  "childId" : [ 777 ], which i do not want it in this form i need it to be returned in the following form: "childId" : 777 , I tried to add at the end of the index, [1] and it is still returning the same form..

Hi All, As part of practice and POC purpose. There was requirement like i have created three drop down fields on UI and also there are also Three tables created DB(Tables- States, Cities, Towns). Sates- drop down and City-Drop down working as expected based on selected state value cities were displaying but based on selected City value towns drop down field values not showing up. null parameter was passing when i checked local variables. i tried different ways but not able to achieve this. could you please help on this.   below code for reference a!localVariables( local!stateData: rule!KT_getStateDataById(), local!stateName: property(local!stateData, "state",null), local!stateId: property(local!stateData,"id",null), local!cityname: rule!KT_getCityByStateId(stateId:ri!stateid ),  local!townname: rule!KT_getTownNameByCityId(cityid: ri!cityId), { a!sectionLayout( label: "", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a

I run a small cleaning business in australia, so I need to collect reviews/feedback from customers, but I want to avoid negative reviews, so I am trying to create a page on my website that has buttons for redirection based on what customer choose. But the problem with a page with buttons is, users can anytime come back to the page and click again on other button to leave negative review, so it will backfire. So, I seriously need a fullproof method to use redirection method so I can collect positive reviews on GMB and negative feedback on a form so I cam improve on those points. Is there anyway I can use any platform different from Wordpress for my feedback page? Or can create a completely different feedback page with html? (also I don’t want Google to index my feedback page so my competitors won’t see my method). Any help on this is appreciated. Solution needed ASAP. Customer Feedback Sample Page I need help with: https://superiorcleaningandpest.com.au/customer-feedbac

I am using the Fill PDF Smart Service from the PDF Tools plugin. I have a fillable PDF with an image field that I am trying to insert an image into. The image is stored in the knowledge center. I have the PDF Field value in the data tab set as such.  { {"name": "image", "value": todocument(pv!documentId) } } However, it is not filling the field and there are no errors when running the process for debugging. Please advise.

Does anyone know how to configure Delete Document to delete multiple documents/images given an array of document ids? 

in interface ,i  want a textbox in which i want to paste some mail addresses and then i need to validate those email address

My robot continuously shows an offline status.I am unable to use the task recorder for robotic tasks. Even after reinstalling the 'installer' multiple times, the robot goes offline again while I am working on the task recorder.What should I do in this situation?

HI All, I am trying to fetch data from the appian report and report has around 50k records. So I am using loop of batchsize 2500 to fetch the data from the Appian report using queryProcessAnalytics(), but when the startIndex becomes 10001 (i.e greater then 10k( it's giving me the following error. What's the possible solution for the same ? And is there a way if I can do it without changing any system configuration.

Hi - We are currently working on building a chatbot. As part of that we tried to mimic the traditional chat UI by leveraging Appian components. However, we are facing an issue displaying the latest message entered by the user on a card layout. A scroll bar appears in this scenario and we need to manually scroll it. Also, Auto height on card layout doesn't work as chat window getting bigger. Any alternative approach or a way that we can take care of auto vertical scrolling on a component? TIA

How to navigate from one interface to another interface ??. Can any one suggest how to do it??

Hi, everyone!I have a problem, I'm designing an interface where you can attach a file but the file must have a nomenclature. Example:INVENTARIO (always) PRESENT MONTH PRESENT YEAR INVENTARIO DIC 2023 But I tried with the follow code:a!localVariables( local!var: { "ENERO", "FEB" }, local!var2; { a!fileUploadField( saveInto: local!var2, value: local!var2, label: "File Upload", labelPosition: "ABOVE", validations: { if( fv!files.name = {"INVENTARIO" & upper(tostring(datetext(today(), "MMM"))) & upper(tostring(datetext(today(), "YYYY")))}, { "Ingrese un documento nombrad correctamente." ), } ) } ) Add to Phrasebook No word lists for English → Spanish... Create a new word list... Copy Add to Phrasebook No word lists for English → Spanish... Create a new word list... Copy TRANSLATE with x English Arabic Hebrew Polish Bulgarian Hindi Portuguese

Hi, I'm using the "DOCX From Dynamic Template" plugin to create docx files and it works well. With this is one I can add some fixed images in the generated document. Unfortunately, with this later, I can not add any type of attached file, and can not not choose dynamically the position of my images.(I've tried to attach a docx Word file but it is unreadable when i try to open it in the generated document) So maybe would you know another plugin that could do this please ?  I would like Appian to be able to add any attached files on any types (ex : pdf, zip, docx...) in my document, and need this plugin to let me add those attached filed in the position I've chosen (for example in the 2nd row and 3rd column of an array, or after a specific text)... Regards

Hello All, I need to rename a file in SharePoint, but having a problem in identifying the correct metadata type tag to make the filename change Output from the integration rule The type used in the below screen is not correct, but I was trying few option with the type. Please advice which is the right type or correct way to rename the file. Thanks Girish Katti

a!gridColumn( label: "Status", sortField: "status", value: if ( fv!row.isTesting, a!iconIndicator( icon: "STATUS_NOTDONE", ), a!iconIndicator( icon: "STATUS_OK", ), )

I am looking for a way to Archive process instances after few days(example 1 day) and then delete those archived instances after 7 days? Do we have anything in Appian which can support both of these requirements. I know we can use data setup to either archive or delete, but not both. Reason: I don't want to delete the instances immediately because that helps troubleshoot issues and i would need to archive as soon as they are completed as there are 1000s of instance generated on daily basis. Thanks in advance.

Hi Team,  I need to populate the data in custom picker. But the data count is huge like 100000 rows available in the database. I have no other filter criteria to reduce the  count. My question is is it possible to populate the values after entering the first three characters of the data or is there is any alternative method available . 

Hi , everyone Site logo always appear right upper conner . I want to show left upper conner how to implement it. here is my site  My desire site image is like that Thanks

Hi All, I have a dropdown with names coming from an integration object but in order to use the integration I have a search field and then based on that it populates the names on the dropdown, when I save it works fine. But if for whatever reason the user decides to change the selected user and search( in the field I provided to search in the integration data - not in the one in the actual dropdown ) again I get an error of Interface Definition: Expression evaluation error at function a!dropdownField [line 169]: A dropdown component [label="Requestor"] has an invalid value for "value". All selected values must be present in the choiceValues array. (With each search the values and labels are different). Anyone that can help with this? thanks in advance

Can we test Appain application using LoadRunner  for Performance testing? If so, could someone guide me to the right documentation? 

We have Modified on Date filed , which is Date Time. Requirement is every hour scheduler runs and pick the data from now to past hour. If the current date time is 26/12/2023 11:30 AM IST then Start Date Time =  26/12/2023 11:30 AM End Date Time  26/12/2023 10:30 AM. Start Date Time I am calculating like =a!subtractDateTime(  startDateTime: now()) End Date Time: a!subtractDateTime(startDateTime: ac!startDateTime, hours: 1) above 2 are giving me proper startDateTime and End Date Time. but when I pass to query Filter, I am using the <=Strat DateTime & >=End DateTime. I have one record with Modified on is 26/12/2023 10:50 AM which is in between Start Date & End Date mentioned above. but still I am getting 0 Records from database. How to construct Start  Time & End Date Time get hourly data. 

Hi, The script gets run successful separately. While run suite(Multiple script together), the particular script gives error. Could you please let me know what may cause for this. Did i miss some step or something else. Thank you for your time.

Hi, I have a cancel button where i had kept submit as true and validate as false but still it is showing to fill mandatory fields. I am trying this in live task instance not in interface editor. Can someone pls help on this?