May 20, 2020 09:20 AM
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
Solved! Go to Solution.
May 28, 2020 07:17 AM
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.
May 28, 2020 07:29 AM
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
May 28, 2020 04:55 PM
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!
May 29, 2020 02:56 AM
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
Jun 02, 2020 05:41 AM
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.
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.
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.
In the case I need to incorporate some internets and update the list of festival. How can I share only that view?
best
Cristina
Jun 02, 2020 07:46 PM
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:
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.
Jun 04, 2020 04:22 AM
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?
Jun 04, 2020 09:27 AM
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!