Steven
December 10, 2020, 5:04pm
1
I am looking to solve a scenario where I populate a database without creating duplicates, here is the use case…
I have two databases, 1 for Repair Claims and the other for Equipment Make & Model.
Use case is…
User submits repair claim form that has text input for Make and Model.
Upon submit, IF Computer Make & Model does NOT exist in Make and Model spreadsheet, then create a record for that Make and Model.
Otherwise, IF Computer Make & Model does exist, DO NOT create a Make & Model record.
Again, the purpose is to build the spreadsheet in time but also prevent duplicates. Any suggestions?
You could use a UNIQUE formula in the Google sheet to dynamically build the list in the Make/Model sheet based on the data in the Repair Claims sheet.
3 Likes
Steven
December 11, 2020, 1:38am
4
Jeff, do you have an example of the UNIQUE formula? To build the list of make/model…
Here’s an article you can read through.
4 Likes
Let us know if you need help with this!
1 Like
Steven
December 11, 2020, 1:52am
8
Your article worked perfectly. Thank you so much!
2 Likes
Steven
December 11, 2020, 1:54am
9
@Mark Do you know if it is possible to use the UNIQUE formula (the one in Google Sheets) in Glide tables?
I’m not aware of a way to dynamically build data in a sheet based on another sheet. I would love that option since a large part of my app is centered around the UNIQUE formula to build it.
1 Like
Mark
December 11, 2020, 2:01pm
11
Couldn’t you do a relation to the Make and Model, and if the relation is empty, add the row?
4 Likes
Steven
December 11, 2020, 3:34pm
12
@Mark Yes, I believe that would work. Thank you so much!