Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  •   Snippets

  • Change the Time Field to a Dropdown

  • Trigger Refresh When Integromat Completes

  • Converting an Index Match Setup to Tadabase

  • Set Link Button to Open in a New Tab

  • How to Hide Component Based on “No Records” in Table

  • Change Link Button Color CSS for Active/Hover

  • JS to Show/Hide Components Depending on Multiple Data Fields

  • Google Charts Integration

  • Change the Background Color of 2 Cards if the Numbers Match

  • Save IP Address of Logged in User to the Record

  • Add Logged in User's IP Address to Form

  • Enlarge Thumbnail Images

  • Link Button Pop-up

  • Field Title Language - Based on Logged in Users' Language

  • Filter Tab - Background Color

  • IF 2 Card Component Value's Match - Change Background Colors to Match

  • Show Progress Based on Field Value

  • Export Multiple Tables in a Single File

  • Specify Size of Image Model Popup

  • Refresh Entire Page after Form is Submitted

  • Change Labels Language

  • Run Basic Math in Real Time on a Form

  • Set your Data Table to Auto-Refresh

  • CSS Color Gradient

  • Embed Your App in a Webpage Without iFrame or Embed Code

  • CSS for Table Component Title Text

  • Vertical Text in Columns and Fields

  • Mobile Menu Logo - When Menu is Closed

  • View Record Details on Parent Page

  • Show loading GIF while Action Links Run

  • Show columns based on the Users Role

  • Change Checkbox Size

  • Quick and Easy PDF Preview

  • Card Component - Display Sales - Today vs. Yesterday

  • A Multi-Company Project Management Tool

  • Multi-Item Select for Form Input

  • Set "Inputmode" on a Currency Field to a Decimal

  • Remove Link from Signature Fields in Details Components

  • Change Sub Menu Background Color and Text on Hover

  • Change Image Thumbnail Sizes

  • Change the Default Record Count Text

  • Copy Text on Click

  • Delete Connected Child Records Along with the Parent Record

  • Limit Text- Show more

  • Pause a Redirect of the Form

  • Display Addresses in a Single Line in Table Components

  • CSS Option for Connection Fields in a Form Component.

  • Generate Static Map Image

  • Delete Link on Child Page

  • Convert your Calendar's Language

  • Include “Add New” Text Button When Using "table-style-2"

  • Keep Columns Horizontally side by side on Mobile Devices

  • Using Javascript to Manipulate Records Without Tadabase REST API

  • Hide Columns Based on User Role

  • Add Speech Recognition to Your Form

  • Create an Anchor Link Button

  • Refresh all Tables When Form is Submitted

  • Customize Pagination Colors

  • Keep Active Menu Item Highlighted

  • Remove Background Color on Menu Item Hover and Focus

  • Hide Submit Button Unless all Radio Options are “Yes”

  • Set a date based on a Quarter and Year

  • Hover text - Buttons

  • How to use (space) delimiters in an input-field for numbers in text-field

  • Back Button

  • Customize the Form Submission Dialog Box.

  • Change Theme Button Colors

  • Fire Confetti🎉 When Submitting a Form

  • How to Add Checkboxes to Your Table and Add Logic to Them!

  • Photos in Gallery Display

  • Use Buttons to Search a Date Within a Range

  • Link highlighting Without Underline

  • Hide the Refresh Box and Records Display in a Table.

  • Move Form “Save” Button to Top of Form Page

  • Card Component Enhancement

  • Apply CSS class to PDF Print/Download Button

  • How to Hide Arrows from Input Number

  • Only Show Component if it’s the First Week of the Month

  • Hide Components when there are no Records

  • Multi-Step Background and Number/Icon Text Color

  • Use a Custom Icon in Card

  • Left Align Radio Buttons

  • Table Thumbnail Image Percentage Related Sizing

  • How to Round Filter Tabs

  • Table Style 2

  • Table Style 3

  • Table Style 4

  • Table Style 5

  • Details Style 1

  • Form Style One

  • Form Style 2

  • Form Style 3

  • Form Style Three

  • Form Style 4

  • Form Style 5

  • Animated Save Button - Grab Attention

  • Trigger Submit Button of the Other Form

  • Mask Sensitive Form Values

  • Capitalize First Letter in Fields

  • Change Header Size - Resource Component

  • Wrap Navigation Tabs for Mobile

  • Custom Print

  • Run JavaScript from an HTML Button Onclick Event

  • Record Validation for a Specific Word.

  • Remove "Years" from a Date Formatted as Age

  • Create a Record Entry Alternative to Using a QR Code Scan

  • JSChart Custom Component

  • Concatenate Multi-Select Connections

  • Add Freshdesk for Certain Roles or Pages

  • Hide Specific Part of a Menu Based on Logged in User Status/Role

  • Simple Scraper Setup

  • Validation rule - Validate against a connected field using a pipe

  • Change Button Based on Record Value

  • Hide Menu Links Based on Roles, Status or Logged in Users

  • How to add Delete Functionality Inside a Modal

  • Add a 360 tour to a Page.

  • Create X Amount of Connected Records Based on a Number Field

  • Pre Populate & Disable Date Range

  • Covert Action button to Text when Pushed

  • Access Data Table Records from JS

  • Concat Multiple Checkboxes While Filtering Duplicates

  • Read Receipts for When User Views the Details Page.

  • Number Count in Badge With Extra Filters

  • How to Customize the Language of your Tadabase Charts

  • Save records to Google in batches

  • Override Action Link with Confirmation Popup

  • How to Add Custom Themes to your Tadabase Charts

