How can I make an inline not editable? For example: Once an order with several items was delivered, it should not be possible to modify the products, not the quantities. Is there a way to configure an โedit ifโ for an โinlineโ frame?
Hi Alfredo,
I think if you put an Edit If on the columns Products and Quantities something like this:
Edit_if = [Status]<> โDeliveredโ.
Assuming you have an order status column and โDeliveredโ is one of them.
This will allow you to edit these fields as long as the status is anything but Delivered. Hope this helps.
mj
Alfred, that warning tells me you already have an app formula for that column.
Can you tell me what the existing formula is in that column?
Is the REF_ROWS fรณrmula that automatically generate the app to show the inline
Sorry, I didnโt realize that one of your columns (looks like product) was a Ref column to the product table.
You canโt put any column constraints in a Ref column.
I wonder if there is a way to make the view read only when the status = Delivered.
Let me take a look at that option.
There has to be a way to convert the inline into read only โฆ but I can not find it
Letโs see if Aleksi has some idea.
ALEKSI โ could you help Alfred with this one?
Creating a slice with read-only mode and switching the REF_ROWS expressionโs table to this slice will possibly solve it
I did that but it returns the following warning: "Column name โArticulosโ cannot use an edit if constraint if it has an app formula.
The edit if constraint will be ignored"
Sorry, I didnโt realize that one of your columns (looks like product) was a Ref column to the product table.
You canโt put any column constraints in a Ref column.
I wonder if there is a way to make the view read only when the status = Delivered.
Let me take a look at that option.
There has to be a way to convert the inline into read only โฆ but I can not find it
Letโs see if Aleksi has some idea.
Hi Alfredo,
I think if you put an Edit If on the columns Products and Quantities something like this:
Edit_if = [Status]<> โDeliveredโ.
Assuming you have an order status column and โDeliveredโ is one of them.
This will allow you to edit these fields as long as the status is anything but Delivered. Hope this helps.
mj
Creating a slice with read-only mode and switching the REF_ROWS expressionโs table to this slice will possibly solve it
@Levent_KULACOGLU I believe that wonโt work because then you would not be able to fill the original record in the beginning.
@Alfredo_Pou You could add a formula NOT([STATUS]=โDeliveredโ) for EDITABLE_IF on the products table. If you have lot of fields on that table, you could create a virtual column (Y/N) with the [STATUS]=โDeliveredโ and then use that answer where ever column you want as Valid_If. If that validation is not TRUE, you canโt save the product.
I did that but it returns the following warning: "Column name โArticulosโ cannot use an edit if constraint if it has an app formula.
The edit if constraint will be ignored"
ALEKSI โ could you help Alfred with this one?
Trying to implement this I realized an error. And that is actually that โin lineโ must correspond to a Slice and not the original table because there are fields that are filled at the time of loading the order and other fields that are filled at the time of delivering the product, and should not be in sight. Besides that the slice allows me to change the order of the fields according to the importance in each form. Then I create a new detail view of the slice where the items to be delivered are loaded, but I do not know how to assign it to the order loading form where this โin lineโ is inserted. In the views once created it does not allow to reassign the table, and in fact this โin lineโ view was created by the system. References between views are created automatically. How would I have to do so that when loading an order, and then select New in the In line, open the form of the slice instead of the original table?
You can create an additional virtual list for your Order table. When you have two virtual lists, you are able to play with the Show_If optionโฆ when itโs a new order, show the original inline table, when you are modifying that order, show the slice inline table.
Thatโs what I was trying to do, but I do not know how. Iโm looking in the help and in google to create virtual list, but I can not find anything, all the results speak of virtual colmns. Could you give me a link to some document about this topic?
You can read the existing status with a formula IN([KeyColumn],TableName[KeyColumn]). If this is FALSE, it means that itโs a new record.
What I did not understand was this: โYou can create an additional virtual list for your Order table. When you have two virtual lists, you are able to play with the Show_If optionโฆ when itโs a new order, show the original inline table, when you are modifying that order, show the slice inline table.โ
How do I create a virtual list? I did not find documentation about virtual list.
Itโs the same virtual field you already have when you made a ref field. You can call it as inline field as well. If you open that field, you will see a REF_ROWS expression (app formula). Copy that formula and add a new virtual column and paste that formula with the slice name, and now you should have that virtual list column.
Alfred, that warning tells me you already have an app formula for that column.
Can you tell me what the existing formula is in that column?
Is the REF_ROWS fรณrmula that automatically generate the app to show the inline
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |