Tip: How to get a Field ID from GUI for use in API

hmm, could you not just use the RECORD_ID() function in your formula? I think thats all you need.

That returns the ID of the record(the row, in the user interface), not the ID of the field (the column, in the user interface).

ah, gotcha. ok, that is a nice hack :slightly_smiling_face:

Great find! This is a neat trick to prevent script errors, thanks for sharing.

You can actually find these field IDs a bit faster using your browser inspector, just inspect the header cells and you’ll find a data-columnid html attribute that reveals this field ID. This also allows you to get the ID for your primary key, if that’s ever of use.

And now there’s an even easier way, thanks to Scripting block.

Of course, the Scripting block will require a paid subscription, whereas the Standard API is free.

I believe that all these methods are probably less ideal than using the Metadata API if that is an option.

Unfortunately, the Meta API is only available server-side (i.e., call from backend): " Client-side requests are not allowed"

copied from FB comments, quick steps

field IDs of current active table:

output.table(base.getTable(cursor.activeTableId).fields)

find field in a base when you know ID

const FIELD='PUT_ID_HERE'
let table=base.tables.find(t=>t.fields.some(f=>f.id==FIELD))
output.text(table?.name+'/'+table?.getField(FIELD).name)

There is now a simple way to do it in the OOTB GUI.

In your workspace head to the right and click on the "tools" drop down, then select "manage field" and then use the filter option on the right hand side of the screen to show the Field ID (toggle visibility)