TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Allow multi-record button with reference field
I would like to edit multiple records and set a reference field. This is not possible. However, I think it would be a great enhancement if the conditions used for the selection match, that you can set a reference field too on multi-record.

Date Created
2/14/2018 6:18:09 PM
Date Updated
2/14/2018 8:25:54 PM
New Idea
Promoted By
cooper collier Kim
cooper collier  2/14/2018 6:39:22 PM
I cannot be 100% certain of your situation. But I have managed to make records in multiple tables that are linked from a button or even a trigger. I would be happy to take a quick look and show you the secret.
Not tonight but tomorrow would be ok.

I am on Pacific time.
Kim 2/14/2018 6:43:59 PM
This is about a custom button, set to multi-record, with user input set including a column that is a reference. As soon as that selection, or that reference, uses any fields for filtering or matching, it doesn't work on multi-record anymore.

For example, let's says I have a 'Customer' table and a 'Cities' table. And the City reference depends on the Customer Country (strange example, but okay). Then, even if I only select Customers from the same county, the multi-record edit for Customer City does not work.
cooper collier  2/14/2018 7:46:19 PM
I am trying to wrap my brain around it, some things just cannot be expressed easily in a text only box.
What I have done in the past, working on a difficult issue.

I make a new sample database.
Slam in just a couple tables with just the bare minimum of columns to duplicate the specific issue. Then I show that to my co-programmer or teamdesk support.

If you can you may want to do that, then you can invite me to the sample and I may understand what you are facing better.

There may not be a solution. But we all may get lucky.

Kim 2/14/2018 8:14:52 PM
I have a table with a reference to a Colors table:

The colors table has two columns, primary and secondary color:

When I edit an individual record, I can edit the secondary color, based on the primary color:

Now, if I create a multi-record button to edit that secondary color:

And try to edit two records (that have the same primary color):

It doesn't work:
cooper collier  2/14/2018 8:18:58 PM
I see, can you give me a temporary invite to that database.
or make a copy, delete any non relative tables and records and invite to that?

You can email me directly if you need as well.
Kim 2/14/2018 8:20:44 PM
I think I can make the example even easier. I've invited you, but I'm tweaking it.
Kim 2/14/2018 8:25:54 PM
I just removed the filter on the reference, and then it works for multi-record. It's only when the possible values are dependent on the records you're editing that it doesn't work.
Back to Search Results