Re: [SOLVED] Help With Staging A Base
Hi
Thank you for your reply.
I have been trying to get the Checkmarks showing (linking) and it’s still not working. I have imported the CSV file first, I than created the field ScottFixed field and copied and pasted the the formula: SUBSTITUTE({SCOTT#},’\n’,’’) into the Formula field. I added this field from the last reply:
“OK, for the meantime, you can create a field called ScottFixed. Give it the formula
SUBSTITUTE({SCOTT#},’\n’,’’)
(It appears the extra characters are newlines.) Change {DupeCheck::SupeMatch} to roll up {ScottFixed} rather than {SCOTT#}. You’ll still get 100% duplications — but that’s correct, as I see you’ve entered the values twice to force duplicates.”
Then I created the second table SupeMatch. I then proceeded to link both tables, I created the Dupe? field as Rollup: SupeMatch (link), DupeMatch (Rollup) then I copied and pasted the formula: IF(FIND(’|’&{SCOTT#}&’|’,values&’’,FIND(’|’&{SCOTT#}&’|’,values&’’)+1)>0,‘ :white_check_mark: ’) into the Rollup dialogue box.
but the SupeMatch field shows, in table 1, at the last field, but with no Checkmark, nor checkmarks in Dupe? field.
I than proceeded to go to table 2, which I set the three fields up already: Name-text, Imported table-link, DupeMatch-Rollup (Imported table, ScottFixed, formula: ‘|’&ARRAYJOIN(values,’|’)&’|’ into the Rollup dialogue box.
but all I got were two vertical lines in the 3rd field, (DupeMatch) so I don’t know why it’s not working. Could it be the set-up sequence?
I also was not sure about what table to select when setting up the links i.e. Name of linked field in table 1-Importrd table, select-Imported table, Table 2-name of linked field-DupeMatch selected-DupeMatch.
You also mentioned about the length of the Scott#/ScottFixed field, could I do something to correct it?:
“Somehow, it seems your imported table has some sort of control character flanking {SCOTT#}; if I do LEN({SCOTT#}), the seeming 3-digit values have a length of 5; 5-digit a length of 7. It could be a line-feed or newline character. Not sure where it came from.”
Now, if I can get those checkmarks showing I will be on my way, since I now understand how this table works, I am also a bit new working with Airtable, eventhough I enjoy learning new things and linking and rollups are new features for me. :grinning_face_with_smiling_eyes:
PS I have since learned, after writing this initial reply, that I need to link individual records from one table to another, so do I first select the Dupe Check field, in the 1st, table, then select the option “Link to record in the Imported table” link, or do I go to the 2nd. table and select Imported table Field and select “Link to a record in the Dupe Check table”? I’m not quite sure.
I have attached screenshots, illustrating the above paragraph:
Thank you.
I’m not an expert on this particular problem, I’m just following it because I’m interested in the method and, a little bit curious too :yum: …
I think, for this to work, @W_Vann_Hall gave you the answer :winking_face:
Creating a Linked to record type of field when you want to link 2 tables is not enough :winking_face:
You need to tell to Airtable what data (what record) needs to be linked between table 1 and table 2, otherwise, the Linked to record field stays empty, as it links « nothing ».
This means that you need to tell Airtable to link a record from table 1 to another record from table 2 .
Metaphorically speaking, you can see the Linked to record field as a bridge between tables and the active linking of the records as you, actually saying what cars can use this bridge.
As I know, linking « things » in Airtable can be a bit confusing at the beginning, you could try to link one of your stamp to « where it needs to be linked » using the expanded view (instead of the grid view) of the record :winking_face: .
I’m just saying that because I think it’s a little bit clearer in the expanded view than the grid view « at the beginning » and it helps to understand how linking record works :winking_face: …
(Maybe you already tried, I don’t know :winking_face: … It’s just an advice :winking_face: )
Going through the base you shared above, in the expanded view of one of your record in the [Imported] table, you find this
And I think that this is where the magic happens :winking_face:
(I don’t know if the base you shared with us above is still up to date though)
But I’ll repeat myself, I’m really not an expert on this method as I never tried it :winking_face: .
So this may be just a stupid but plainly assumed comment :winking_face:
Hi
I have an update from my previous reply.
I was checking the base that was created for De-duplicating Routines and I was comparing it to the base that I created and I noticed that I did link the two bases and all the records, but for some reason the checkmark is not showing in the 1st field of the second table (Dupe Check table), but it does show for all the records in the Dupe? field in the first table.
I took screenshots of the same, but from different databases. The first screenshot is my base and the second screenshot was the original base, so I don’t know how to correct this. In my previous reply, #18, i wrote the sequence setup that I used.
Thank you.
