CREATING DATA ACTIONS

Preparing Actions on the Profile Screen

In this learning content, we will prepare actions together for the user profile screen, which is one of the screens in I have an idea web and mobile application. In the web application, we will provide the listing function according to the logged in user's e-mail address to create the Select action containing the information to be displayed on the user profile card.

In this learning content, we will prepare actions together for the user profile screen, which is one of the screens in the I Have an Idea web and mobile application.

Let's continue with the web application.

When we examine the user profile, we see a card structure with user information on the screen. In this card structure, there are the image, first and last name, department, and Title of the logged-in user. We will create a select action to show this information in the card structure.

In the rest of the screen, we see that there is a text field showing the number of ideas created by the users. A custom action is needed for this field.

Finally, we see that the ideas created by the user are listed on the screen. We will also create the Select Action that will provide this listing function.

Let's start creating these actions together.

Let's create the custom action on the screen, which enables the display of profile information and provides a listing function according to the username, that is, the e-mail address of the user logged in for the action.

  1. Open the Custom Actions panel on the left side and click on the + icon next to the Managed DB statement.
  2. Select Select Action from the drop-down menu.
  3. Name your action.
  4. Select the Personnel table through the Choose Source field.
  5. Click the link sign next to the Personnel table and create a relationship with the Department table.
  6. In addition to the fields that come by default using the Fields field, add the Id column from the Personnel table and name it PersonnelId in the Alias field.
  7. Then add Fullname, PersonnelImage, and Title fields from the personnel table.
  8. Then add the Id column from the Department table and name it as DepartmentID. Finally, select the DepartmentName column in the Field field.
  9. In the Filter field, select the Personnel table, then select the email column and leave the default from is equal to selected.
  10. Then click on the symbol picker on the far right and select Current Username in the Default category.
  11. Create the action by clicking on the Create button.

Now let's create the action that will be in the profile, which will give the number of ideas created by the user.

  1. Create a new Select Action using the Custom Actions panel.
  2. Name the action.
  3. Select the Idea table and associate it with the Personnel table.
  4. In the Fields field, select Id in the Field field and select the Count function.
  5. In the Alias field, name UserIdeaCount.
  6. Delete the default created Fields.
  7. Then select the Personnel table in the Filter field, then select the email column, and leave the default from is equal to selected.
  8. Click the Create button.

Next, let's create our action similar to the Select Action learning content to build the structure in GalleryView.

  1. Create and name a new Select Action.
  2. Select the Idea table through the Choose Source field.
  3. Click on the link icon next to the Idea table.
  4. From the screen that opens, select the Personnel table associated with the Idea table.
  5. Let's do the same for the IdeaCategory table this time.
  6. Open the Fields tab.

Let's proceed by adding to the default selections on the Fields tab.

  1. In the Idea table, add Id first, respectively. Make the IdeaID naming in the Alias field.
  2. Then select CreatedDate, IdeaHolder, IdeaImage, IdeaImage, and Ideatitle respectively.

Now let's proceed by adding the columns in the Personnel table.

  1. First, select the ID in the Personnel Table and give the PersonnelID nomenclature through the Alias field.
  2. Then select Fullname, PersonnelImage, and Title. Finally, add the ID in the Category table and name it as CategoryID via Alias.
  3. Then select the Personnel table in the Filter field, then select the email column, and leave the default incoming is equal to the selection selected.
  4. Then click on the symbol picker on the far right and select Current Username in the Default category.

Let's create a sorting structure to list the ideas created by the user on the profile screen from the last to the first.

  1. Now open the SortOrder tab, select the Idea table, select CreatedDate as a column, and select Descending.
  2. Complete the action creation process by clicking the Create button.

Thus, we have created the necessary actions for the profile screen of the logged-in user. We are waiting for you to create profile actions in the I Have an Idea mobile application by following a similar flow.

In this learning content, we will prepare actions together for the user profile screen, which is one of the screens in I have an idea web and mobile application. In the web application, we will provide the listing function according to the logged in user's e-mail address to create the Select action containing the information to be displayed on the user profile card.

In this learning content, we will prepare actions together for the user profile screen, which is one of the screens in the I Have an Idea web and mobile application.

Let's continue with the web application.

When we examine the user profile, we see a card structure with user information on the screen. In this card structure, there are the image, first and last name, department, and Title of the logged-in user. We will create a select action to show this information in the card structure.

In the rest of the screen, we see that there is a text field showing the number of ideas created by the users. A custom action is needed for this field.

Finally, we see that the ideas created by the user are listed on the screen. We will also create the Select Action that will provide this listing function.

Let's start creating these actions together.

Let's create the custom action on the screen, which enables the display of profile information and provides a listing function according to the username, that is, the e-mail address of the user logged in for the action.

  1. Open the Custom Actions panel on the left side and click on the + icon next to the Managed DB statement.
  2. Select Select Action from the drop-down menu.
  3. Name your action.
  4. Select the Personnel table through the Choose Source field.
  5. Click the link sign next to the Personnel table and create a relationship with the Department table.
  6. In addition to the fields that come by default using the Fields field, add the Id column from the Personnel table and name it PersonnelId in the Alias field.
  7. Then add Fullname, PersonnelImage, and Title fields from the personnel table.
  8. Then add the Id column from the Department table and name it as DepartmentID. Finally, select the DepartmentName column in the Field field.
  9. In the Filter field, select the Personnel table, then select the email column and leave the default from is equal to selected.
  10. Then click on the symbol picker on the far right and select Current Username in the Default category.
  11. Create the action by clicking on the Create button.

Now let's create the action that will be in the profile, which will give the number of ideas created by the user.

  1. Create a new Select Action using the Custom Actions panel.
  2. Name the action.
  3. Select the Idea table and associate it with the Personnel table.
  4. In the Fields field, select Id in the Field field and select the Count function.
  5. In the Alias field, name UserIdeaCount.
  6. Delete the default created Fields.
  7. Then select the Personnel table in the Filter field, then select the email column, and leave the default from is equal to selected.
  8. Click the Create button.

Next, let's create our action similar to the Select Action learning content to build the structure in GalleryView.

  1. Create and name a new Select Action.
  2. Select the Idea table through the Choose Source field.
  3. Click on the link icon next to the Idea table.
  4. From the screen that opens, select the Personnel table associated with the Idea table.
  5. Let's do the same for the IdeaCategory table this time.
  6. Open the Fields tab.

Let's proceed by adding to the default selections on the Fields tab.

  1. In the Idea table, add Id first, respectively. Make the IdeaID naming in the Alias field.
  2. Then select CreatedDate, IdeaHolder, IdeaImage, IdeaImage, and Ideatitle respectively.

Now let's proceed by adding the columns in the Personnel table.

  1. First, select the ID in the Personnel Table and give the PersonnelID nomenclature through the Alias field.
  2. Then select Fullname, PersonnelImage, and Title. Finally, add the ID in the Category table and name it as CategoryID via Alias.
  3. Then select the Personnel table in the Filter field, then select the email column, and leave the default incoming is equal to the selection selected.
  4. Then click on the symbol picker on the far right and select Current Username in the Default category.

Let's create a sorting structure to list the ideas created by the user on the profile screen from the last to the first.

  1. Now open the SortOrder tab, select the Idea table, select CreatedDate as a column, and select Descending.
  2. Complete the action creation process by clicking the Create button.

Thus, we have created the necessary actions for the profile screen of the logged-in user. We are waiting for you to create profile actions in the I Have an Idea mobile application by following a similar flow.

Files

Yardımcı kaynaklar

Glossary