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…
Solved! Go to 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
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.
Will surely share more details sir once I get back to my laptop…replying via my mobile now
Could you give me more detail on how to achieve this…
My use - case is as below,
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
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”
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.
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
Hi,
It should be in the parent table’s reverse reference list type columns’ show_if constraint property for respective child tables.
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…
can you guide as to where i have to put in the show_if constraint as mentioned by you…
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
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
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…
hope i am able to convey me need…
Hi @DPM_reports,
I believe we had discussed the similar topic in the post below. Did you get a chance to try that please?
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |