New to Appian

user(loggedInUser(),"phoneMobile")& user(loggedInUser(),"phoneHome")&user(loggedInUser(),"phoneOffice") not give any value. why?

Hi All, I have a editable grid .when I click on add button  one row created .Now, I want how to show the add button when the user uploaded file in it and if the user not uploaded the file then add button not show for multiple rows? Thanks

Hi, I have a requirement where user uploads the document(at this stage we have the temporary document) in the editable grid. Beside of the document component, we should display the document name in the text field. If user wants they can edit the document name. I just want to know whether we can do this or not. If so, is there any tweaks to achieve this requirement?  Thanks in advance,

Hi Team, Is there a direct to execute the SQL scripts directly in Appian instead of executing in DB?

a!currency() what is the role of:-- isocode:"USD" ,"EUR format: CODE,LOCALE,SYMBOL how they related to each other. pls explain me not able to understand from  appian docs

a!gridField( data:index(local!datasubset,"data",{}), columns:{ a!gridColumn( value:apply(concat(_,"-",_),merge(index(fv!row,"id",{}),index(fv!row,"exhibit_id",{})) ) ) } ) Error comes:---- at merge() function  only  list are allowed .how i change fv!row to list  

I have a requirement to log user activity on a page on page load. What would be the best way to do so. As we don't have any feature to invoke smart services on page load, not sure how to do that.

Hi Everyone, I am getting an error in our site page which says "The requested task is not Available"(The task may have been deleted or completed by another assignee) and the site page is configured in a process start form This is very random and I am thinking this could be idle session timeout but we recently migrated our application from on-prem to cloud and we never got this error in on-prem. Please help me understand this. Thanks

Hi Everyone, I need to read the name of the attachment attached in the email which is captured by the process model through receive message smart service. Can any one please help me out how to read the name of the attachment. Many Thanks!

Hi Everyone , Which link component can we use for this link(Target) which not a part of any record "gileadmedaffairsdev.appiancloud.com/.../iQBdsM9sWBbQJu_AcauYDn3QmjvXg6b8LUgndmI4vkmGkMvHAg" Where "060be4f3-2634-4745-98fe-88fbb6fcf834" this part(attribute) will change everytime when we open the page .Thats why we are not able to use the above target as it is as URI in safe link component. Is there any solution where we can generate link for the above target Many thanks

Hi Experts, I Need your help. There is a use case where I am designing an Interface from where the user uploads a CSV file and I have to convert that CSV file data to CDT. And once this has been converted into CDT I have to show that data in a read-only grid on the Interface. Thank you in advance for your support! Below is the overview of the data of my file:

Hi, I want to export the data in excel on page load using ExportDataStoreEntityToExcel. how we can achieve this? I am successfully able to export the data on saveinto but here want to export on page load. Below is the code which i am trying. Code is not throwing any error but seems not calling this export service also. local!exportDocId: a!exportDataStoreEntityToExcel( entity: cons!SCE_SITS_VW_INCIDENTS, documentName: "test Report", sheetName: "Test Report", saveInFolder: cons!TEST_DOCUMENT_FOLDER, onSuccess: a!save( local!exportlink, fv!newDocument ), /*This displays an error if there is an issue executing the save*/ onError: a!save( local!errorMessage, "Error Exporting File to Excel" ) ),

A feature is being deployed to the test environment.In which environment is unit testing performed for the feature?

Hi Everyone, With the update in the appian version the record object created in previous versions will be updated and will have new features? Thanks!

