Tabular data page - inline insert where data is ID, would like the header for inline add match to the grid display and grid to display the Data name to ID match

[MarkMayhrai]

Hi,

Need some help for the Headers to line up in a Tabular data page which has an In-Line add a record on TOP.

As one of the fields is an ID, it displays as a number in the tabular search report, and on the in-line add, it can be configured via a dropdown to see a name on the related table.

In need for the tabluar report to show the name on the linked table, please

[PotatoMato]

Hi @MarkMayhrai, do you have a table relationship between the dropdown table and the main table? If yes, you will need to select the "Use display value on DataPages": https://howto.caspio.com/tables-and-views/relationships/relationship-settings/#:~:text=Use display value on DataPages.

 

Hope this helps.

 

-Potato

[NiceDuck]

OR you can use a calculated field with fir the Company ID instead of the actual field and have the following Querry: 

Select Company_Name from Source_Table where ID = target.[@field:CompanyID]

Just change the 'Company_Name' to what is your actual name of the field and 'Source_Table' to the actual table name. 

[NiceDuck]

Wait, after further checking, you have an inline insert on your setup. Thus my suggestion above, while it will work, is kind of impractical. 

The best solution for this is the one suggested by @PotatoMato above.