i have a table where the child table data is captured in the parent table via isapartof …
i want to know is there a way we can change the child table appearing based on the status of a previous entry…so that when i click retail…i get retail child table…when i click distributor…i get distributor child table…
In general, if the child tables are belonging to the same parent table , then I believe you could have an enum button in the parent table that has options like retail, distributor etc. You could then use enum options of that button in show_if constraints of the list type reverse reference columns for those child tables.
You may wish to share more details if you are looking something in specifics.
Could you give me more detail on how to achieve this…
My use - case is as below,
My user enter details regarding type of customer met,
then he selects the type of customer…i.e. Retailer, Distributor, New Customer etc…
based on the above selection which would be a enum list, i want the child table that each of the types as in point 2 (each of the type have separate sheets) has to be displayed.
i.e. when he selects retailer, the child table appearing below has to be retailer,
if he selects Distributor, the child table appearing must be distributors and not of Retailers… like in screenshot below, I want this table in mine show depending on the enumerated list I create before the table
Reverse reference columns are automatically created by the app editor in the parent table, whenever you create a reference to the parent table in any other (child) table. These are virtual columns of list type. Please go through the following article and especially section “Reverse Reference”
In the example shared by you from the sample app “Order Capture”, “Order Details” is the reverse reference column in the parent Orders table. You can have expression in the Show_if column of this Order details column in the parent table. For example [Order Status]= “Complete” or in your case , [Customer Type] = “Retailer” , if [Customer Type] is an enum type column.
Do you see following columns at the bottom of parent table 's (The table name “Data” in your shared sheet) column list under option Data-> Columns in the app editor
Please have expressions in Show_if constraints of those columns
Could you please add which date change you are looking for in the example- Order Date or Delivery Date? And what you mean by change? I mean what condition you have in mind to signify change of date - change to a particular date- say month end, week end or later or earlier than today
i want to remove the add button in the child table after a certain condition is met…like for instance for a particular row as in the screenshot order date…when order date is today…i want the add button to be showing…but when calender date changes and the order date is yesterday…i dont want the add button to show in the child table…