BA
Better Auth•2mo ago
Kenny

Custom Fields in Organization Table Not Saving Values

I'm having an issue with custom fields in the organization table. I've added company_size to my organization schema, but although the field exists in the database, the values I pass are never saved (always null). Here's my organization plugin config: 
organization({
  schema: {
    organization: {
      modelName: "firestorm_organizations",
      fields: {
        createdAt: "created_at",
      },
      additionalFields: {
        company_size: {
          type: "string",
          required: false,
          defaultValue: null,
        },
        stripe_customer_id: {
          type: "string",
          required: false,
          defaultValue: null,
        },
      },
    },
    // other schema configs...
  },
  // other config...
})
organization({
  schema: {
    organization: {
      modelName: "firestorm_organizations",
      fields: {
        createdAt: "created_at",
      },
      additionalFields: {
        company_size: {
          type: "string",
          required: false,
          defaultValue: null,
        },
        stripe_customer_id: {
          type: "string",
          required: false,
          defaultValue: null,
        },
      },
    },
    // other schema configs...
  },
  // other config...
})
And here's how I'm trying to create the organization: 
const organization = await auth.api.createOrganization({
  request: req,
  headers: req.headers,
  body: {
    name: body.companyName,
    slug: "",
    company_size: body.companySize, // This value isn't being saved
  },
})
const organization = await auth.api.createOrganization({
  request: req,
  headers: req.headers,
  body: {
    name: body.companyName,
    slug: "",
    company_size: body.companySize, // This value isn't being saved
  },
})
The database table has the column as expected (no errors): 
ALTER TABLE firestorm_organizations ADD COLUMN company_size TEXT;
ALTER TABLE firestorm_organizations ADD COLUMN company_size TEXT;
What am I missing? The documentation doesn't seem to cover custom organization fields in detail.
3 Replies
Kenny
KennyOP•2mo ago
I found this: https://discord.com/channels/1288403910284935179/1349447761182851214 Are there any workarounds that people know about or should I open up a github issue request on this? ^bump
hunita
hunita•2mo ago
Hi, I have a similar issue. I've created my organizations with additionalFields but will not have access to them neither on the client with useActiveOrganization nor on the server when using organization.getFullOrganization
bekacru
bekacru•2mo ago
the org plugin doesn't currently support additional fields

Did you find this page helpful?