How to consolidate multiple rows into one
Hello, Is there a way to consolidate multiple rows into one row? I have Table A right now. The Site ID column is the key column for the table since it’s a numeric field with unique values. I know about creating a relationship and then creating a summary field but I don't think it would work in this case because I want to use the Account ID column to summarize instead of the Site ID column. The only columns I'm interested in are the ones in the red square. Basically, I want to extract that data and consolidate it using the Account ID field and then have all the different Account codes related to the Account ID in one cell (like Table B). I don't mind if it has to be in a separate table. Is there a way to do this? Table A Table B
Rich text lookup field not displaying correct when emailing a report
When I email a report from QB, I have a rich text lookup field that is not displaying correctly, it is showing the actual code: <span style='font-family: Gibson-Regular; font-size: 13px;'>Aviation and Occupational Medicine</span><br><span style='font-family: Gibson-Regular; font-size: 10px;'>6900 East 47th Avenue Drive<br>STE 100<br>Denver, CO 80216</span> (8 AP Invoice) Any ideas why or how to correct this issue?How to extract the URL value from a File Upload field
I'd like to get the actual file URL of a file uploaded to a File Upload field. How can I do this and display the URL in a form? My use case: Users can upload an image file. I want to display that image in an <img> tag in a rich text field in the form.If/then formula?
Need help with an if/then formula or what I assume is the best way to get the data I need. I have a vacation request submitted into one table that is linked to decision table that needs 5 signatures before it is approved. Currently, I have the status field in the vacation table that is: If([# of decision records] = 5, "APPROVED", "PENDING APPROVAL") Will this work per request? Or do I also have to include record# or something in the if statement. Thanks for any advice/help.
Average Rating of last 4 inspections/entries.
Is there a formula that can be used in a summary report to show the average rating of only the last 4 entries of a given part number? Current table is simple with 2 fields. A part number is selected through a relationship dropdown, then the selected part number is then given an inspection rating of 1, 2, or 3 based on inspection criteria, then saved. Background: I am attempting to setup the % of parts to inspect based on the average rating of the last 4 inspections. My issue lies in the fact that not all parts are delivered and inspected on the same schedule (i.e. weekly, biweekly, monthly, quarterly or biannually) so I am unable to use a time period to capture an equal rating across all parts. Without a formula that only captures the last 4 entries of a part number, I fear I will need to add and manage a dropdown of "delivery schedule" on 1000+ parts to allow filtering to capture the last 4 inspections completed. (or keep using the 15 spreadsheets that I currently track this information on) Any suggestions or work arounds would be appreciated. Thank You.
Embed Record Form
I have two tables (Table A and Table B) ---- the tables are not related.I would like to embed a specific record from Table B (using the old record form) into a record form within Table A --- Table B -- I have a number field called [Index]. The index field is unique but it is not the key field. The specific record from Table B I would like to Embed into a Table A form is where the Table B field [Index]=1 I assume I would need a URL formula field in Table A -- that has the "Embed as iframe in forms" checked. I need help with creating a formula that grabs the record from Table B where the [Index] = 1 Any advice is appreciated.
