How do I connect team members to โjobsโ and vice versa?
Inside the โevents detailsโ is listed whoโs playing the event: Drums John Doe
Bass Jane Doe
How do I format it so the name inside the Event Details is a link to the personโs โcontact infoโ?
Also, how would I show the events that a person is booked on inside of their contact detail? Example: I click on my menu โBand and Techโ and its a roster of all my team. I click on John Doe and all his contact info comes up but also a link to the Events theyโre booked on?
Create a virtual column with all formula select(Events details[Events Name],[Name]=[_thisRow].[Name]).
https://help.appsheet.com/expressions/expression-types/list-expressions-and-aggregates
For the 1st questionโฆ if you could use a ref field from the contacts table, it would have the link automatically.
Howdy Aleksi! I need something very similar to this and need a little more guidance.
I have a Members Table and Members View, but I in this View, I only want to see basic Member data, Name, Address, Mobile Phone, and then just a Ref Link to their entire Row in Members Table/all of their Contact data.
I made a Virtual Column and entered this formula in the App Formula: select(Members[Name],[Name]=[_thisRow].[Name])
but get this error: โThe expression is valid but its result type โListโ is not one of the expected types: Refโ
It seems a Virtual Column is best here, because I really donโt need that [Details] column in my Spreadsheet. Thank you!
Wrap your SELECT() with ANY():
ANY(select(Members[Name],[Name]=[_thisRow].[Name]))
Note, too, that if the Name column of the Members table is not of type Ref, youโll need to change the type of your virtual column.
OK, cool, makes sense. Forgot about the โAnyโโฆDoh! Will report back, thanks Brosef!
OK Steve, my [Name] in my Members Table is NOT a Ref, so I changed my VC to Text and used that ANY(select(Members[Name],[Name]=[_thisRow].[Name])) formula. It works just fine, except in [Details] I now only see the Name of my member, which when clicked does indeed take me to that Memberโs Details, but it doesnโt have that intuitive little arrow that you usually see for a Ref to tell Users that this will take them somewhere else, to all contact data for that Member. I need to see that > arrow. I know this must be easy and Iโm a doofusโฆhaha. Thanks again!
So, now Iโm thinking Iโm an idiot, because I guess I really donโt need a Details Link/button here because I can just limit the data that is shown in my Members View, and if User wants to see all Details, they simply click on that persons Name. My Client has asked for a โButton/Linkโ to Member contact details because thatโs what he is used to in his legacy (=old, archaic, 1995 style ridiculousness) software. This might be a case of whatever you Pros call it when the new Dev gets caught up trying to deliver exactly what Client asks for, when, in reality, the Devs new platform/technology can do required function much better, but a little differently. I call it Shoehorning, when New Tech is ignorantly/arbitrarily forced into the Old Tech form becauseโฆstupid.
@Aleksi_Alkio What field should I create as a REF field? Thereโs no fields in EVENTS and BAND TECH that always match. My BAND TECH table is just an address book that hold all my employeesโ info. Doesnโt a REF field have to be a field that has the exact same info in each table/sheet?
This case is solved. The answer was a ref field for the employee column in eventโs table.
Thank you for the replies! Unfortunately, Iโm a little out of my league here. Iโm a noob and only understand basic stuff.
If anyone would be interesting in working on this with me Iโd be glad to talk and compensate time.
Iโm watching some APPSHEET videos and have a small understanding of references.
My Sheets are setup as such
Sheet Name: PHONE APP - which has all the event info (event name, venue, address, employees booked, misc details, etc)
TEAM - which has my roster of employees.
Iโm trying to connect these two so if i click on my ROSTER (named โBand and Techโ in my app), and I click on an employee, I can see which EVENTS theyโre booked on.
Alternatively, if Iโm in an EVENT, I can see the employees booked for the event and Iโd like to be able to click on their name and see their ROSTER card (all their contact info from the TEAM sheets).
I donโt really see any logical REF field between two sheets unless Iโm missing the concept of REF fields?
Can someone help?
User | Count |
---|---|
43 | |
30 | |
25 | |
23 | |
13 |