Update multiple records in one table with a record from a referenced table?
How do I do this? I have an “Item” table and a “Location” table. The location of each item is referenced to the location table. I have a lot of items. How do I update selected items in the items table with a location from the location table? I can do it one at a time, but I cannot find a formula or other way to do the updates all at once.
11 replies
-
You can do it with “Update multiple records”.
- Select and display the records of table “Item” that must be updated;
- “Update multiple records”;
- select “Assign calculated value” for the reference field (“Location” if not renamed);
- in the formula field, put something like “(select Location) [field = value]”
-
I cannot make that work. I No matter what I enter for “Assign calculated value” I always get empty as the results. Can you see what I might be doing wrong?
-
-
-
I give up. This forum is so horrible. All I want to do is get help. I can“t even upload a simple screenshot. Ninox FIX THIS!
-
The purpose of the select command is to get a handle to the desired record in table “Location”. Another solution is to look up the ID of the desired record, and to put in the formula filed: record(Location,<value of the ID>).
-
I asked this question today on the Open Office zoom meeting. Maria showed me the super simple solution and it works! Crazy how simple it is. Find the ID number of the record in the refernced table that is the updated info and type that # alone in the Update Multilpe Records Assign calculated value formula. Perform the update, and all fields in the first table are updated. Perfect!
-
Very interesting. I just checked, and this trick also works in an assignation in a script. So a record handle is not required, but just the record reference number suffices. Wich makes sense if you think about it since the reference field already contains an implicit reference to the correct table. Good to know…
-
I think Maria said this ID # formula works with hte app but not with a browser.
-
It works in the browser as well.
-
Good to know. Thanks. I may have heard her wrong, but I will let her know next time I speak with her.
Content aside
- 3 yrs agoLast active
- 11Replies
- 1677Views