Function moveColumnToField

packages/app-core/src/lib/database-cells.ts:200–218

(
  doc: DatabaseDoc,
  viewId: string,
  fieldId: string,
  targetFieldId: string
)

 *  column order — used by header drag-and-drop (#317). No-op for a non-table
 *  view, unknown ids, or a self-drop. */
export function moveColumnToField(
  doc: DatabaseDoc,
  viewId: string,
  fieldId: string,
  targetFieldId: string
): DatabaseDoc {
  if (fieldId === targetFieldId) return doc
  const view = doc.views.find((v) => v.id === viewId)
  if (!view || view.type !== 'table') return doc
  const fieldIds = doc.fields.map((f) => f.id)
  const stored = view.columnOrder ?? fieldIds
  const order = [...stored, ...fieldIds.filter((id) => !stored.includes(id))].filter((id) =>
    fieldIds.includes(id)
  )
  if (!order.includes(fieldId) || !order.includes(targetFieldId)) return doc
  const without = order.filter((id) => id !== fieldId)
  without.splice(without.indexOf(targetFieldId), 0, fieldId)
  return updateView(doc, viewId, { columnOrder: without })
}

export function ensureSelectOption(doc: DatabaseDoc, fieldId: string, rawValue: string): DatabaseDoc {
  const value = rawValue.trim().replace(/,/g, ' ') // option values may not contain commas