Table of Content
Still need help?
Request support
Request Support
HELP
 / 
 / 
Data Processing Blocks
 / 

Get Data from Other App

This article explains the Get Data from Other App block that can be used to design an app.

Get Data from Other App

Help video


Use Cases

  1. Fetching data from a master app in the Clappia's Workplace
  2. Selecting and fetching from an employee/people/project master
  3. Checking live inventory status
  4. Creating a dynamic dropdown whose dropdown values keep increasing

Editing the Block

Click on the block and start editing on the panel that appears on the right side.

Get Data from Other App

Label

This is what appears as the label for the dropdown that shows the list of the items from the master app. Usually people provide labels like "Select the customer/project/item".

Get Data from Other App

Data Source App

Next step is to select the app from which the data will be fetched. You should get a dropdown of all the apps that are there in your Workplace. If you don't see anything then probably this is your first app. In such a case, you should create a master app first.

Get Data from Other App
Get Data from Other App
Get Data from Other App

Once you select your Data source app, additional fields will appear on the right panel for you to configure.

Selection Fields

These are the fields that you need to show to the end users so that they can identify the item to be selected. For example, the app designer is setting Customer's Id and Customer's Name as selection field.

Get Data from Other App

As an example, if there are the following entries in Customer Master -

  • Customer Id = CLAP505, Customer's Name = Amika
  • Customer Id = CLAP506, Customer's Name = Misha
  • Customer Id = CLAP601, Customer's Name = Zenia

Now while making a submission, if the user types "CLAP50", the first two entries will match the search text. If the user types "CLAP505", only the first entry will show up.

Get Data from Other App
Get Data from Other App


Pulled fields based on selection

Here you select the items that will be pulled against the main selection made by the user. For example, if the user selects a Customer from the dropdown, all the details selected below will be fetched against that customer.

Get Data from Other App
Get Data from Other App


Status Filter

Clappia allows admins to set status for each submission. It can be configured in the app designer configuration tab. You can set the status of each item in the master app and then fetch only those items that have a particular status. For example, you can set the statuses as Active/Inactive customer or Available/Unavailable (for inventory master).

This is optional and you should configure the status in the master app first to configure this.

Get Data from Other App

Get Data from Other App

Sort Fetched Data By

The fetched data that shows while the user types in to search can be sorted according to the fields from the Master app.

Get Data from Other App

Once you click on Add column, select the field the data is to be sorted by. There can be multiple columns added.

Get Data from Other App

Using the above example; the fetched data is sorted by status in the Master app (inactive customer, active customer).

Get Data from Other App
Get Data from Other App
Get Data from Other App


Get Data from Other App

Required

Enable this option to tell the user that it is a compulsory field.

Allow users to see all records in the source app

Enable this option to allow the users to be able to pull all the fields from the source app. If not, only the fields that have permission will be allowed to pull.

Example: Say there are 2 apps, App1 being the Master app and App2 is where you use the Get Data from other Apps block to fetch data from App1. If a user has access to only App2 and not App1, then by keeping the ‘Allow users to see all records in the source app’ option enabled in App2 in the Get Data from other Apps block, users will be able to search records from the master app even though they do not have access to that app. This ensures that they are able to use certain information from the Master app only and not have direct access to that app.


No submission message

A custom message to show to the admin that there are no submissions found from the data the user types in to search.


Advanced Options

Minimum characters before starting search

The minimum number of characters the user should enter in the field to pull up the search list.

Get Data from Other App
Get Data from Other App
Get Data from Other App

Maximum results to display

Give the maximum number of search results to be displayed in the dropdown after a user enters into the field.

Display this field if

Use this option if you want to show or hide a field under certain conditions. It accepts the standard Clappia Formulae, similar to conditional sections.

Get Data from Other App

Allow value to be changed after initial submission

Enable this to allow the field value to be changed after submission


Allow fields to be added inside pulled copyable sections

Example: Pulling information from a ‘Leads’ App to another app called ‘Updates’ App.

App1 - Leads App

Get Data from Other App

App 2 - Updates App

The Get data from other Apps is configured as the following:

Label: Get data from Leads App

Data Source App: Leads

Selection Fields: ID

Pulled fields: Customer Name, Customer Email, Phone Number, Stage

Get Data from Other App

As the pulled fields are a copyable section from the 1st app, the fields will show up as a separate section.

In the pulled section, you can add additional fields to capture data apart from the pulled fields.

Get Data from Other App

The added fields will be replicated in every copied section in App Home when data is pulled from the 1st app.

Get Data from Other App

Dynamic Filtering within Apps

Dynamic Filter

This is a feature in GET DATA from other apps which is used to filter the fields and pull the data according to specific requirements.

Add Filter

Click on this option to add a dynamic filter. It opens up a menu to select the filtering items.

Get Data from Other App

Let us understand the working of dynamic filter more clearly with an example

Example: Ticketing Management Solution

Dynamic filtering will help to view only those tickets that are assigned to the support employee. One employee can view, access or change the status of the tickets which are assigned to them and not of others.

There are 2 apps:

  1. Assigning Tickets - An app to assign tickets to the employee
  2. Status Update - An app to check the status of tickets specifically assigned to an employee

This is a list of tickets assigned to employees in the Assigning Tickets app.

Consider an employee ID and the tickets assigned only for that employee.

Employee ID - CLP0008

Ticket Number - sup_clp14 and sup_clp3

Get Data from Other App

Now, check the status of tickets in the Status Update on Tickets app.

When you type the employee name, the respective employee details are fetched.

Next when you want to select tickets assigned to that employee it shows the list of all tickets.

Get Data from Other App

This is where the Dynamic Filter is useful.

Edit the app and click on the Ticket Number block which is the ‘Get Data from Other Apps’ block. 

Get Data from Other App



Edit the Dynamic Filter from the right panel
Select a field from Assigning Tickets

Assigning Tickets is the app selected to pull fields from.

Employee ID is selected - this implies that ticket numbers assigned to the employee ID will be displayed.

Select a field from the current app

Status update on tickets is the current app.

Employee ID is selected - this implies that the employee ID of the current app will match the employee ID of the app from which the data is pulled from. In this example it is the Assigning Tickets app.

Click on save and now let’s search for the tickets assigned to the employee again.

Get Data from Other App

Due to the dynamic filter that was added, now only the tickets which are assigned to that particular employee will be shown.

FAQs
Try our free plan
It will answer many more questions within just 15 minutes.