Visibility of the first column (ID number) or a formula column

User Talk Webforms
1

Hello everyone
I would like to record data with the Universal App or with a web form on site. It would be helpful to see which ID number (first column) is currently assigned for this data record. Unfortunately, I do not have this column in the selection of columns to be displayed (in Universal App or Webform). I don’t want to edit it either, I just want to see it. Is this possible in principle? And if so, how could this be realised?
Greetings

2

Hi @supergeorg68 ,
Probably not the most elegant way, but you can create your own column and fill it with the current ID using a script:

const tableName = 'Table1';
const viewName = 'Default View';
const IDColumnName = 'RealID';

const table = base.getTableByName(tableName);
const view = base.getViewByName(table, viewName);
let IDColumn = base.getColumnByName(table, IDColumnName);
if (IDColumn!=undefined) {

  const rows = base.getRows(table,view);
  const selectedRows = [], updatedRows = [];

  rows.forEach((row) => {
    selectedRows.push(row);
    let updatedRow = {};
    updatedRow[IDColumnName] = row._id
    updatedRows.push(updatedRow);
  });
  base.modifyRows(table, selectedRows, updatedRows);
  output.text("Script successfully completed");
}
else { output.text("Can't find column "+ IDColumnName); }

Bests,
Benjamin

3

We have a plan to add a formula to return row ID in version 5.1. Then you can display a row’s ID in formula column.

4

If I understand correctly, you want to display the result of a formula column in a web form or on the form page when a user completes the form.

This is currently not supported.

Please keep in mind that the record (in its entirety) is only created when the form is submitted.