EnumList Ref

AppSheet AppSheet Q&A
,
1

Dear AppSheeters,

I am encountering an issue with my [Sales Invoice] Form View in AppSheet. I have a column named [Work_Type], which is an EnumList with a Ref to the [Services] table.

I have implemented an Initial Value formula for the [Work_Type] column, which is as follows:

stephenrich_0-1740042033286.png
stephenrich_0-1740042033286.png385×103 5.77 KB

However, when I create a new [Sales Invoice] record, the [Work_Type] column appears completely empty, even before I enter any value in the [SQ_No] field. This is despite the column having a Ref to the [Services] table.

I would like to understand if the issue is related to the Initial Value formula I have used, or if there might be other factors causing the [Work_Type] column to remain empty.

Could anyone provide insights or suggestions on how to troubleshoot and resolve this issue?

Thank you for your assistance.

2

[Pipeline_Code].[Requirements] is a list yes?

Your formula should return a LIST(“”) instead of “” if the AND expression evaluates to FALSE.

2 Likes