I want to make an application to show the lastest date from maintenance history in spreadsheet. here is my spreadsheet: [image] if i entered the serial number, then I can display data on the last date of the tool's maintenance history. example, i entered a serial number: 04018438LF. After I pres…

You can use gviz query to do all of this in one hit. https://docs.google.com/spreadsheets/d/<SHEETID>/tq?tqx=out:csv&headers=0&gid=<GID>&tq=SELECT * WHERE B contains '<SERIAL>' ORDER BY A DESC LIMIT 1 Here colA is the timestamp, and colB is the serial note the use of &headers=0 to prevent the hea…

Get the lastest date history from spreadsheet data

MIT App Inventor Help

ABG August 10, 2024, 11:12am 3

1 Like