HolliMills
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Using a relationship to join two tables.
Yes, there are a combination of text fields that I would like to use as the key field. However, I have to concatenate them in order to get the unique identity. And, I know that you can't set a formula field as a key field. I could concatenate in Excel before uploading into QB if that is necessary. --15Views0likes1CommentUsing a relationship to join two tables.
I have two tables that I would like to join and then only show me the differences between the two tables. Basically, the two tables have all the same fields and have a lot of the same data. I get a new dataset each month that updates data for existing records and adds new records. Everything I can find points towards using a relationship to make the join. Would the table I intend to be the joined table be the parent table? How would I effectively identify the differences between the two tables and only display the records that are either new or updated? Is this possible in Quick Base? Or, would the most effective way be to join the two tables and MySQL and then upload the resulting dataset into Quick Base? ------------------------------ Holli Mills ------------------------------20Views0likes3CommentsDebugging HTML Code on Code Pages
Hi, I am trying to create an HTML page, and I want to be able center my text and image on the page. I am a beginner with HTML, and the code I found online isn't working for me. Here is entire code for my page, with the image and text I want centered highlighted. For the image, I used margins and padding to get it where I wanted it, but from what I understand that will look different on different screen sizes. Additionally, here is screenshot of what I am getting. <!DOCTYPE HTML> <html> <img style="padding-bottom: 8px; padding-top: 200px; margin-left: 615px;" src="https://opcrh.quickbase.com/up/bpqr5rezh/g/rb/eh/va/PCandRH_color_horizontal%20TRANSPARENT%20BKGRND.png" width="500"> <head> <title> <span style="text-align: center;">OPCRH Health Workforce Coalition Survey</span></title> <body style="background-color: #bfd4c4;" > <h1><span style="text-align: center;">Thank you for submitting your Health Workforce Coalition Survey</span></h1> <p><span style="text-align: center;">Please contact Ashley Moretz if you have any questions at amoretz@utah.gov or 801-273-6605</span></p> <br> <h3><a href="https://ruralhealth.health.utah.gov/"><span style="text-align: center;">Click here to return to the Office of Primary Care and Rural Health Website.</span></a></h3> </body> </html> I would appreciate any suggestions on this! Thanks. ------------------------------ Holli Mills ------------------------------5Views0likes3CommentsMultiple look-up fields in a many-to-many relationship
I have created a many-to-many relationship with Committee Members and Committee Meetings as parent tables. The child table is Meeting Engagement. I would like to be able select all committee members that attended a meeting in the Meeting Engagement table from the Committee Members table. I created a look-up field for committee member in the Committee Engagement table, and then duplicated it for all committee members. However, when I choose a different committee member, in a different field, all the other committee member look-up fields change to the one most recently selected. Is what I want to do possible?0Views1like0Comments