Rowy Config files?

[runnedrun]

Hi, love the idea of Rowy and hope my dev shop can start using it on our projects! The main feature missing for us right now is (as far as I can tell) the ability to programmatically configure Rowy. Does this functionality already exist? For instance, right now we generate basic admin tables for clients from typescript types (that themselves are turned into JSON schemas). This ensures that our admin panels are always up to date with our code AND allows us to easily configure and modify our admin panels with code that is in git (as opposed to somebody randomly configuring some UI and not knowing how to undo it).

Does Rowy have any way for us to use code to configure the tables, fields, etc in a sheet? (without needing to dig into the source)

Thanks!

[harinij]

Hi @runnedrun 👋 We currently have an option that lets you import/export a table setting as a json (short video on how to below). Also, only admins of the project can create tables, add columns etc. That way other roles invited to the project are prevented from making UI changes.

Screen.Recording.2022-07-13.at.6.18.39.pm.mov

All the config of a project is stored under _rowy_/settings even though it is not recommended to do direct manipulation of that config, that's another option if needed.

PS: we are bringing multiple projects/workspaces support soon so watch this space :)

[runnedrun]

OK great, thanks for the quick response @harinij . Follow up question: Is there a way to do this programmatically? Seems like we can generate the importable json from our TS types, but is there an endpoint we can hit to automatically setup new or update existing Rowy tables?

Related, is it possible to import json to update an existing table?

Thanks!

[notsidney]

Hey, you can see your Rowy config in your Firestore database under _rowy_/settings where there is a tables array. You can find the type for that here:

rowy/src/types/table.d.ts

Lines 63 to 80 in e4e19f3

	/** Table settings stored in project settings */
	export type TableSettings = {
	id: string;
	collection: string;
	name: string;
	/** Roles that can see this table in the UI and navigate. Firestore Rules need to be set to give access to the data */
	roles: string[];
	section: string;
	description?: string;
	tableType: "primaryCollection" | "collectionGroup";
	audit?: boolean;
	auditFieldCreatedBy?: string;
	auditFieldUpdatedBy?: string;
	readOnly?: boolean;
	};

Then, to add columns, you can create or edit documents in _rowy_/settings/schema/<table_id>. The type for that document is:

rowy/src/types/table.d.ts

Lines 82 to 98 in e4e19f3

	/** Table schema document loaded when table or table settings dialog is open */
	export type TableSchema = {
	columns?: Record<string, ColumnConfig>;
	rowHeight?: number;
	filters?: TableFilter[];
	filtersOverridable?: boolean;
	functionConfigPath?: string;
	functionBuilderRef?: any;
	extensionObjects?: IExtension[];
	compiledExtension?: string;
	webhooks?: IWebhook[];
	/** @deprecated Migrate to Extensions */
	sparks?: string;
	};

[runnedrun]

Amazing, this is great, thanks!