Update table using non key field
Is there at all possible that we could update a table using a non key field? The contents of the table are such that I could have one key field to deal with certain number of records maintained by us...
Forum Discussion
Using our Triggers for Quick Base add on you can update multiple records without having to know the value of any key field
heres a sample app to see how it works
https://juicedtech.quickbase.com/db/bnd44x9ee
Just add a new record in the Samples table...all Item records where the Type field matches the record you entered will be updated.
The keys in both tables were not changed, they are both Record ID#.
There is no physical relationship between the tables
https://www.juicedtech.com/juiced-cloud
heres a sample app to see how it works
https://juicedtech.quickbase.com/db/bnd44x9ee
Just add a new record in the Samples table...all Item records where the Type field matches the record you entered will be updated.
The keys in both tables were not changed, they are both Record ID#.
There is no physical relationship between the tables
https://www.juicedtech.com/juiced-cloud