{"_id":"5536e7e69f7f2d0d00b1cd62","__v":6,"project":"55357364e02d480d0003c6d3","user":"55356ede6040a20d00454508","category":{"_id":"5536e6bf7fe60f0d000fd1c0","__v":18,"pages":["5536e6ed9f7f2d0d00b1cd56","5536e736bbb4a70d00a53534","5536e73f9f7f2d0d00b1cd59","5536e74dbbb4a70d00a53536","5536e7569f7f2d0d00b1cd5b","5536e7609f7f2d0d00b1cd5d","5536e76b20d5ca0d0001580d","5536e78220d5ca0d0001580f","5536e797b91d030d004c3d91","5536e7a120d5ca0d00015811","5536e7b320d5ca0d00015813","5536e7bbbbb4a70d00a5353a","5536e7c99f7f2d0d00b1cd60","5536e7d29030530d0007f860","5536e7dbbbb4a70d00a5353c","5536e7e69f7f2d0d00b1cd62","5571ef581cd8283500a8b4de","55b80d6be89bbf25009f045b"],"project":"55357364e02d480d0003c6d3","version":"553591cd63cc650d00312925","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-04-22T00:09:35.017Z","from_sync":false,"order":9,"slug":"form-fields","title":"Form Fields"},"version":{"_id":"553591cd63cc650d00312925","project":"55357364e02d480d0003c6d3","__v":13,"forked_from":"55357365e02d480d0003c6d6","createdAt":"2015-04-20T23:54:53.134Z","releaseDate":"2015-04-20T23:54:53.134Z","categories":["553591cd63cc650d00312926","553591cd63cc650d00312927","5536e4d39f7f2d0d00b1cd54","5536e55c20d5ca0d0001580a","5536e6bf7fe60f0d000fd1c0","5536f5bba171250d00c00556","553a974369c2630d00a8562e","553a97c60074c80d00621c2a","553a98332af5f20d000fc32a","553a9b9869c2630d00a85642","556e0f23d02e0b190042f13d","563249b1dcc27a1700823650","5639113f049e420d00476b03","59a5dd94aaa11d003334edb4"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"2.0.0","version":"2"},"parentDoc":null,"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-04-22T00:14:30.412Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"auth":"required","params":[],"url":""},"isReference":false,"order":15,"body":"GoFormz offers users the ability to upload Data Sources to their account.  Data Sources are a convenient way to import data sets related to your business/project into the GoFormz system.\n\nThe following image demonstrates the \"AXIS Customer List\", a Data Source uploaded to the GoFormz system.  This image will be used to explain concepts further down the page.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/pX1YorONQqGq4sbgd7pC_Capture3.PNG\",\n        \"Capture3.PNG\",\n        \"1483\",\n        \"913\",\n        \"\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nThe Database Field is configured in the Template Editor to list all of the values of the Data Source column specified.  In the example below, the Database Field is configured to use the \"AXIS Customer List\" and list values defined in the `Key` column.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/E7eyJ5mSVmDBT4eKgx4x_Capture4.PNG\",\n        \"Capture4.PNG\",\n        \"375\",\n        \"296\",\n        \"#2d6073\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nConfiguring the Database Field on the template in this way means that the `value` property can be set to any value contained within the \"Key\" column of the Data Source.  \n\nIn the example above this means the Database Field `value` property can be set to any one of the following values:\n\n- B V General Inc.\n- Beverly Healthcare\n- Birch Ptrick Convalescent\n- Casa Palmera Care Center\n- ...\n[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"{\\n \\t\\\"Customer\\\": {\\n      \\\"value\\\": \\\"Casa Palmera Care Center\\\",\\n      \\\"id\\\": \\\"d283fd84-8df4-4fbe-95d3-a479010b6faa\\\",\\n      \\\"name\\\": \\\"Customer\\\",\\n      \\\"type\\\": \\\"Database\\\"\\n    } \\n}\",\n      \"language\": \"json\"\n    }\n  ]\n}\n[/block]\n\n[block:callout]\n{\n  \"type\": \"info\",\n  \"title\": \"NOTE:\",\n  \"body\": \"The id, name, and type are not necessary when creating or updating a form, they are returned in the JSON of a request for readability.\"\n}\n[/block]","excerpt":"","slug":"database-field","type":"basic","title":"Database Field"}
GoFormz offers users the ability to upload Data Sources to their account. Data Sources are a convenient way to import data sets related to your business/project into the GoFormz system. The following image demonstrates the "AXIS Customer List", a Data Source uploaded to the GoFormz system. This image will be used to explain concepts further down the page. [block:image] { "images": [ { "image": [ "https://files.readme.io/pX1YorONQqGq4sbgd7pC_Capture3.PNG", "Capture3.PNG", "1483", "913", "", "" ] } ] } [/block] The Database Field is configured in the Template Editor to list all of the values of the Data Source column specified. In the example below, the Database Field is configured to use the "AXIS Customer List" and list values defined in the `Key` column. [block:image] { "images": [ { "image": [ "https://files.readme.io/E7eyJ5mSVmDBT4eKgx4x_Capture4.PNG", "Capture4.PNG", "375", "296", "#2d6073", "" ] } ] } [/block] Configuring the Database Field on the template in this way means that the `value` property can be set to any value contained within the "Key" column of the Data Source. In the example above this means the Database Field `value` property can be set to any one of the following values: - B V General Inc. - Beverly Healthcare - Birch Ptrick Convalescent - Casa Palmera Care Center - ... [block:code] { "codes": [ { "code": "{\n \t\"Customer\": {\n \"value\": \"Casa Palmera Care Center\",\n \"id\": \"d283fd84-8df4-4fbe-95d3-a479010b6faa\",\n \"name\": \"Customer\",\n \"type\": \"Database\"\n } \n}", "language": "json" } ] } [/block] [block:callout] { "type": "info", "title": "NOTE:", "body": "The id, name, and type are not necessary when creating or updating a form, they are returned in the JSON of a request for readability." } [/block]