Subtable always shows Add when it shouldn't

AppSheet AppSheet Q&A
1

Rather than clicking Add in a subtable to create a record, I want to use LinkToForm() via an Action since I need to populate some columns with specific data. Setup the action and its working as expected.

So the origional Virtual list column had a formula of

REF_ROWS(“Timesheet”, “Plot”)

So I changed it to

REF_ROWS(“Timesheet Update Only”, “Plot”)

Timesheet Update Only being an Editable Only slice of the entire Timesheet table. Yet the subtable still had the Add option. So I tried this instead

Select(Timesheet Update Only[TimesheetID],[Plot]=[_ThisRow].[PlotID])

But the Add was still there

Is the Add there because I’ve got a LinkToForm button? In the end I’ve had to hide the Add System Action for the timesheet table, but it seems odd to have to go that far. What am I doing wrong?

2

These should match:

3X_7_a_7a5b1e26c6b55c107c68c9bc4e6f5a6a00fe093b.png
3X_7_a_7a5b1e26c6b55c107c68c9bc4e6f5a6a00fe093b.png573×480 32.7 KB

2 Likes
3

This is where my question to community is coming from.

[Not sure what is the best, but allow me ask a question](https://community.appsheet.com/t/not-sure-what-is-the-best-but-allow-me-ask-a-question/30527) Questions

Now Enum , Enumlist, auto-generated List type data fields do have a setting to select “which table you are refering to?” Appsheet is currently not throwin No Error nor alert if there is mismatch between the table/slice name where the expression is refereing to AND the table/slice which the base type with ref is refering to. I see bunch of question and post here recently, which is solved by proper settings, filling the gaps between expression and base type table/slice names. I m not entirely s…

Bit confusing.

1 Like