REF ROWS question. Hi - I have 2 linked table...

(Jim Pettipher) #1

REF ROWS question. Hi - I have 2 linked tables. Table 1 is a list of Fishing Trips, table 2 is a list of related Fishing Activities where a trip can have many activity rows.

I have 2 forms - one to add a new trip (which works fine) and another to add a Fishing Activity to a Fishing Trip.

For the second form, I want to be able to select from the list of Trips to add an activity to that trip. I can do this but the Reference Field (Trip_ID in the screenshot) defaults to a List of Vessel Names (PLN_Vessel_Name in teh screenshot) but I want it to display a list from a Virtual Column (a concatenation of Date and Vessel) Date_PLN_Short_Name in the screenshot.

So how can I get the linking column list to display a different list? Or is Appsheet smart enough for me just to use one form and if so what is the best way to do this?

Screenshot attached which may help - thanks in advance for any pointers or help James

(Aleksi Alkio) #2

You need to change the label column in your “Fishing Trip” table.

(Jim Pettipher) #3

@Aleksi_Alkio Thanks Aleksi - I tried to change the label to the virtual column and it didn’t work - I assume that a virtual column can’t be a label?

Anyway, I worked around the problem by creating a new column in the Trip table that concatenated the date and the vessel and then gave this the label.

Many thanks for the quick response.

(Aleksi Alkio) #4

You can use virtual column as a label. Check that you don’t have any other columns for that.

(Jim Pettipher) #5

Hi Aleksi - quick supplementary question if that’s OK

Label now working on the right column (thanks again) - I just want the selectable

list of trips to be ones that have a Trip Status of “In Progress” (Column in the Trip table)

I have tried using 2 slices (Trip and Trip Activity) which only show Trips that are In Progress - the slices seem to work fine and both my forms are pointing to these slices. However when I want to add Activity to a trip I still get a list of all the Trips, regardless of whether they are In Progress or Closed. Any pointers appreciated.



(Aleksi Alkio) #6

You can add a Valid_If expression like SELECT(FishingTrips[KeyColumn],[Status]=“In Progress”) for that Ref field.

(Jim Pettipher) #7

Thanks Aleksi