About maretec

maretec

Hello.I have the following Table View.I want to filter the data by the column Elapsed Time, but this column is not shown in the Filter.The "Elapsed Time" column is a virtual column. "Show" and "Search" are ticked for this column as seen below. Why is...

maretec

Hello.I have the following Table View. I want to filter the data by the column Elapsed Time, but this column is not shown in the Filter. The "Elapsed Time" column is a virtual column. "Show" and "Search" are ticked for this column as seen below. "Col...

maretec

I have an app to register data from houses (color, rooms, address, etc.). Each house has several photos. It could be 10, 15 or more photos per house.I have a table with the data of the houses (Data Table) and another table with related photos of each...

maretec

I'm using Start End expressions in an Excel template. This template has one tab. There are 2 tables within this unique tab: the Roof Materials and the Walls Materials tables as shown below. The tables are defined by the borders. Each table has 5 rows...

maretec · 04-28-2024

I want to write the labels of an enum list with base type Ref, but I haven't found the formula to do it.This is the enum list with base type Ref column.This is the "Piezas Chapistería ID" column in my Google Sheet.Here you can see the column in the f...

maretec

Hello @TeeSee1. I had already tried setting the column type to "Number", but it didn't work because I hadn't converted the "Elapsed Time" from "Duration" to "Minutes".Now that I converted it, it works. This is the formula.TOTALMINUTES([CheckIn DateT...

maretec

I read this article before but didn't pay much attention to it because . . .https://support.google.com/appsheet/answer/10106509?hl=eI can also search by date, so I thought it wasn't explained well.I tried your suggestion. I made another virtual colum...

maretec

Excellent. 

maretec

Hello @MultiTech.  I will give it a try. Thanks

maretec

Ok. I got it. Thanks for your explanation @MultiTech .

My Stats

maretec's Bio

Badges maretec Earned

Recent Activity

Column not showing in search bar filter even though "Show" and "Search" are enabled

Filtering data in table view by virtual columns

Insert 2 photos per page

Adding new rows with Start End expressions in Excel templates

Writting labels from an enum list with Base Type Ref

Re: Column not showing in search bar filter even though "Show" and "Search" are

Re: Column not showing in search bar filter even though "Show" and "Search" are

Re: One item per line in a PDF file from an Enum List.

Re: One item per line in a PDF file from an Enum List.

Re: How to display EnumList values in separate rows