Can I make the first argument of LINKTOFORM a variable?

[Kin_Wai_Cheuk]

In my app sheet, I have different tables to manage different inventories in different building.
I would like to use the LINKTOFORM function like this to add a button to move inventories between buildings.

But the problem is that LINKTOFORM has a fixed view-name argument. For example, I have three tables, Building A, Building B, and Building C. I would need six actions:

1. “Building A to Building B”
2. “Building A to Building C”
3. “Building B to Building A”
4. “Building B to Building C”
5. “Building C to Building A”
6. “Building C to Building B”.

It does not scale up nice if we have more and more buildings.
Is it possible to have a action called “to Building B”. When performing that action on Building A, it will do “A to B”. When performing the same action on Building C, it will do “C to B”?

[Marc_Dillon]

Kin_Wai_Cheuk:

LINKTOFORM has a fixed view-name argument

That is correct, it cannot be variable. However you can still build a variable expression. Instead of this:

LINKTOFORM( [variable-view] ... )

You can do:

SWITCH(
  [variable-view] ,
  "view a" , LINKTOFORM( "view a" ... ) ,
  "view b" , LINKTOFORM( "view b" ... ) ,
  ...
)

You would still need a create separate Actions for each Table though.

Kin_Wai_Cheuk:

I have different tables to manage different inventories in different building

I recommend merging your inventory Tables into one, and including a [building] column.

[KinWaiCheuk]

Can I create different view out of the [building] column? I would like to use the bottom bar feature to access different buildings.

[Marc_Dillon]

I don't know what you mean by that.

[KinWaiCheuk]

Thanks for the quick reply!
In our app, we want to use the bottom bar (indicated by a red circle in the image).

But it seems that this bar only appears when I put different "building"s into different sheets.

How to keep this bottom bar  when I move everything to the [building] column?

[Marc_Dillon]

Ohhh, I think I understand what you're asking. Check out Slices

https://help.appsheet.com/en/articles/895302-slices-the-essentials

You can create a Slice for a specific building, with condition [building]="xxx", then set your Views to the Slices instead of the base Table.