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.
Converting the existing column values into upper case
Hello All, I need a help with formula for converting the existing records to upper case and also want to put a check which converts new entries to standard format. I have a Name field where some entries are lower case, some upper case, some with space and extra. I want to make sure 1.That all the names are converted into upper case. 2.Whenever a new entry is made, even if it is done in wrong format it gets converted into standardized format. Currently when I am trying, to use this from advanced settings, no field is getting converted to upper case, and also checking the " Turn custom data rules on" option it is restricting me from adding any new records. Can someone please guide me on how I can achieve the above result, please
