Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This is the documentation for ConfiForms Server/Data Center app

However, this might also work for ConfiForms cloud and in most cases it does. But please see this page to understand the differences between server and cloud versions of the ConfiForms app.


 

We have 2 tables with dependent data

One-to-many from contractor_categories to contractor_subcategories


Dropdown fields use the following SQL queries

SELECT id, name FROM contractor_categories
 
SELECT id, name, contractor_categories_id FROM contractor_subcategories

 

DB setup

create table contractor_categories (id int, name varchar(100));
create table contractor_subcategories (id int, name varchar(100), contractor_categories_id int);

insert into contractor_categories values(1, 'Software Development');
insert into contractor_categories values(2, 'Cleaning');
insert into contractor_categories values(3, 'Security');
 
insert into contractor_subcategories values(4, 'General cleaning', 2);

insert into contractor_subcategories values(5, 'Entrance', 3);
insert into contractor_subcategories values(6, 'Night shifts only', 3);
insert into contractor_subcategories values(7, 'Basement and perimeter', 3);

 

Form configuration

  • No labels