Is there a way to change the way we view child table

[DPM_reports]

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…

[Suvrutt_Gurjar]

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.

[DPM_reports]

Will surely share more details sir once I get back to my laptop…replying via my mobile now

[DPM_reports]

Suvrutt_Gurjar:

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,

1. My user enter details regarding type of customer met,
2. then he selects the type of customer…i.e. Retailer, Distributor, New Customer etc…
3. 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

I am not understanding your reverse ref. type…

Please Help

[Suvrutt_Gurjar]

DPM_reports:

I am not understanding your reverse ref. type…

Hi @DPM_reports,

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”

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

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.

[DPM_reports]

this show_if constarint should be in which table the child table…is it…where i have selected the column value isapartof…

if not where to mention…pls guide me

[Suvrutt_Gurjar]

Hi,

It should be in the parent table’s reverse reference list type columns’ show_if constraint property for respective child tables.

[DPM_reports]

i am not able to understand…

for ref. here is the link to my Google sheet…
in this the data clumn is my parent sheet… and the remaining 2 are my child tables…

docs.google.com

Test Sheet

data Name,Type of client

can you guide as to where i have to put in the show_if constraint as mentioned by you…

[Suvrutt_Gurjar · Accepted solution]

Hi ,

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
Related Realtors
and
Related Distributors

Please have expressions in Show_if constraints of those columns

[DPM_reports]

Just one more info required…

How can we stop the add/new button from appearing after date changes so that no new entries are made in this

[Suvrutt_Gurjar]

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

[DPM_reports]

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…

hope i am able to convey me need…

[Suvrutt_Gurjar]

Hi @DPM_reports,

I believe we had discussed the similar topic in the post below. Did you get a chance to try that please?

Removal of add item column after order status changes Questions

Hi i created a copy of the order capture app, and have also enabled Completed orders in the view. I want to remove the add item below the virtual order details column after the status is changed to complete , so that no one can manipulate completed order. Please help me in this regard [image]