The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have two tables: Tenders and Companies. Each record in the tenders table is a tender (contract) between a governmental entity and a company. The tender table has a column "keyword" which is a way to group similar tenders.I'll try to explain my prob...
I'd like to count how many linked records have occurred with another linked record. I have a table where each record is a contract between a company and a governmental entity. The company's column is a linked record and the entity's name is also a li...
I have three tables. People, Companies and a junction table. The junction table shows the relationship between a person and a company. Sometimes, a person is connected to several companies. I’d like to show that relationship. For example,
This is Peo...
Hi,
I’m having an issue with linking two tables together. I have a ‘Companies’ table and an ‘Employees’ table. In the employees table I have a column named ‘Job Title’ in addition to the column linked to the companies table. My issue is that sometime...
Hi,
I have a fairly large database and I was able to build an app based on it. My app is getting attraction thankfully but I have an issue that, if persists, might turn the app useless!
The database is in Arabic and performing search in Arabic in Air...
This approach worked for me. But how would the formula change if the "item" column also takes more options?To elaborate, I have two columns: Companies and Keywords. A have 'combined' formula column in the following format: "Company - Keyword". Someti...
Got it. I can see the benefits of using a junction table. But I'm struggling to see how it would get me to the main piece of data I'm trying to reach: what companies won the most tenders in each keyword and how many tenders they won?With the approach...
Hi Scott, Thank you for tour response. But even with many to many relationship I still need to create columns thst counts a company’s tenders for each keyword. Could you elaborate on how that would solve the issue?
Thanks Adam.. The thing is, I have 74 entities so I don't want to create as many columns.But I think the script approach is the best. The problem here is I don't code JS.
Here is my use case:
I have a companies table. For each company, I list high level employees of this company (Founders, board members, executives…etc)
Sometimes, a person is a board member in both companies. At least where I am from, this is a connec...