Hi,I have a view that is taken from a slice of the main data, what I would like to do within that view, is return, only an exact match for the term that the user has searched for, however before the user has searched, I would like a blank screen.Is t...

Hi, I am creating 3 forms for my app, they are consignment, Collection and DeliveryAll three will have the same unique reference or Job ID so they can be linked later, what I want to do is create a three-part form, where the user automatically has th...

Hi,I am hoping for some help. I have two sheets,. One called PostCodes and One called Zones.Each Postcode is assigned a zone, and each zone has a delivery date. In the postcode view, I want to view any dates from today onwards, as each zone will have...

Hi, Apologies if this has already been asked, but I am unable to find an answer. I am trying to create an app for a courier, they can have multiple drops per driver and these will be added in no particular order.We have a required collection / delive...

Hi, I have a script using the onedit trigger within google sheets, which does not trigger when Appsheets edits a cell. I have read a few topics that suggest to use onChange rather than onEdit, however my script uses events to determine what cell it n...