Unable to find 'Row ID' in dropdown to set value while trying to use an action

[Nirmal_Giri]

Hello,

When using action ‘Add new row to another table using values from this row’, I am unable to find certain columns in the dropdown to set values.

Row ID not visible in the dropdown selection.

Row ID only has a initial value expression. Why cannot I see it in dropdown list?

[Marc_Dillon]

Because you have that column set as your Key, and key values are not editable except when a record is first created.

help.appsheet.com

What is a Key?

Learn the purpose of keys and why they’re necessary.

[Nirmal_Giri]

Thanks for reply.
I initially thought the same too since Row ID is a Key.
But I can see the Key column in other tables… See below…

[Steve]

Does the Row ID column of the Customer Details table have a non-blank Spreadsheet formula setting?

[Nirmal_Giri]

There is no Spreadsheet formula for Row ID.

I face similar issue with two other tables -

[Steve]

Just to confirm, did you scroll down through the list of available columns?

[Nirmal_Giri]

@Steve I did that. Cannot find any column by name Row ID
here is the complete list…

[Steve]

Looks odd to me, then. Probably best to engage Support for a deeper investigation.

https://www.appsheet.com/Support/Contact

[Nirmal_Giri]

Will send a mail to support. Thanks for help Steve

[Pascal_Pianezzi]

I experience the same behaviour and … it is reproducible!

So - No matter if Row ID is key or not, it will never display in the dropdown.

[Steve]

Please contact Support for help with this.

[Joseph_Seddik]

Just an idea. I didn’t face the exact same problem as yours creating an action, but I remember having a column missing from a view and couldn’t find it no matter what I did.

A “Regenerate Structure” solved the issue. May be you should try it.

Also, for other non-related weired issues, especially after a save, reloading the browser’s page helps.

@Nirmal_Giri