
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 15, 2021 12:31 PM
Hi everyone,
I have a record called “projects copy” (its just a duplicate name) and I’m pulling projects which are linked to a member’s memberstack ID. I also have a table called “members”
The members table also contains this memberstack ID.
I would like to automatically update the “projects copy” table in other columns with the information from the “members” table, so that I can bring in their profile information, like picture, slug, username, email, etc.
How can I do this?!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 15, 2021 03:37 PM
Instead of copying the values of several fields from one table to another, you should link records in the [Projects copy]
table to records in the [Members]
table.
FYI: Since it seems you’re going to have several projects per member, the {Memberstack ID}
should not be the primary field in your [Projects]
table. You will almost certainly benefit from making the primary field list the actual name of the project.
If you’re deadset on using {slug}
as the primary field in the [Members]
table as opposed to the {Memberstack ID}
field, you could set up an Automation to do the following:
- Trigger when a
[Projects]
table record’s{Memberstack ID}
field is updated - Include a
Find records
action step that searches for[Members]
table record where the{Memberstack ID}
field matches the value for the trigger record from[Projects]
table. If more than one, or less than one record is found you may run into issues with the following steps. - Include a
Update record
action step that updates the trigger record from the[Projects]
table by inserting the of the record id found in that^ step into a LinkToAnotherField-type field connecting to the[Members]
table. - Convert all your
{Picture}
,{Slug}
, etc. fields into Lookup fields so they can automatically pull information from the linked[Member]
record.
