-
Recently active
I have uploaded multiple images in the document folder in my application using 'Upload File' option in the Action and Image Id of these images is stored in the database table. Now I want to display these images in the record grid for which I am using the below method in the 'Edit List' feature of the List option of the record: a!documentImage( document: fv!row[recordType!Car.modeldetails.Image] ) Where image is the name of column storing image IDs in the modeldetails database table. But by executing this I am getting the below text as the result in place of image: [@attributes=[@anyAttribute=[_cId:7ea9cd6ac69bf45fb67452fc4de3351f], @nil=], document=[Document:405304], caption=, altText=, link=, actions=, backgroundColor=, version=] Please help me as I want images to be displayed in place of text (image details).
Hi All, I have a table Emp_personal_details and i have around 200 records in that table. Now I need to Insert around 400 new records into the same table. But the new records have some duplicates which are already in the DB. How can I write a sql script to check duplicates in the table and insert the remaining records into the Appian DB. Thanks
wherecontains(null, {"a", "", "b"}) returns 2 i need to get an index of non null values , e.g. in above case it should return {1,3}
load( local!empStatus: { { name: "Ajay", status: "test1" }, { name: "Ajay", status: "test2" }, { name: "kumar", status: "test3" }, { name: "phani", status: "test4" } }, local!empDetail: { { name: "Ajay" }, { name: "kumar" }, { name: "phani" } }, a!boxLayout( label: "Form", contents: { a!gridField( label: "grid", data: local!empDetail, pageSize: 5, pagingSaveInto: fv!pagingInfo, columns: { a!gridColumn(label: "Name", value: fv!row.name), a!gridColumn( label: "Status", value: a!forEach( items: local!empStatus, expression: fv!item.status ) ) } ) } ) ) Hi All, I have added the sample code and the output where I need to display the corresponding status for that particular name. for example: Name: Ajay Status should be Test1, Test2 and similarly for
Hi all, I am facing some error regarding insufficient group permission. I used a!isusermembergroup() function in a query filter inside applywhen parameter for validation to get list of tasks for a particular group. I am not ale to view the tasks if I am not part of admin group. The visibility permission is "Restricted" for all the groups and gave administrator access for admin groups in security .Please let me know how to resolve this error on insufficient permission.
Hi All, I have a scenario where I am getting a URL of the attachment through an API , So I need to hit that URL , So that my file are downloaded . How can I achieve this with the help of Process model or is there any other way Thanks In advance
How to change Appian configuration so that all Appian servers don't send publish emails to users.
From the above pic, in the local variables bankruptcy there will be constant 4 values and in the local variable creditPublicRecord there will be some values can be null or more than 1 value. Here we have to compare the creditPublicRecord values with the bankruptcy values and check whether the the creditPublicRecord values matches the bankruptcy values and need to return the count. Can someone suggest the way to complete this. Thanks In Advance, Gousii.
Hi All, Can any one guide me to use Unarchive process smart service plugin? I just need to know the security permission required to unarchive a process. If i am system administrator, I was able to unarchive process but i am not able to do the same if am having basic user permission. Note: I have administrator access to both "Unarchive PM" and target PM(Which i need to unarchive). Also I was able to use "Archive process" smart service successfully with basic user access. Please suggest any reason behind this. Thanks in advance!
Can any one send me where is integration video tutorials for practising in deep
Dears, I have a problem in the calendar interface when the appian language is in ARABIC. The date shows and saves in Persian numbers such as : ١١٠٥٢٠٢٣. how can I keep the date language for all dates in English even though the user language still Arabic? the Persian numbers are causing me massive errors when I map them.
Hello Team, In Appian we have a Inbuilt function for sentiment score calculation for Text . "a!sentimentScore() " - only for text. And we do have Google Cloud Natural Language connected system to perform entity and sentiment analysis to collect information from HTML or plain text. But,my question is how do we calculate sentiment score based on voice. if the person who is taking Interview , how his voice is analyzed and get Sentiment score. Could you please help me in understanding How sentiment score calculate for Voice in Appian. Regards, J Vinay.
when we apply multi-select dropdown .. comma separated value is getting store in table in single row ..but i how to put in different rows. Output i am getting Field Field Value Dropdown 1,2,3,4 Expected Field Field Value Dropdown 1 Dropdown 2 Dropdown 3 Dropdown 4
Hi, I am working on an editable grid which shows excel data. I am fetching excel data from excel using "readexcelsheetpaging()" function. Now i want to map data to editable fields and i tried to do fv!item.fieldName but it is not working. a!localVariables( /*local!studentData:excelreadcellsbyname(ri!excelFile,{1},{"A1","B1","C1"}),*/ /*local!studentData:excelreadcellsbynumber(ri!excelFile,{1},{1,2,3},{2,3,4,5}),*/ local!studentData:readexcelsheetpaging(ri!excelFile,0,a!pagingInfo(2,10)), local!gridDataType: 'type!{urn:com:appian:SD}SD_Student_Data'(), a!formLayout( label: "Student Details", contents: { a!sectionLayout( contents: { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { /*a!gridLayoutHeaderCell(label: "ID"),*/ a!gridLayoutHeaderCell(label: "First Name"), a!gridLayoutHeaderCell(label: "Last Name"), a!gridLayoutHeaderCell(label: "Em
Hi Team, I have a csv in which I am receiving "11 May 2021 07:08:12 GMT" as text in one of the columns, Is there anyway to cast to Appian datetime type Regards Bihitak
I have a dropdown on an Create record action interface that utilizes a related table for its values. On the Update record action interface I need to have the same dropdown in case it needs to be updated, however I need it to retain the selection that was made when the record was added. I am struggling to setup that connection on the Update interface.
we recently implemented a process to read emails from an outlook inbox using the MSGraph email poller detailed here: https://community.appian.com/b/appmarket/posts/msgraph-email-poller after implementing we're seeing severe performance issues where the poller is only able to process one email per minute. the emails have a 1mb attachment, and per the documentation, we are expecting 30-50 emails per minutes at the very least. does anyone have any insights they can share to get around this performance issue? thanks!
Buenos días. Mi pregunta es: ¿Durante el examen de certificación es posible traducir con google translate? Gracias.
Hi, We are trying to generate a CSV file from CDT and the first heading on the file starts with @ symbol. Now when I open the file in a text editor Appian/plugin adds some extra characters to it. How do I get around this? Example -- the file generated in Appian - "'@ENB"NE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 The output we are expecting - @ENBNE ID,NE Type,NE Version,Release Version,Network,NE Name,Local Time Offset,EAIU,FW Auto Fusing,Site ID213208,macro,22.B.0,r_0130,TELUS,LTSAB0213208,0,not-equip,off,0 Also, we don't want any space in front.
Where can we find the slide decks and other content from Appian world 2023? I attended Charle's Tsui's UX session and would like to reference those slides.
Hi all, I have this issue: i want to select somehow a specified row in a!griedfield component, like ID 24 in the picture below, then start a process with some value taken from that row, with a submit buttom or something similar that can appear when the specified row is selected. Is it possible to achieve this goal? This is a screenshot of my site in which the element of the only read grid are taken from a recordtype, so this is why the ID is coloured in blue. Thank you in advance for the responces.
Hi All, I am new to Appian, during one of my solution development I have found that I have deleted the rows from the oracle table and when I am trying to test the expression rule where I used Query Generator to get the data from that table , it's stil returning the old data. So can you please help me to know that how can I clear some cache or sync it with my tables ? I am using query generator to generate that expression rule.
Hi, how to read mails from gmail using Appian BPM using smart services?
I am working on "Interfaces 103" in the lowcode4all curriculum. I made a mistake and deleted the PF_Goals Record Actions - Delete Goals and Update Goals. Now I am unable to generate any record actions. Please advise me on what to do next in order to continue building the interface.
Hey, I am trying to configure a Picker Custom Field but am getting the following error: "Interface Definition: Expression evaluation error at function a!pickerFieldCustom [line 290]: The function 'suggestfunction' is unavailable." Here is my code: a!pickerFieldCustom( label: "User Picker", placeholder: "--- Select Borrowers ---", labelPosition: "ABOVE", suggestFunction: a!dataSubset( startIndex: 1, batchSize: -1, data: if( local!view = "Borrower", index(local!borrowers,"borrower",{}), index(local!lenders,"lender",{}) ) ), value: if( local!view = "Borrower", local!selectedBorrowers, local!selectedLenders ), selectedLabels: if( local!view = "Borrower", local!selectedBorro
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.