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 |