Help

LInk to another record

Topic Labels: Formulas
Solved
Jump to Solution
5803 17
cancel
Showing results for 
Search instead for 
Did you mean: 
Cristina_Moreno
4 - Data Explorer
4 - Data Explorer

Hello, can I join three fields un one?

I want to mix three fields in one automatically. Is that possible? I dont know wich rule I have to follow.

In A I have different categories (A) which belong to another column (B); and I want to mix in a third field the categories which are the same. Is that possible?

A: blue B=house;
C= Carla=blue+ 13yearsold

😧 I want to mix in other names in C, the words that are the same.

thank you
Cristina

17 Replies 17

Sorry for the confusion. That screenshot I posted was the expanded view of that formula field. That shows what the formula created for a single record after I’d finished writing the formula. Like I said, the Formatting tab in the field properties won’t work when we’re outputting text. It only formats numbers and dates.

It looks like my text description of the setup is causing more confusion for you. I’ll record a demo video of the process and post that later today, which should (I hope) make things more clear.

Hello Justin

that would be lovely. Could you record me a video of the whole process? I promised I tried to follow your instructions, but some of them I get stucked.

Do not worry, if you need more time you can send me at the end of the week.

THANK YOU THANK YOU THANK YOU

Cristina

I just sent you a private message with a link to a video where I walked through the entire setup. If that helps you, please consider marking my comment above (the big one where I typed the instructions for the same setup) as the solution to your question. This helps others who may be searching with similar questions. Thanks!

Hello Justin

sorry to delete some post. I dont mind to share everhytihg, but I should use another example of the films , like Film 1 Film 2 Film 2. I through at first that if I answered it will be directed to you, instead of the whole community, sorry for misunderstood that.

I will type again in my reply your solution, but maybe not showing the titles if you dont mind?

I will watch it carefully the video this weekend. In case I have any comment can I still asking you?

have a great day
Cristina

Cristina_Moreno
4 - Data Explorer
4 - Data Explorer

Hello Justin, I hope you are okay. Please confirm if you understand what I want to achive. your video was amazing. And I am pretty close to achieve what I want.

  1. In the first table, Festivales, how can I see all the films that I submitted? I use this table to guide in my submission process.

  2. I dont know how to many the submission of several films in one festival. If I am right your video shows: Collecting info for all festivals for a given film. And my goal is to submit several films to each festival. Not al films goes to the same festival. This process I do it manually.

  3. In the case I need to incorporate some internets and update the list of festival. How can I share only that view?

best
Cristina

The link field on the [Festivales] table contains all links to all films submitted to that festival. However, looking at them in the link field itself may be tough to read. One way to make a cleaner list is to add a rollup field. It should use that link field automatically (unless you made another one), so all you need to do is choose the target field to roll up, which would be the {Film} field, and then an aggregation formula that takes all of those film names and lists them on individual lines:

ARRAYJOIN(values, "\n")

As I pointed out in our side discussion, each record on the [Films at Festivals] table will connect one film to one festival. To connect that same film to another festival, add a new record for that pair.

Here’s an overview of view sharing:


If your question is about collaboration in a shared view, I recommend starting a new thread, as this one has primarily been about linking records between bases.

On that note, if you feel that my base breakdown above addressed your core question, please mark that comment as the solution to your question. That will help others who have similar questions.

Zeena_Hassan
4 - Data Explorer
4 - Data Explorer

I am trying a similar exercise and hitting a roadblock. I created a full data tab and when i make updates to it - i would like the other tabs in my base to update. How do i go about doing this?

Welcome to the community, @Zeena_Hassan! :grinning_face_with_big_eyes: Sorry to hear that you’re having issues, but would you mind starting a new thread for your specific question, including more details about the setup of your base? It’s easier to track than having your issue as part of someone else’s thread.

@Cristina_Moreno It looks like you marked the wrong comment as the solution. I was referring to my earlier comment where I gave the detailed breakdown of the system. Please switch the “solution” marker to that one when you have a moment. Thanks!