ContributionsMost RecentMost LikesSolutionsRe: How to Keep HTML after Using Left Function to Produce Excerpt?You probably truncated a few HTML elements. Ensure you are only truncating on the Text part, not the entire formula contents.Re: Date Validation in multi line text field on SaveThe method is IOL (Dan's image on load). you can google it or search the QB community forumRe: Date Validation in multi line text field on Save1) Data validation 2) JavaScript 3) cleaner solution (best practice) but more work: Create a change log table (change log text field) and use automation to record a date change when users modify the field. This way you keep the field looking better for reporting and also you can add more fields to track as needed.Re: Ask Me Anything about the new Quick Base visual builderDavid, The Vsual-Builder is a great tool. May I recommend using the Visual builder to place items directly on the form? This will add huge value to building experience in Quickbase. Re: changing field types from user inputBen, I recommend that you explore using different fields and use form rules to use the proper field based on the SLA type. Then use formulas if needed to display your results and make data entry fields non-reportable.Re: changing field types from user inputMy Colleague is correct. field types are static unless changed in the field settings. You can only convert value types from other field using formulas: toText (Number) or ToNumber([a number stored in text field]).Re: Table to Table Relationships Many to OneCan you provide some screenshots? I'd also check formulas for errors and that you have admin access in both applications.Re: Table to Table Relationships Many to OneThis seems to be a permissions issue. Are you testing using the Admin role or a different role?Re: Suggestions for how to ""snapshot"" the databaseI think if you snapshot the Project table first, it will be better. In the snapshot, copy the Original Project record id. Then trigger a Copy Record action when a Record is Added in the Project Snapshot by looking up each Record in the Part table based on the Project Record ID. Re: Suggestions for how to ""snapshot"" the databaseHi Chris I ran into the same issue when building a snapshot table for multiple tables (and ironically, when a user switches phases on a project). My approach was as follows: 1) In the child table: create a formula field that is comma delimited that combines the columns (or the delimiter of your choice) with a newline character at the end 2) In the Relationship screen->Add Summary: Use the new Combined Text summary field to summarize the formula field for all the Child records to the Parent record 3) In the Parent table: Convert the Data to Text in another formula using ToText() 4) Use an Automation to snapshot the Value in a Text field in the Snapshot table. Now that you have a record or (metadata) of the related record of the child table, you can reconstruct them through string manipulations in a variety of ways using formula fields or Javascript. For my use case, I used javascript to reconstruct the data. Can you tell me more about the use case what you are trying to accomplish?