Is there a way for the initial Value of a col...

[Danni_Perotti]

Is there a way for the initial Value of a column to be different depending on what view of the app you are in?

[Aleksi_Alkio]

Well… the problem is you don’t know the view where you are because you don’t have any expression to read that. If you think this from another perspective, you could achieve that. I assume you are asking this for the slice. If you use the same condition rule for IFS expression than you have for that slice, you have that functionality. Another one workaround could be the action button. You can show a different action button depending on the same slice condition rule.

[Danni_Perotti]

can you explain this a little more to me please and how the function works?

[Aleksi_Alkio]

Would you please open your request little more. Are these views from different slices?

[jandrostory81]

@Aleksi, were you able to get an answer for this?

I have a slice called RMS, another called SHHS, and another called R6G. I would like for the initial value for the ID Column to be “RMS” for the RMS slice, “SHHS” for the SHHS Slice and “R6G” for te R6G Slice. how can I write a formula for this in the initial values?

[Jin_Tan]

Hi,

Have you tried to create an action where type of action is “App:go to another view within this app”. and app link target is as below:
LINKTOFORM("(The name of RMS slice"_Form, “ID Column”, Concatenate(“RMS-”,UNIQUEID()))

[Aleksi]

If you have one form view for one slice, you could read it with the expression CONTEXT(“View”) and then you could use something like
SWITCH(CONTEXT(“View”),
“RMS_Slice”,“RMS”,
“SHHS_Slice”,“SHHS”,
“R6G”)

[jandrostory81]

Thanks Aleski would i put this in the initial value section?

[jandrostory81]

I put it in the initial value and it only returned R6G in all 3 forms. There is a separate form for each slice. Any ideas?

[Aleksi]

It depends do you want to set it as a fixed value or should it change when the record is opened and saved.

[jandrostory81]

I want it to be that everytime a new record is added in the RMS slice that the [ID] column is set to RMS. The idea is to save time while filling out the form

[Aleksi]

Then you could probably use it as an initial value.

[jandrostory81]

Solved it! I created an IFS condition based on your input @Aleksi and put it in the initial value of the column I wanted it to apply to:

IFS(CONTEXT(“View”) = “RMS_FORM”, “RMS”, CONTEXT(“View”)= “R6G_FORM”, “R6G”, CONTEXT(“View”)=“SHHS_FORM”, “SHHS”, CONTEXT(“View”)=“Pyramid Form”, “Pyramid”)

It worked perfectly.

[Steve]

Your expression can be simplified:

SWITCH(
  CONTEXT(“View”),
  “RMS_FORM”, “RMS”,
  “R6G_FORM”, “R6G”,
  “SHHS_FORM”, “SHHS”,
  “Pyramid Form”, “Pyramid”,
  ""
)

[EdC]

So helpful. I was just stuck on this problem. It totally worked. Thanks!

[Aleksi]

Excellent!