Solved: Being in list an ordered list - Page 2

manueurofax · 08-25-2023 06:14 AM

HI,
I have a field that fetches a list from Table A. But the field from which the list is in Table A is in turn linked to a Table B which has a base list of values. When I get to add in Table A a value from Table B, I find in the Form that Table B's list is sorted based on the insert and not some specific sorting I would like. It's normal? or can something be done that Table B's list looks sorted as I would like...

manueurofax

To close the circle (as they say in my part) to this discussion I will make a summary ...
Based on the link https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Referances/m-p/324589, which was given to me I managed to achieve what I wanted...

Brief outline of the Tables:

Table A with the field [NAME A] (assignment of tasks or other to names). This field retrieves names from a field in Table B...

It is set with the following properties:
Type = Ref

Source table = Table B

Valid If =

ORDERBY
(
 ElencoB[NOMINATIVO B],
 [NOMINATIVO B]
)

Table B with field [NAME B]

Table B brings together some names taken from Table C register, chosen for a specific engagement (Table A would have multiple fields set up as [NAME A], each linked to its own group and organized by days/week/month).

At this point the same formula would suffice for the field of Table A...
But I would like that when new names are added in Table B they are considered the only registry list of Table C, and in showing them I would like those who have not yet been chosen for Table B to be listed and above all in an order that I want, and here is the difficulty (I always got a list in order as the names were entered)...

But with the following formula always in the Valid If property I solved the problem (I tried several times but I failed, and I also tried with the Formula Filter instead of Select but it didn't work in the OrderBy formula)...

ORDERBY
(
 SELECT
 (
  ElencoC[NOMINATIVO C],
  COUNT
  (
   SELECT
   (
    ElencoB[NOMINATIVO B],
    [_THISROW-1].[NOMINATIVO C] = [NOMINATIVO B]
   )
  ) = 0
 ),
 [NOMINATIVO C]
)

This is everything...

Thank you always for the attention you show me...

PS. I apologize for my English, but I don't speak and write thanks to the great Google Translate...

View solution in original post