Discussion Categories

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.

For OAuth 2.0: Authorization Code Grant , I have been provide with client code ,scope ,client secret Id and endpoints .How do I verify whether the connected system is working fine with those credentials

what is environmental variable(what object used to deploy application to another environment in appian)?and how we create it

How do I get into edit mode to update a record without having to go through the Related Actions link first? This is beyond crazy that Appian forces someone to perform an extra mouse click when there should be an option to put the update and delete links directly on the summary page.  Why is this even a thing? There is no reason why your two most common dataset record actions require a completely separate page in order to access.

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

Hi, I have a text field where user is entering website. I am using below line of code to provide a link to the user to navigate to the website. Issue is when user to try to enter link "www.google.com" or "google.com" and when they came to the link and hit it is throwing an error. if( a!isNotNullOrEmpty(ri!site), a!richTextItem( text: ri!site, link: a!safeLink(uri: ri!site,openLinkIn: "NEW_TAB") ), "" ) Any suggestions from anyone.

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...

I am using Export Data Store Entity To Excel smart service to export the data from a table to excel file. When I export everything from the table it works well, however when I use Selection = a!querySelection( columns: { a!queryColumn( field: pv!exportData.TechSpec, alias: "Tech_Spec" ), a!queryColumn( field: pv!exportData.Preservation_Demand, alias: "Preservation_Demand" ) } ) I get this error below : Please help me with it.

The data store "ISR Data Store" [id=163216, uuid=_a-0000e3b5-3910-8000-9ba5-011c48011c48_35304] will be saved, but will not be published: The data source schema does not match the type mappings: APNX-2-4056-000{Schema-validation: missing column [fundingSource] in table [`ISR_StudyMedicalReview`]} (APNX-2-4053-006 Here:ISR Data store in Data store object,  fundingSource is new column, ISR_StudyMedicalReview is CDT. When I tried to move to another environment during inspection I am getting this error .How can I solve this? Thanks

Hi everyone. I ran a test recording with jmeter 5.3 using the appian library AppianJsonParser-20.3.0-SNAPSHOT.jar that was pointed out to me. Initially I noticed that the library failed to save the X-APPIAN-CSRF-TOKEN automatically in all call headers and I had to manually insert the value ${COOKIE___appianCsrfToken}. Subsequently the test went on overcoming the initial errors due to the failure to valorise the token indicated above but now it has stopped me at this error (APNX-1-4105-004) which I cannot understand. Can anyone help me figure out what's wrong with the call?

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)

I have a requirement of creating a decision which take input of a user type  how to achieve this? basically we are comparing user from the record.

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 )

What are procedures in data base

Hi Champ, I am using "<w:br/>" in my expression to have next line when generating my docx file from docx template. It's working fine there; but the same is not working when it's converting to PDF. I have another issue while generating the checxbox in PDF. It's rendering fine in Docx ; but the same is not working in PDF.  I am using pdf from docx plugin for the same. Can someone help me on that. Regards, Ghanashyam

I have two values consider type is CDT: local!oldData: {customer: "oldCustomer",location:"Hyd",supplier: "ABC"},local!updatedData: {customer: "newCustomer",location: "Hyd",supplier: "DEF"}I want to give response only the updated values like follows:fieldName: customeroldValue: oldCustomer,newValue: newCustomer,fieldName: supplier,oldValue: ABC,newValue: DEFCan anyone please help me to build logic for it.

Hi, I am trying to create new document channel in IDP on my client environment. After submitting the name for the new document channel, I am supposed to see 4 groups in Application designers which starts with the same name as that of the new channel. These groups are to be added to the IDP application, but these are not getting created.  I would like to know whether this is an environment issue or some configuration which has not been enabled as it is a new environment.  Regards, Deepak Devarajan

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) 

Hi team, Is there a way we can get user level logged in information. Eg: User1 logged in 5 AM EST and worked on 2 Application. Spent 2 hours on App 1 and 1 hour on App2.