Lookup formula or anything similar

AppSheet AppSheet Q&A
1

Hello guys

I have two tables which are “schedule” and “assessment”. in table “schedule” there are two columns namely [id], [start date] and one virtual column with list type [related assessments]. In table “assessment” there are three columns namely [id], [schedule], [entry_date]. [schedule] is ref type column from “schedule” table.

i would to know how, when user input date manually on [entry_date] column, [start date] column will autofill with [entry_date] value. Thank you very much for your help.

cc: @Steve

2

LOOKUP does not work because your schedule has many related assessment rows and cannot identify which row’s [entry_date] to use.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Using-INPUT-to-update-another-table-using-a-value-from-this-row/m-p/328992

should give you what you need to do.

With this approach, whenever a user enters [entry_date] in assessment table then the very last entry will overwrite [start date] in schedule.

2 Likes
3

thank you sir

1 Like