Categories
Snippets
Concatenate Multi-Sele...

Concatenate Multi-Select Connections

This is a solution if you have many tables that are children of the other and want to rollup multi-select connections. 

Step 1

Download the Custom JavaScript pipe from our pipe library. 

 

Step 2

Begin the parameter setup for your pipe, shown in the image below.

Find these three values for the parameter values of your pipe. 

1. Parent Record ID

2. Child Table ID

3.  Connection Field Slug

 

 

Step 3

Add the following code to the request tab of the pipe and update the API portion with your API values, as seen in the image below. Additionally, update the portion "var One_To_Many_Field = ' ' this will be the same field slug we found in step 2.
var Tadabase_Api_Id = 'APP_ID';
var Tadabase_Api_Key = 'API_KEY';
var Tadabase_Api_Secret = 'API_SECRET';
var Parent_Record_Id = '{parentRecordId}';
var Child_Table_Id = '{childTableId}';
var Connection_From_Child_To_Parent = '{fieldSlug}';
var One_To_Many_Field = 'field_ID_val';

Array.prototype.contains = function(v) {
    for (var i = 0; i < this.length; i++) {
        if (this[i] === v) return true;
    }
    return false;
};
Array.prototype.unique = function() {
    var arr = [];
    for (var i = 0; i < this.length; i++) {
        if (!arr.contains(this[i])) {
            arr.push(this[i]);
        }
    }
    return arr;
}
var Api_Url = 'https://api.tadabase.io/api/v1/data-tables';
var Request_Var = {
    'method': 'GET',
    'headers': {
        "X-Tadabase-App-id": Tadabase_Api_Id,
        "X-Tadabase-App-Key": Tadabase_Api_Key,
        "X-Tadabase-App-Secret": Tadabase_Api_Secret
    }
};

function getChildRecords() {
    var response = UrlFetchApp.fetch(Api_Url + "/" + Child_Table_Id + "/records/?filters[items][0][field_id]=" + Connection_From_Child_To_Parent + "&filters[items][0][operator]=is&filters[items][0][val]=" + Parent_Record_Id, Request_Var);
    return JSON.parse(response);
}
var childItems = getChildRecords();
var listOfJoinValues = [];
for (var i = 0; i < childItems.items.length; i++) {
    var element = childItems.items[i];
    for (var j in element[One_To_Many_Field]) {
        var item = element[One_To_Many_Field][j];
        listOfJoinValues.push(item.val)
    }
}
var uniques = listOfJoinValues.unique();
uniques.toString().replace(/,,/g, ",").replace(/,/g, ", ");

 

Step 4

Set up a table rule in your parent table with the setting shown in the image below. 

 

 

Step 5

On the page builder side. Add a form rule to update the connected parent table in the form of the child table. 

 

 

Original Community Post:

Concatenating (merging) the multi-select results of a child table into the parent - Community Discussions / How to Do I - Tadabase Community

How did we do ?

Previous Article
JSChart Custom Component
Next Article
Add Freshdesk for Certain Roles or Pages
Article Navigation
  • Step 1
  • Download the Custom JavaScript pipe from our pipe library.
  • Step 2
  • Begin the parameter setup for your pipe, shown in the image below.
  • Find these three values for the parameter values of your pipe.
  • Step 3
  • Add the following code to the request tab of the pipe and update the API portion with your API value
  • Step 4
  • Set up a table rule in your parent table with the setting shown in the image below.
  • Step 5
  • On the page builder side. Add a form rule to update the connected parent table in the form of the ch
  • Original Community Post:
  • Back to top
    API
    100% Operational
    Apps
    100% Operational
    Builder
    100% Operational
    Overall Status
    100% Operational