I am 99% sure I want to split my registry table into 2 tables with the only differences being the app status (pending vs complete) and assigned evacuation center (pending has no assignment).
Reason is our hurricane Irma exp and having 800+ people hit our system last min…a flood of pending could cause us to hit our sheet limit.
So my question is can I create a search view that would locate a person’s name in either table? Can the magnifying search be edited to do this or would I hide that and have a totally separate search view? But could this work the same…ie search either first or last and not require exact match?
Also can appsheet prevent duplicate entries (based on name, dob, or phone combi) or would I need to do this in my source table application?