{
"pages": [
{
"name": "Blog",
"title": "Saltcorn blog",
"layout": {
"above": [
{
"icon": "",
"type": "blank",
"block": false,
"contents": "Saltcorn blog
\n",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"widths": [
8,
4
],
"besides": [
{
"name": "9b3f64",
"type": "view",
"view": "Posts",
"state": "shared"
},
{
"url": "",
"type": "card",
"title": "",
"shadow": true,
"contents": {
"above": [
{
"icon": "",
"type": "blank",
"block": false,
"contents": "This is the blog for Saltcorn— an open-source no-code builder for web applications.
\n",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"icon": "",
"type": "blank",
"block": false,
"contents": "Other resources:
\n\n\n",
"labelFor": "",
"isFormula": {},
"textStyle": ""
}
]
},
"isFormula": {}
}
],
"breakpoints": [
"lg",
"lg"
]
}
]
},
"min_role": 100,
"menu_label": "Posts",
"description": "Blog for saltcorn, a no-code database application platform",
"fixed_states": {},
"root_page_for_roles": [
"admin",
"staff",
"user",
"public"
]
},
{
"name": "PostPage",
"title": "Saltcorn blog post",
"layout": {
"widths": [
8,
4
],
"besides": [
{
"name": "7b7925",
"type": "view",
"view": "Full Post",
"state": "shared"
},
{
"url": "",
"type": "card",
"title": "Recent posts",
"shadow": false,
"contents": {
"name": "1f4dfb",
"type": "view",
"view": "RecentPosts",
"state": "fixed"
},
"isFormula": {}
}
],
"breakpoints": [
"lg",
"lg"
]
},
"min_role": 100,
"description": "",
"fixed_states": {
"1f4dfb": {
"body": "",
"title": "",
"author": null,
"excerpt": "",
"published": null
},
"fixed_stateforrecentpostsview": null
},
"root_page_for_roles": []
}
],
"views": [
{
"name": "CommentFeed",
"table": "Comments",
"min_role": 100,
"viewtemplate": "Feed",
"configuration": {
"cols_lg": 1,
"cols_md": 1,
"cols_sm": 1,
"cols_xl": 1,
"in_card": false,
"viewname": "CommentFeed",
"show_view": "ShowComment",
"descending": false,
"order_field": "written",
"view_to_create": "EditComment"
},
"default_render_page": null
},
{
"name": "EditComment",
"table": "Comments",
"min_role": 100,
"viewtemplate": "Edit",
"configuration": {
"fixed": {
"written": null,
"preset_written": "Now"
},
"layout": {
"above": [
{
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Your name",
"labelFor": "",
"isFormula": {},
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "name",
"configuration": {}
}
]
}
],
"breakpoints": [
"",
""
]
},
{
"type": "line_break"
},
{
"widths": [
2,
10
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Comment",
"labelFor": "",
"isFormula": {},
"textStyle": ""
}
]
},
{
"above": [
null,
{
"type": "field",
"block": false,
"fieldview": "CKEditor4",
"textStyle": "",
"field_name": "comment",
"configuration": {}
}
]
}
],
"breakpoints": [
"",
""
]
},
{
"type": "line_break"
},
{
"type": "field",
"block": true,
"fieldview": "edit",
"textStyle": "",
"field_name": "post",
"configuration": {}
},
{
"type": "action",
"block": false,
"rndid": "e1d9e2",
"minRole": 100,
"isFormula": {},
"action_icon": "",
"action_name": "Save",
"action_size": "",
"action_label": "",
"action_style": "btn-primary",
"configuration": {}
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "edit",
"field_name": "name",
"configuration": {}
},
{
"type": "Field",
"fieldview": "CKEditor4",
"field_name": "comment",
"configuration": {}
},
{
"type": "Field",
"fieldview": "edit",
"field_name": "post",
"configuration": {}
},
{
"type": "Action",
"rndid": "e1d9e2",
"minRole": 100,
"isFormula": {},
"action_icon": "",
"action_name": "Save",
"action_size": "",
"action_label": "",
"action_style": "btn-primary",
"configuration": {}
}
],
"viewname": "EditComment",
"exttable_name": null,
"view_when_done": "Posts"
},
"default_render_page": ""
},
{
"name": "EditPost",
"table": "Posts",
"min_role": 80,
"viewtemplate": "Edit",
"configuration": {
"fixed": {
"author": null,
"published": null,
"preset_author": "LoggedIn",
"preset_published": "Now"
},
"layout": {
"above": [
{
"widths": [
12
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Title",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"type": "line_break"
},
{
"type": "field",
"block": false,
"fieldview": "edit",
"textStyle": "",
"field_name": "title",
"configuration": {}
}
]
}
],
"breakpoints": [
""
]
},
{
"type": "line_break"
},
{
"widths": [
12
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Excerpt",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"type": "line_break"
},
{
"type": "field",
"block": false,
"fieldview": "CKEditor4",
"textStyle": "",
"field_name": "excerpt",
"configuration": {}
}
]
}
],
"breakpoints": [
""
]
},
{
"type": "line_break"
},
{
"widths": [
12
],
"besides": [
{
"above": [
null,
{
"type": "blank",
"block": false,
"contents": "Body",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"type": "line_break"
},
{
"type": "field",
"block": false,
"fieldview": "CKEditor4",
"textStyle": "",
"field_name": "body",
"configuration": {}
}
]
}
],
"breakpoints": [
""
]
},
{
"type": "line_break"
},
{
"type": "action",
"block": false,
"rndid": "7c91e5",
"minRole": 100,
"isFormula": {},
"action_icon": "",
"action_name": "Save",
"action_size": "",
"action_label": "",
"action_style": "btn-primary",
"configuration": {}
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "edit",
"field_name": "title",
"configuration": {}
},
{
"type": "Field",
"fieldview": "CKEditor4",
"field_name": "excerpt",
"configuration": {}
},
{
"type": "Field",
"fieldview": "CKEditor4",
"field_name": "body",
"configuration": {}
},
{
"type": "Action",
"rndid": "7c91e5",
"minRole": 100,
"isFormula": {},
"action_icon": "",
"action_name": "Save",
"action_size": "",
"action_label": "",
"action_style": "btn-primary",
"configuration": {}
}
],
"viewname": "EditPost",
"exttable_name": null,
"view_when_done": "ShowPost"
},
"default_render_page": ""
},
{
"name": "Full Post",
"table": "Posts",
"min_role": 100,
"viewtemplate": "ListShowList",
"configuration": {
"viewname": "Full Post",
"list_view": "",
"show_view": "ShowPost",
"subtables": {
"ChildList:CommentFeed.Comments.post": true,
"ChildList:EditComment.Comments.post": false
}
},
"default_render_page": "PostPage"
},
{
"name": "NextPostLink",
"table": "Posts",
"min_role": 100,
"viewtemplate": "PreviousOrNextLink",
"configuration": {
"viewname": "NextPostLink",
"link_view": "Full Post",
"descending": false,
"fixed_label": "Next: ",
"label_field": "title",
"order_field": "published",
"exttable_name": null
},
"default_render_page": ""
},
{
"name": "PeekPost",
"table": "Posts",
"min_role": 100,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "view_link",
"view": "Own:Full Post",
"block": false,
"minRole": 100,
"in_modal": false,
"isFormula": {
"label": true
},
"link_icon": "",
"link_size": "",
"textStyle": "h3",
"link_style": "",
"view_label": "title"
},
{
"type": "field",
"block": true,
"fieldview": "relative",
"textStyle": "",
"field_name": "published",
"configuration": {}
},
{
"type": "field",
"block": true,
"fieldview": "showAll",
"textStyle": "",
"field_name": "excerpt",
"configuration": {}
},
{
"stat": "Count",
"type": "aggregation",
"block": false,
"aggwhere": "",
"agg_field": "name",
"textStyle": "small",
"agg_relation": "Comments.post"
},
{
"type": "blank",
"block": false,
"contents": " comments",
"labelFor": "",
"isFormula": {},
"textStyle": "small"
},
{
"type": "view_link",
"view": "Own:Full Post",
"block": true,
"minRole": 100,
"in_modal": false,
"isFormula": {},
"link_icon": "",
"link_size": "",
"textStyle": "",
"link_style": "",
"view_label": "Read full post..."
}
]
},
"columns": [
{
"type": "ViewLink",
"view": "Own:Full Post",
"minRole": 100,
"in_modal": false
},
{
"type": "Field",
"fieldview": "relative",
"field_name": "published",
"configuration": {}
},
{
"type": "Field",
"fieldview": "showAll",
"field_name": "excerpt",
"configuration": {}
},
{
"stat": "Count",
"type": "Aggregation",
"aggwhere": "",
"agg_field": "name",
"agg_relation": "Comments.post"
},
{
"type": "ViewLink",
"view": "Own:Full Post",
"minRole": 100,
"in_modal": false
}
],
"viewname": "PeekPost",
"page_title": "",
"exttable_name": null,
"page_title_formula": false
},
"default_render_page": ""
},
{
"name": "Posts",
"table": "Posts",
"min_role": 100,
"viewtemplate": "Feed",
"configuration": {
"cols_lg": 1,
"cols_md": 1,
"cols_sm": 1,
"cols_xl": 1,
"in_card": true,
"viewname": "Posts",
"show_view": "PeekPost",
"descending": true,
"order_field": "published",
"exttable_name": null,
"rows_per_page": 10,
"view_to_create": "EditPost",
"hide_pagination": false,
"masonry_columns": false,
"create_view_label": "",
"create_view_display": "Link",
"create_view_location": ""
},
"default_render_page": ""
},
{
"name": "PrevPostLink",
"table": "Posts",
"min_role": 100,
"viewtemplate": "PreviousOrNextLink",
"configuration": {
"viewname": "NextPostLink",
"link_view": "Full Post",
"descending": true,
"fixed_label": "Previous: ",
"label_field": "title",
"order_field": "published",
"exttable_name": null
},
"default_render_page": ""
},
{
"name": "RecentPosts",
"table": "Posts",
"min_role": 100,
"viewtemplate": "Feed",
"configuration": {
"cols_lg": 1,
"cols_md": 1,
"cols_sm": 1,
"cols_xl": 1,
"in_card": false,
"viewname": "RecentPosts",
"show_view": "ShortPostPeek",
"descending": true,
"order_field": "published",
"rows_per_page": 5,
"view_to_create": "",
"hide_pagination": true,
"create_view_display": "Link"
},
"default_render_page": ""
},
{
"name": "ShortPostPeek",
"table": "Posts",
"min_role": 100,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "view_link",
"view": "Own:Full Post",
"block": true,
"minRole": 100,
"isFormula": {
"label": true
},
"view_label": "title"
},
{
"type": "field",
"block": true,
"fieldview": "relative",
"field_name": "published"
},
{
"type": "line_break"
}
]
},
"columns": [
{
"type": "ViewLink",
"view": "Own:Full Post",
"minRole": 100
},
{
"type": "Field",
"fieldview": "relative",
"field_name": "published"
}
],
"viewname": "ShortPostPeek"
},
"default_render_page": ""
},
{
"name": "ShowComment",
"table": "Comments",
"min_role": 100,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "field",
"block": false,
"fieldview": "as_text",
"textStyle": "small",
"field_name": "name"
},
{
"type": "field",
"block": true,
"fieldview": "relative",
"textStyle": "small",
"field_name": "written"
},
{
"type": "field",
"block": false,
"fieldview": "as_text",
"textStyle": "",
"field_name": "comment"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "name"
},
{
"type": "Field",
"fieldview": "relative",
"field_name": "written"
},
{
"type": "Field",
"fieldview": "as_text",
"field_name": "comment"
}
],
"viewname": "ShowComment"
},
"default_render_page": null
},
{
"name": "ShowPost",
"table": "Posts",
"min_role": 100,
"viewtemplate": "Show",
"configuration": {
"layout": {
"above": [
{
"type": "field",
"block": true,
"fieldview": "as_text",
"textStyle": "h2",
"field_name": "title",
"configuration": {}
},
{
"icon": "",
"type": "blank",
"block": false,
"contents": "By ",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"type": "join_field",
"block": false,
"textStyle": "",
"join_field": "author.full_name"
},
{
"type": "line_break"
},
{
"type": "blank",
"isHTML": true,
"contents": "
"
},
{
"icon": "",
"type": "blank",
"block": false,
"contents": "Published on ",
"labelFor": "",
"isFormula": {},
"textStyle": ""
},
{
"type": "field",
"block": false,
"fieldview": "format",
"textStyle": "",
"field_name": "published",
"configuration": {
"format": "DD MMMM YYYY"
}
},
{
"type": "blank",
"isHTML": true,
"contents": "
"
},
{
"type": "field",
"block": true,
"fieldview": "showAll",
"textStyle": "",
"field_name": "body",
"configuration": {}
},
{
"widths": [
6,
6
],
"besides": [
{
"name": "ff1dd5",
"type": "view",
"view": "Own:PrevPostLink",
"state": "shared"
},
{
"above": [
null,
{
"name": "73a416",
"type": "view",
"view": "Own:NextPostLink",
"state": "shared"
}
]
}
],
"breakpoints": [
"",
""
]
},
{
"type": "view_link",
"view": "Own:EditPost",
"block": false,
"minRole": "40",
"in_modal": false,
"isFormula": {},
"link_icon": "",
"link_size": "",
"link_style": "",
"view_label": "Edit"
},
{
"type": "line_break"
}
]
},
"columns": [
{
"type": "Field",
"fieldview": "as_text",
"field_name": "title",
"configuration": {}
},
{
"type": "JoinField",
"join_field": "author.full_name"
},
{
"type": "Field",
"fieldview": "format",
"field_name": "published",
"configuration": {
"format": "DD MMMM YYYY"
}
},
{
"type": "Field",
"fieldview": "showAll",
"field_name": "body",
"configuration": {}
},
{
"type": "ViewLink",
"view": "Own:EditPost",
"minRole": "40",
"in_modal": false
}
],
"viewname": "ShowPost",
"page_title": "title",
"exttable_name": null,
"page_title_formula": true
},
"default_render_page": ""
}
],
"tables": [
{
"name": "Comments",
"fields": [
{
"name": "name",
"type": "String",
"label": "Your name",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"match": "",
"options": ""
},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "comment",
"type": "HTML",
"label": "Comment",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "written",
"type": "Date",
"label": "Written",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "post",
"type": "Key",
"label": "Post",
"stored": false,
"refname": "id",
"reftype": "Integer",
"required": true,
"is_unique": false,
"attributes": {
"summary_field": "title"
},
"calculated": false,
"expression": null,
"primary_key": false,
"reftable_name": "Posts"
},
{
"name": "id",
"type": "Integer",
"label": "ID",
"stored": false,
"required": true,
"is_unique": true,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": true
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 100,
"min_role_write": 100,
"ownership_field_name": null
},
{
"name": "Posts",
"fields": [
{
"name": "title",
"type": "String",
"label": "Title",
"stored": false,
"required": true,
"is_unique": true,
"attributes": {
"options": ""
},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "body",
"type": "HTML",
"label": "Body",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "published",
"type": "Date",
"label": "Published",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "excerpt",
"type": "HTML",
"label": "Excerpt",
"stored": false,
"required": true,
"is_unique": false,
"attributes": {
"default": " \r\n"
},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "id",
"type": "Integer",
"label": "ID",
"stored": false,
"required": true,
"is_unique": true,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": true
},
{
"name": "author",
"type": "Key",
"label": "Author",
"stored": false,
"refname": "id",
"reftype": "Integer",
"required": true,
"is_unique": false,
"attributes": {
"default": 1,
"summary_field": "full_name"
},
"calculated": false,
"expression": null,
"primary_key": false,
"reftable_name": "users"
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 100,
"min_role_write": 1,
"ownership_field_name": null
},
{
"name": "users",
"fields": [
{
"name": "email",
"type": "String",
"label": "Email",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": false
},
{
"name": "id",
"type": "Integer",
"label": "ID",
"stored": false,
"required": true,
"is_unique": true,
"attributes": {},
"calculated": false,
"expression": null,
"primary_key": true
},
{
"name": "full_name",
"type": "String",
"label": "Full Name",
"stored": false,
"required": false,
"is_unique": false,
"attributes": {
"regexp": "",
"options": "",
"max_length": null,
"min_length": null,
"re_invalid_error": ""
},
"calculated": false,
"expression": null,
"primary_key": false
}
],
"triggers": [],
"versioned": false,
"constraints": [],
"min_role_read": 1,
"min_role_write": 1,
"ownership_field_name": null
}
],
"plugins": [
{
"name": "@saltcorn/html",
"source": "npm",
"location": "@saltcorn/html",
"configuration": null
},
{
"name": "stepper",
"source": "npm",
"location": "@saltcorn/stepper",
"configuration": null
},
{
"name": "ckeditor4",
"source": "npm",
"location": "@saltcorn/ckeditor4",
"configuration": null
},
{
"name": "any-bootstrap-theme",
"source": "npm",
"location": "@saltcorn/any-bootstrap-theme",
"configuration": {
"fluid": false,
"theme": "litera",
"toppad": 2,
"css_url": null,
"in_card": false,
"css_file": null,
"fixedTop": false,
"colorscheme": "navbar-dark bg-dark",
"css_integrity": null,
"backgroundColor": "#ffffff"
}
}
]
}