a!localVariables( local!publication: cast( typeof( 'type!{urn:com:appian:types:ISR}ISR_StudyDetail'() ),{} ), a!boxLayout( label: "Publicaton Plan", contents: { a!gridLayout( totalCount: count(local!publication), headerCells: { a!gridLayoutHeaderCell(label: "Publication Type" ), a!gridLayoutHeaderCell(label: "Publication Name" ), a!gridLayoutHeaderCell(label: "Year Estimate" ), /* For the "Remove" column */ a!gridLayoutHeaderCell(label: "" ) }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "DISTRIBUTE", weight:3 ), a!gridLayoutColumnConfig(width: "ICON") }, rows: a!forEach( items: local!publication, expression: a!gridRowLayout( contents: { a!radioButtonField(

Hi Everyone, Is there a way to find out where the stored procedure created in database is being called in which process model through execute proc smart service? Thank you!

Hi Team, Can we extract process instance logs on Appian. Eg: For a process instance, we see the details of the process in the process history tab. Can we extract that?

in my app I have a Loans table and the client wants to be able to add new Loan Balances to the loan with date, balance, & notes fields. The best way I know to do this would be to create a Balances table related to the Loans table so that each Loan could have many Balances. What I am wondering is if there is a way to set up a Balance field on on the parent Loans table that will always display the most recent balance entered into the Balance table? Short of that i know I can show a record list of the balances on the interface with add buttons so they can add new balances that way, but they also want to be able to report of the current balances and to use the child table would mean having to pull several pieces of information from the parent Loan table down to the child Balance table which I think would be much more difficult to do.

Hi All, Can we insert multiple drop down within another multiple drop down.If yes please provide me information.

On the creation interface for a table there are a few dropdowns, so on the update interface for the same record, I need to have the same dropdowns available in case a change needs to be made, but how do I make the default value be what was selected during the creation process? I believe it has something to do with the Selected Value input on the dropdown component configuration, On the creation interface the local variable for that list of choices goes into the Selected Value input. I tried putting a "a!defaultvalue" formula there but then when you make a change, it doesn't hold the new selection. Also, as it may make a difference how it is set up, these dropdown's selections are drawn from related tables, not hard coded in the expression.

When creating records for a Loans table, I have 6 dropdowns where the choices are fed via related tables. The dropdowns work fine, however, after the record is saved and viewing the summary view for that record, the selections in those dropdown fields are not showing, only getting a "-". The following is the code used in the display value portion for the summary view of the dropdown fields. This works fine on other tables I have done and is the same on the community Acme Auto app but I can't figure out what is missing. a!defaultValue( if( isnull( ri!record['recordType!{6e4edeaf-030d-4fc2-917a-ab20f1027418}DC Loans.fields.{6c4213e9-38dd-4430-ac99-141cf70a9ebb}loanSourceId'] ), "â`“", index( a!queryRecordType( recordType: 'recordType!{beec71c0-c52d-4b00-8311-cbcf34fcd0c7}DC LoanSources', fields: 'recordType!{beec71c0-c52d-4b00-8311-cbcf34fcd0c7}DC LoanSources.fields.{7413e7ce-3dc8-4513-bf9a-13a6376dfb11}loanSourceName',

Hi Everyone, I am using Import excel to DB smart service to import excel data in Appian. And my requirement if date column in excel is in any format then it should be changed to "dd/mm/yyyy" before inserting into DB. I dont see any option to format the dates in smart service. Can anyone please help me out? Many Thanks!

Hi,I'm new to appian. I created a simple employee onboarding form (1 wrapper interface contains 3 sub interfaces(personal details,address,bank).when i click submit all 3 tables in DB needs to be updated uing write to multi data store entity in interfaces itself(not using process models).the problem i'm facing is once employee details submitted then we get primary key(emp id) this needs to updated in other 2 tables(address,bank) parallelly. i dont know how to configure the on success parameter for doing this.

I am getting the following error when using the record action button created to create a child record that pulls the parent record ID into the child record to connect them: An Error Has Occurred Could not cast from DC Loans to DC PrincipalLoanBalance. Details: DC Loans cannot be cast to DC PrincipalLoanBalance I have the button and process model just like I set up a few others in another app that work fine, which I followed the example on the community app Acme Auto Solutions to get those right. Not sure what is causing this error, thoughts?

***New to Appian and still learning*** I am receiving the following error when testing a create interface for a record type and select an option from the first dropdown that I configured to utilize another table for the choices. I followed the same steps as another interface that works perfectly but this one isn't.: Expression evaluation error [evaluation ID = ddb37:dcfb0] in rule 'dc_createloans' at function a!dropdownField [line 12]: An error occurred while executing a save: Expression evaluation error: Field with [identifier=ff748bfd-bb00-441d-a6b3-60434c5f439e] not found on the Record Type I get the just of what the error is saying, but when studying the Record Type, I don't see any field that could be missing. I'm not sure how you utilize the highlighted field identifier in the error message to figure out which field it is referring to. Below is the code from the create interface, please let me know what you see. It's probably going to be something stupid a