Foundation

Hi All, we have requirement as mentioned below: We have excel file which contains multiple sheets and each sheet having multiple rows of data. we have to read each row from the sheet and pass the input to external system. external system will send back response to appian where it create case. please let me know how to read data one after another from each sheet. can we directly read from excel. Please share the inputs.

I have an interface where am uploading  image files by using a!fileUploadField() and I need to preview that uploaded  file. How we can display that uploaded  files preview  in the interface. Can any help me about it.

Hi All, We have a requirement that the the excel exported via the excel export smart service is having all the columns in non expanded format due to which they cannot see the data without expanding the columns size.  Is there a way to send excel in such a format that if some column have huge data then it is automatically expanded on opening without manually clicking and opening it. Thanks  Bihitak

Does anyone know if it is possible from appian to update the index of a Word document? Does anyone have a solution for this ?

Hi all. I took the exam and failed. I scored really low on SDLC information, expressions rules and process models. Where should I go to further study those three concepts? Specifically, I had a hard time knowing which Appian function to use in an expression. Thank you. 

Facing this issue while saving the data in the DB.... Anyone help...

while importing a package I am getting 'could not be finalized: insufficient permission (APNX-01-4071-009)' for process models. I have designer access on that environment.

Hello! I have a process to daily delete files older than 15 days from temp folder. Right now it deletes all files from this folder with the node Delete Folder Content.Howe can i configure it to keep those ones created in the last 15 days? Thanks!

Is it possible to declare more than one variable using a with statement in Python? Something like:  from __future__ import with_statement with open("out.txt","wt"), open("in.txt") as file_out, file_in: for line in file_in: file_out.write(line)

Using the below code to trim the character count and limit the characters below 65000 in a paragraph as the character count in the interface is different from the character count when we paste the same in the word document.please suggest changes and attached the screenshot of interface count and character count if( local!isEdit, a!paragraphField( value: fv!item.body, saveInto: fv!item.body, characterLimit: 65000, showCharacterCount: true, height: "TALL", validations: if( len(fn!trim( fn!substitute( fv!item.body, char(10)," ") ) ) > 65000, "The communication you are trying to send exceeds the character limit allowed. Please send a modified version of the letter to not exceed [65000]", null )

Good morning, Is there any way to change the tab name (e.g. Chrome) and force it to be different than the record title of a record view? For example: I would like to keep the record title (Tramitador/ Expediente / ...) but change the tab name (red circle). Do you know if it is possible? Thank you.

Hi I have writeToMultipleDataStoreEntities in my interface, I wanted to retrieve only the primary key values when insert happen.  onSuccess:a!save(local!emplEntity,fv!storedValues) 

Limitations of Query Entity and Query Process Analytics

Hi, Requirement is to create one expression rule in which I need to pass another expression rule as rule input, I do not know what type of rule input to define. Use Case - Have integration, need to call through expression rules, if integration is failed, I need to retry n number of time. and if it returns success, break the calling chain of integration Thanks, in advance. Shree Krishna  

ERROR:Work item cancelled (Data Outputs) Hello We have a problem in PRODUCTION. The service account that is used for deployments from PRE to PRO through the compare and deploy component, was deactivated, now after activating the service account again, the processes keep failing and it shouldn't since the service account is already active. Does anyone have a solution for this? The error that comes out is this: ERROR:Work item canceled (Data Outputs)

Hi  I am trying to refresh my Data stored in the expression. There is link which stores true, false in local!refreshBool and I want to refresh the data based on that. This expression rule pulls data from Integration. But the Data is not getting refreshed. When I TEST interface the data is refreshed but not when I click on link  local!data: rule!TA_getAndFormatRandomUser(), local!refreshBool, local!refreshData: a!refreshVariable( value: local!data, refreshOnReferencedVarChange: local!refreshBool ),

I try to selec one radio button with a dinamik link but the value is null in every moment.

Hi Everyone, i had a requirement to display Number (Integer) value  inside donut (piechartfield)

I want to create below boxes dynamically for example if I receive 5 values from DB then there should be 2 rows and 3 columns, 1st complete row and 2nd row with 2 items

How many sites can be created for an application? Do we have any limitation in creating no of sites for an application?

Hi, Actually I am looking for: how we can add the if condition in word template. we have added like this «[#if doc.tech.showDate=="true"» but we are getting   doc.tech.showDate value as null....so throwing an error like cant compare null o string.....how to add condition in XML for that if condition how we can show the signature in word template...lets say for example we have 4 employees each employee will draw a sign using signature component in appian that eventually store as a document in appian. how we can put the signature document in WORD Template. Can anyone help me on this. Thanks in advance, Gousii.

Hi All,           From the Appian community page, I have noticed that they will give a  free voucher for certification for following Courses: Appian Foundations, Appian Developer or Applied Development after completion of course, and it is strictly mentioned  that only for public instructor-led training . Is it only for paid courses or free courses as well? Please let me know if anyone know about this. Link: Appian Community Thanks & Regards, Saidivya Minna.

I'm trying to implement google maps in my UI but I want to show the pin marker on logged in user's current location

Hi, I am facing one challenge to sort a list of addresses into particular order. The appian sail expression should match the sorting order as in our C# equivalent using orderby and thenby. My SAIL expression is not giving same results as C# code(Expected one).Kindly provide suggestions. in c#: sortedAddresses.AddRange(addresesList.Where(x => x.AddressId != primaryAddress.AddressId).OrderByDescending(o => o.EndDate).ThenByDescending(o => o.EffectiveDate).ThenBy(o => o.AddressType.Name).ThenByDescending(o => o.IsActive).ToList()); in SAIL: todatasubset( todatasubset( todatasubset( todatasubset( remove( local!7sortedaddresses, wherecontains( touniformstring(local!primaryAddress.addressId), touniformstring(property(local!data, "addressId", "")) ) ), a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo(field: "endDate", ascending: false()) ) ).data, a!pagingInfo( startIndex: 1, batchSize: - 1, sort: a!sortInfo( field: "effectiveDat

Hi, I currently have a a!gridField() that is being used to add a list of samples. We have made the grid list selectable so that all rows can be selected, however there is a current request to have all rows in the grid selected without having to page to the next set of samples in the list when selecting the checkbox to select all rows. I wanted to see if this is even possible to configure in Appian?