New to Appian

I'm currently working on Step #5 of the "Build an Application (Step-by-Step Acme Auto)" guide. When attempting to configure the data source, there are no database tables available to select.   Additionally, I noticed that in the Acme Auto solution application, when I select the Vehicle record type, a banner appears at the top stating: "The data source cannot be reached or its configuration is invalid." I'm not sure if this is related to the issue, but I wanted to mention it in case it helps with troubleshooting. Any assistance you can provide would be greatly appreciated. Thank you!

Hello, I'm currently trying to use the import excel to database smart service within my process model and it's completing but not updating my data store entity.Process model:Start -> User form -> Import Excel to DB smart service -> EndThe file that I input in the form is an excel file and gets saved, and I have also configured the smart service so that the data source is a constant that contains the text which is my datasource: "jdbc/{name}". Table name: {SQL database table name}", excel file: Process variable which is stored excel document. After configuring all of these as followed by a youtube video that showcased this smart service, the data is not saving.I made sure that my column headers(A1,B1,C1) are exactly as stated within my CDT and matches the data type.How would I fix this/do this differently?

I have main data store entity that comes from CDT, in this CDT has 2 related CDT's. I am currently trying to delete from main data store entity to then have impacts on the related ones. When I made a process model that takes user input that then results in "delete from data store entities" node to delete, it was working for a few unique identifiers before not working anymore. It has ConstraintViolation as the error that it's giving. I am just trying to clear all of the data that are within my DSE's but keep the structure there.

