TeamDesk Blog

TeamDesk crew on data management, online databases, behind-the-scene info, and other cool data-related stuff.

RecordSet columns to work with detail records

Copying master record together with details was a non-trivial task. Four months ago we outlined 9-step solution that involves creating lookups and formulas and summaries and multi-record buttons and change triggers. And quietly worked on much simpler solution. Today TeamDesk proudly presents RecordSet columns and couple of extensions to Create and Update workflow actions to…

Copy and paste setup forms

Have you ever encountered situation when you are working on the development branch and yet have to add some stuff into production database? In order to keep changes in production database you have to either drop the branch or carefully copy and paste object settings from production to branch, property by property. No longer. TeamDesk…

Copy and paste keyboard buttons

Link a QR code scanner to your database

Let’s consider an example on how to link a QR code scanner to a database. Say you’ve built the “QR Code Scanner” application. The main idea of this database is that users can scan QR codes via a mobile device and then search database tables for records containing QR codes. Assume that your database keeps…

QR Code Scanner

Mobile actions’ icons to add visual appeal

As we promised, we’ll continue to add icons to various TeamDesk areas. This time we are adding mobile actions’ icons. Mobile Device Create/Update actions are now extended with a pair of icon and color properties. Icon, obviously allows you to set an icon for an action, while color is intended to override default “table color”…

Mobile actions' icons

TeamDesk connector for Power BI revisited

Last summer we announced the availability of TeamDesk connector for Power BI Desktop. This was a beta technology – in order to use it you needed to download connector code, place it in some folder and turn on some options Power BI. No longer. TeamDesk connector for Power BI is now certified by Microsoft and…

Icons for buttons and documents

Christmas is coming, trees are decorated, lights are blinking, and it’s time add some décor to your database. Today, we’ve added an ability to select icons for custom buttons and documents in TeamDesk. You have a choice of 900+ icons covering various subjects – actions, brands, file types, symbols, animals and a lot more. Search…

Generate Related Details in specified date range

It’s obvious that related details can be added to master record one by one. But there can be cases, when a predefined set of details should be added. Moreover, you can know in advance not only the data inserted into these newly created details, but also the number of records that should be generated as…

Generate Details Records

Generate Copies of Master and Copy Master Details

If your online database includes related tables, you may need to copy a Master record and copy master Details listed in the related details views . To simplify this process, the custom buttons with the Navigate actions can be adjusted. Let’s consider the Project Management database, where each project record is related to many Stages…

Copy Maste & Details

Deletion of Master and Details records in your Online Database

Almost each online database comprises reference columns participating in relations. As you already know One-to- Many relation consists of the Master table and the Details table. One Master record can be related to many Details records, while each Detail can be related to one Master only. There are many questions about automatic deletion of Details…

Online Database