{"id":1055,"date":"2017-03-10T05:56:14","date_gmt":"2017-03-10T11:56:14","guid":{"rendered":"https:\/\/www.teamdesk.net\/blog\/?p=1055"},"modified":"2017-03-10T06:18:25","modified_gmt":"2017-03-10T12:18:25","slug":"database-creation-citizen-developers","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/","title":{"rendered":"Database creation steps that Citizen Developers can do"},"content":{"rendered":"

SaaS solutions<\/a> are the key trend in IT sphere. Many of the modern cloud-based applications are so intuitive that they don\u2019t even require any special technical knowledge, therefore a new type of users has appeared. These users are well-known as citizen developers. They are pretty technology-literated, so creation of a new business solution and sharing it with others is not a big challenge for them anymore.<\/p>\n

If citizen developers are looking for an online database software, there are many platforms to choose from, however not many of them are as well designed, flexible and intuitive as TeamDesk.<\/p>\n

Here are some important recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build a web-database on their own.<\/p>\n

Structure is a key point<\/h3>\n

TeamDesk support team often works with questions related to database creation, so we always recommend to start with a correct structure for your database. Unfortunately, some citizen developers are eager to adjust user access or produce reports even before the database structure is finalized. This makes database creation process more difficult and may require corrections.<\/p>\n

What the database structure is and why is it so important to finalize it before configuring user access level or setting up other database objects like triggers, notifications, documents etc.?<\/p>\n

Under the \u201cdatabase structure\u201d we mean tables and relations between tables. No need to remind you that each table is a data set, consisting of columns and rows. At the beginning of the database creation, the main task is to define the tables you need and the key columns for these tables, such as Customer ID column in the Contacts table or the Order Registered Number column in the Orders table. These columns are needed to relate tables correctly. So, first of all, you should create a correct database structure: tables, columns and relations.<\/p>\n

Sample Data<\/h3>\n

When a citizen developer can build a database structure on his\/her own \u2013 it\u2019s great. To simplify database creation process we recommend to start with the import<\/a> of CSV files or excel spreadsheets<\/a>. In case if it\u2019s not clear how to create an optimal data structure, a citizen developer should contact support team<\/a> or discuss his\/her business solution with experts<\/a>. If a citizen developer can provide a detailed database description \u2013 it\u2019s very useful, especially when all business process stages requiring a database usage are listed. Attaching working materials, such as spreadsheets with sample data or documents are advisable as they help to define column types and formulas quickly and easily.<\/p>\n

Make further adjustment<\/h3>\n

When the database structure is built, you can configure database objects like views<\/a>, documents, triggers, notifications, as well as another functionality. On this stage citizen developers may also contact<\/a> support specialists to receive some recommendations or instructions.<\/p>\n

Adjust user access and share the database<\/h3>\n

Finally, user access<\/a> must be adjusted. It should be done at the end, when the database is already created, so access to the database objects may be configured properly. Please don\u2019t forget that custom roles<\/a> should be created first and then a role-based access<\/a> should be adjusted. When everything is done, you can invite users<\/a> to your newly-created database solution, check how it works and make some improvements if needed.<\/p>\n

An online database creation is a fast, easy and exciting process when citizen developers follow these basic steps.<\/p>\n","protected":false},"excerpt":{"rendered":"

SaaS solutions are the key trend in IT sphere. Many of the modern cloud-based applications are so intuitive that they don\u2019t even require any special technical knowledge, therefore a new type of users has appeared. These users are well-known as citizen developers. They are pretty technology-literated, so creation of a new business solution and sharing […]<\/p>\n","protected":false},"author":3,"featured_media":1056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1055","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips-tricks"],"yoast_head":"\nDatabase creation steps that Citizen Developers can do<\/title>\n<meta name=\"description\" content=\"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database creation steps that Citizen Developers can do\" \/>\n<meta property=\"og:description\" content=\"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-10T11:56:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-03-10T12:18:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Mila\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mila\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/\"},\"author\":{\"name\":\"Mila\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"headline\":\"Database creation steps that Citizen Developers can do\",\"datePublished\":\"2017-03-10T11:56:14+00:00\",\"dateModified\":\"2017-03-10T12:18:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/\"},\"wordCount\":568,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/citizen-developers.jpg\",\"articleSection\":[\"Tips & Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/\",\"name\":\"Database creation steps that Citizen Developers can do\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/citizen-developers.jpg\",\"datePublished\":\"2017-03-10T11:56:14+00:00\",\"dateModified\":\"2017-03-10T12:18:25+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\"},\"description\":\"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/citizen-developers.jpg\",\"contentUrl\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/03\\\/citizen-developers.jpg\",\"width\":1000,\"height\":667,\"caption\":\"Citizen Developers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/database-creation-citizen-developers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database creation steps that Citizen Developers can do\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/63bd8646f2f4720f503116e38a190a6e\",\"name\":\"Mila\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g\",\"caption\":\"Mila\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/mila\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database creation steps that Citizen Developers can do","description":"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/","og_locale":"en_US","og_type":"article","og_title":"Database creation steps that Citizen Developers can do","og_description":"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/","og_site_name":"TeamDesk Blog","article_published_time":"2017-03-10T11:56:14+00:00","article_modified_time":"2017-03-10T12:18:25+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg","type":"image\/jpeg"}],"author":"Mila","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mila","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/"},"author":{"name":"Mila","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"headline":"Database creation steps that Citizen Developers can do","datePublished":"2017-03-10T11:56:14+00:00","dateModified":"2017-03-10T12:18:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/"},"wordCount":568,"commentCount":0,"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg","articleSection":["Tips & Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/","name":"Database creation steps that Citizen Developers can do","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#primaryimage"},"image":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#primaryimage"},"thumbnailUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg","datePublished":"2017-03-10T11:56:14+00:00","dateModified":"2017-03-10T12:18:25+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e"},"description":"Key recommendations that should be followed by citizen developers, who opened TeamDesk free trial and try to build an online database on their own.","breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#primaryimage","url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg","contentUrl":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2017\/03\/citizen-developers.jpg","width":1000,"height":667,"caption":"Citizen Developers"},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/database-creation-citizen-developers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Database creation steps that Citizen Developers can do"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/63bd8646f2f4720f503116e38a190a6e","name":"Mila","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/939a25c18364af1ceffe1d698a8fd01e1a18d8e1cf906fe3a6ac1cad64bc653f?s=96&d=mm&r=g","caption":"Mila"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/mila\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1055","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=1055"}],"version-history":[{"count":11,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1055\/revisions"}],"predecessor-version":[{"id":1067,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/1055\/revisions\/1067"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media\/1056"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=1055"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=1055"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=1055"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}