a!localVariables( local!bookinfo: if( a!isNotNullOrEmpty( ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS_books_issue.fields.{550c5ea8-8a07-4a21-9693-209c159c6319}bookId'] ), a!queryRecordType( recordType: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK', fields: { 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{92b7d831-6d1e-4319-941c-66d2c1b49a9f}author', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{39d871be-ff6b-43bc-8200-4f5764212db4}availableCopies', 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.relationships.{23c62a5c-04db-4f30-89f0-4ccc4bb61a47}lmsGenre.fields.{d2da18ac-f795-482a-99d8-914552162ac1}value' }, filters: a!queryFilter( field: 'recordType!{767ebc5c-7e43-47d6-926e-02e87bfe4826}LMS_BOOK.fields.{8a72e153-4658-455c-a313-dc3d895c5ed3}bookId', operator: "=", value: ri!Lms_issuebook['recordType!{01e3b0e9-0572-442f-afd0-5278d2e5255e}LMS

Im getting the error when writing to data store:  ... " with identifier value `1007` does not exist  " . This is the value of my primary key I'm trying to insert into the data store. I already have the primary key from user input and I'm trying to write all of the info into an empty data store. (I would share screenshot but it's work information). This is occurring within my process model when I am using the write to data store smart service.  Why is this happening?

I am extremely new to Appian and looking for some answers. I have searched the forums to no avail. I have created a Site with multiple pages in it, one of them being a Contact Us page. On the Contact Us page, I have been trying to apply the expression link: a!safelink in an attempt to generate emails using our default email server (Outlook) once a person clicks the "Company Team Email" verbiage. Is this something that Appian is capable of doing?  This is my entire expression code: a!headerContentLayout(   header: {     a!cardLayout(       contents: {         a!richTextDisplayField(           labelPosition: "COLLAPSED",           value: {             a!richTextIcon(             &n

  a!gridLayout( labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Reference Number"), a!gridLayoutHeaderCell(label: "SiteID"), a!gridLayoutHeaderCell(label: "Activity"), a!gridLayoutHeaderCell(label: "Structure Type"), a!flatten(a!forEach( items: local!TaskParagraphCDT.TaskName, expression: { /*a!gridLayoutHeaderCell(label: fv!item & " Status"),*/ a!gridLayoutHeaderCell(label: fv!item), } )), a!gridLayoutHeaderCell(label: "Rule"), }, columnConfigs: {

Hello - While going through the online Developer course, "Design Record Types: Model and Configure Your Data", I completed the course and survey, assuming I could go back into the activity.  However, now I am unable to view the activity, which will make the future steps unavailable to me.  Can someone please point me to a PDF of this step so I can complete it? Thanks in advance,  RaviG

Hey Everybody, I am fairly new to Appian. Since yesterday, I haven't been able to access the community edition. All I can see is  "This site is temporarily unavailable due to maintenance" But the status of my country on their status page shows "Online". Is it just the case with me or for anyone else too?

Hi Team, I want to export more than 50 columns. Created a process to generate two excel and merge them Case 1: If using to new doc in both smart services. The combined doc is not started from specified cell. It starts from last data of first doc. E.g If first excel data ends at AV81 and other sheet starts from AW82, actually it should start from AW1. Case 2: If I am updating the first doc then the data of 1st doc is not reflecting and only 2nd excel document data is reflected Please let me know how to fix this. Thanks

Is there a discord channel or something similar where I can ask questions in real time? I can't find anything that I need in the documentation and I really can't believe that I'm the first person to be asking some of these questions as to why Appian doesn't do certain things out of the box considering it is supposed to be a "low code" solution.

I have used an multiple dropdown box here and whenever i try to select more than 1 option from the multiple dropdown list it is showing this error. Can anyone please guide me through this issue kindly.Thanks and Regards.

In a process model activity chaining is added some tasks are executing some tasks are breaking what could be the reason?

Can anyone help me with why iam getting this error when iam try to map a new field in the record table. Iam new to appian.

So i want to create an site and add an Interface as a page in it but it should be read only and i should have fields but the data in those fields must be coming from a record table.

Hello, I am currently taking the appian developer course and it wnats me to access the operations console from the build view waffle menu on appian designer, but as soon as I select this I am greeted with the following message:Error Evaluating UI Expression Expression evaluation error [evaluation ID = UIYZI] : java.lang.RuntimeException: Retrieving resource failed, status code: 500Any fixes to this? Thanks for any help!

Hi Appian Community, Iam new to appian and iam still struggling at a lot of things due to my limited approach. I have recently started working on a POC which is a little bit complicated due to which iam facing a lot of blockers. It would be great if anyone is willing to guide me a little bit on how to resolve my blockers and help me complete my POC. You can just help me in your free time or how little you can. Thankyou.

Hi, I need to create JWT token, for this installed JWT Tools Plugin, createtoken() function is pasking for externalSystemKey as param, I don't know how and where to configure it, and if it dependent on other 3rd party integration, what to configure there and how it will handshake with apian to test? Kindly guide us on this. Thanks,

I have created an email node. The recipient is configured as =toemailrecipient(cons!IAT_PURGING_NOTIF). The node executed successfully however no email is received. Can someone please advise what is wrong here. The constant is setup as type - Email address & Array having multiple recipient values.

if "Data type" and "Data Store" are not showing in our environment in Appian Designer,here are the possible reasons and how to fix them.

Hi everyone, we are currently evaluating different approaches to automate our tests. We're aware of the tools officially recommended by Appian (Appian Selenium API, FitNesse for Appian, and Cucumber for Appian), but we’re interested in knowing if there are alternative solutions.

I'm currently preparing for the Certified Developer Exam having no prior experience with Appian. I see other threads mention it is best to use Appian for a few months first, but my company encourages pursuing this exam (and the Senior developer certificate) before employment begins. I am completing the associated course (inculding all optional and practice content) but others have noted that this may be insufficient for the difficulty of the exam. Even the practice test indicates that the real exam will be more difficult. Does anyone have an reccomendation for how else to prepare or links to more in-depth practice resources?

the pickerFieldCustom field is replacing the user selected data to its identifier value , please suggest how to solve this.  my datasubset is as below : a!dataSubset( data:a!flatten(local!output.data), identifiers: a!flatten(local!output.identifiers) )  

Hi, I am using below code in my interface where I am using pickerFieldCustom. Also, I am sharing my expression rule. The issue which I am facing: After search with a certain text, I am able to get the result into the picker control, but it is disappearing upon the selection.  a!localVariables( local!pickedName, { a!pickerFieldCustom( label: "Name", maxSelections: 1, suggestFunction: rule!TestExpression(search: _), selectedLabels: local!pickedName, value: local!pickedName, saveInto: a!save(local!pickedName, union(save!value, save!value)) ) }) ------------------ a!localVariables( local!data: a!queryEntity( entity: cons!Employee, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "name", operator: "includes", value: ri!search ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: - 1) ), fetchTotalCount: false ).data, a!dataSubset(data: index(loc

Stupid question: there are "learning paths". After I finish one time all the materials/records/etc on one learning path I would like to start again so that I can do a "learning path" multiple times. Is it possible to reset a "learning path"? Thank you.