Logo
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

  • Converting a phone field to Country Dropdown

  • Using DataTables to show external Data

  • Show multiple dates in a single calendar

Categories
Snippets
Converting an Index Ma...

Converting an Index Match Setup to Tadabase

How to convert an Index Match setup to Tadabase:
1.  If you’re working with just a few basic values, you can use an equation field with IF statements.

https://www.youtube.com/watch?v=B1LJ4bHRb4g

2. If it’s somewhat more complex, you can use some JavaScript Pipe:

6LNCapture.JPG

3.  If you need a true Index and Match you can turn your Google Spreadsheet into a standalone database and run a request against it in conjunction with a Pipe.

https://youtu.be/uHh04ixi0S0

Google App Script Code:

function doGet(e) {
  
  var INCOME=e.parameter.INCOME
  var RATE=e.parameter.RATE
  
  var response=findRow(INCOME, RATE)
  return ContentService.createTextOutput(JSON.stringify(response) ).setMimeType(ContentService.MimeType.JSON); 
}
function findRow(INCOME, RATE){
  const ss=SpreadsheetApp.getActiveSpreadsheet()
  const sheet=ss.getSheets()[0]
  const data=sheet.getDataRange().getValues()
  const header=data[0]
  var result=[]
  
  data.forEach(function(row){
    if(row[0]==INCOME) return result=row
  })
  
  var val1;
  for(var i=0; i<header.length; i++) {
    Logger.log(header[i]+ ' ' + RATE)
    if(header[i] == RATE) {
      val1=result[i]
      return;
    }
  }
  
  if (val1 == undefined) {
    for(var i=1; i<header.length-1; i++) {
      if (header[i] < RATE && header[i+1] > RATE) {
        if ( Math.abs(header[i]-RATE)  > Math.abs(header[i+1]-RATE) ) {
          val1 = result[i+1];
        } else {
          val1 = result[i];
        }
      }
    }
  }
  return (val1)
}
function toJson(header,values){
  var obj={}
  header.forEach(function(key,i){
    obj[key]=values[i]
  })
  
  return obj
}

Original Community Post:

https://community.tadabase.io/t/converting-an-index-match-setup-to-tadabase/2140/2

 

How did we do ?

Previous Article
Trigger Refresh When Integromat Completes
Next Article
Set Link Button to Open in a New Tab
Back to top
API
100% Operational
Apps
100% Operational
Builder
100% Operational
Overall Status
100% Operational