Summary: Column type that would copy a value instead of referencing it All column types in Glide are a reference to an another value somewhere in the sheets. If the source cell changes it updates across all other cells/columns accordingly. How about the ability to ‘copy’ the value at the time new …

[image] Jeff_Hager: This could probably be done. You would need to create a relation from the user profile to the orders. Not quiet correct, so this is the workflow: User updates Dining Preferences = Pick-up or Dine-in in their User record Display menu when Dining Preference is not empty Us…

OK, now I get it. One thing you could do is create a template column on you menu items sheet that joins the description of the item and the user’s dining preference from the user profiles sheet. When adding to the cart, you would use this template column for the description instead of just the men…

Yeah I use the same approach for identifying the restaurant, by appending the id to the item description. ‘Copy Value’ feature would be very useful for sure!, and I would’ve thought not to complicated to implement :man_shrugging:

this option is not more possible, looks like. the initializing value doesnt exist anymore

Looks like it’s just text. You type in what you want.

Tomorrow I’ll send you my printscreen, because the If Then Tab I’ve is not like the one Nathan posted over here, I’ve only a big combo for the ‘Then’ and not ‘initializing value’ field. Or, this, will appear only for specific cases?

Hi Jeff, sorry for a late message, but im in Japan… and actually this is also another issue Ive to solve. As you can see the IF THEN ELSE doesnt give me any chanche to populate another field, I can only populate the same If Then Else virtual field, but this will not help me to populate automatical…

[image] trisixnine: the Today() date of Google sheet is located in US You can change your location settings in the Spreadsheet Settings. I think you’re misunderstanding the purpose of the If > Then > Else column, it populates itself and does not populate other fields in the same table.

Ok for the date. Yes I was looking to populate fields by default, I saw the above screen that it’s different than the one I have now, so I was thinking before was possible to populate other fields.

What do you want to be automatically populated? I think this can be done with a script.

Column Type: 'Copy Value'

Feature Requests

Jeff_Hager July 14, 2021, 12:59am 27

It’s just a Tiles style inline list that uses a relation. The data for the relation is built using formulas in the sheet. I explain it below, but you can copy the app and take a look for yourself.

Topic		Replies	Views
🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES! Project Showcase	88	6963	September 10, 2021
Formula to copy values from column to column Ask for Help	24	1466	December 30, 2020
Pre-populated values from previous record Ask for Help	8	935	May 23, 2020
New item/row with defaults set from most recent Ask for Help	24	976	October 4, 2022
Ability to "Set columns", "Increment" and "Delete Rows" via multiple relations Feature Requests	55	3508	July 21, 2025

Column Type: 'Copy Value'

Related topics