Context View

AppSheet AppSheet Q&A
1

I need that the dependent tables only allow to add or edit from the edition of the parent table, so that the updated calculations are saved. To do this I did the following:

IF(
CONTEXT(“ViewType”)=“Form”,

IFS(
LOOKUP(USEREMAIL(),“Usuarios”,“email usuario”,“Cargo”)=“Administrador”,“ALL_CHANGES”, LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cambiar Contraseña”)=“Salir”, “READ_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Administrador”,“ALL_CHANGES”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargada”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargado”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Auxiliar”,“READ_ONLY”
),
“READ_ONLY”,
)

The IFS () expression was already working correctly, when I added the IF (CONTEXT (… something strange happens, it correctly displays the list online, with the VIEW button in the non-Form views and shows New in the Form.
Therefore I understand that you are interpreting the expression.
But when you click on NEW, the screen is empty

Video:

2

There are times where CONTEXT() might return a blank value. When that happens, CONTEXT(“ViewType”)=“Form” will be TRUE, which probably isn’t what you want. Change instead to “Form”=CONTEXT(“ViewType”).

Your IFS() expression lacks a default condition. If none of the existing conditions match, IFS() will return a blank value, which probably isn’t what you want. Add a default to IFS(): IFS(..., TRUE, "READ_ONLY").

You could easily handle the CONTEXT() check within the IFS() without an IF() wrapper: IFS(“Form”=CONTEXT(“ViewType”), "READ_ONLY", ...).

See if these suggestions help.

2 Likes
3

@Steve

I modified the expression like this, but it produces the same effect

IFS(
“Form”<>CONTEXT(“ViewType”), “READ_ONLY”,
LOOKUP(USEREMAIL(),“Usuarios”,“email usuario”,“Cargo”)=“Administrador”,“ALL_CHANGES”, LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cambiar Contraseña”)=“Salir”, “READ_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Administrador”,“ALL_CHANGES”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargada”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargado”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Auxiliar”,“READ_ONLY”
)

I don’t know how to put a default value in the IFS () expression, since it asks me for pairs of values:

“IFS function is used incorrectly:Inputs to IFS() must be one or more condition-value pairs.”

Could you see the video?

This should show at the end

2X_c_cf3ab2aacdc845c961708a8fc22d271cc2511c0f.png
2X_c_cf3ab2aacdc845c961708a8fc22d271cc2511c0f.png347×683 14.7 KB

Keep in mind that the expression seems to work correctly, because the VIEW AND NEW buttons appear correctly, if it is a form it allows you to add a new record, and if it is in another view it does not allow it. The only problem is that for some reason it lose the reference to the next view.
A similar problem I am having in another app

[Strange behavior in SELECT () expression](https://community.appsheet.com/t/strange-behavior-in-select-expression/14978) Questions

I am locked in something simple: With this expression: SELECT (Repairs [Rep Id],[Withdrawn Date]>DATETIME ([Last payment]. [Date])) If I test the expression with the “Test” button, it correctly returns all Rep Id’s. In the Form view where I want to show it, you don’t see anything. If I replace the expression DATETIME ([Last payment]. [Date]) with a written date, it shows the list perfectly. [Last payment] is a virtual column with the following expression MAXROW (“Payments”, “_ RowNumber”), …

4

@Steve was giving you a suggested default condition like this

IFS(..., TRUE, "READ_ONLY")

Where ... was all of your other conditions together. In your latest post, taking your IFS() and adding the default line, it would look like this:

IFS(
“Form”<>CONTEXT(“ViewType”), “READ_ONLY”,
LOOKUP(USEREMAIL(),“Usuarios”,“email usuario”,“Cargo”)=“Administrador”,“ALL_CHANGES”, LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cambiar Contraseña”)=“Salir”, “READ_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Administrador”,“ALL_CHANGES”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargada”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargado”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Auxiliar”,“READ_ONLY”,
TRUE, “READ_ONLY”
)

1 Like
5

@Steve
I made all the recommended modifications:
With this expression it does not work:

IFS(
CONTEXT(“ViewType”)<>“Form”,“READ_ONLY”,
LOOKUP(USEREMAIL(),“Usuarios”,“email usuario”,“Cargo”)=“Administrador”,“ALL_CHANGES”, LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cambiar Contraseña”)=“Salir”, “READ_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Administrador”,“ALL_CHANGES”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargada”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Encargado”,“ADDS_ONLY”,
LOOKUP(MAXROW(“Ingreso”,“_ROWNUMBER”,true),“Ingreso”,“Ingreso Id”,“Cargo”)=“Auxiliar”,“READ_ONLY”,
TRUE," READ_ONLY "
)

With this expression YES it works:

IF(CONTEXT(“ViewType”)=Form,
“ADDS_ONLY”,
“READ_ONLY”
)

I even just noticed that Form did not put quotes, and it works the same way.
I used the first expression again taking out the quotes and it doesn’t work either.
It is caused by the IFS () or too many conditions, but it does not seem to be a syntax problem.

Some explanation?

Account ID: 461773
App: Fun Zone San Juan
Table: Recibos
Are update allowed?

6

TalkNet_TechnoStore:

TRUE," READ_ONLY "

If your IFS() statement was copy/pasted, you’ll need to remove the spaces within the quotes of the copied portion above - change it to TRUE, “READ_ONLY”.

1 Like