About cboteros

cboteros · 08-20-2023

Hello everyone,To give some background, I have 2 normal tables (ORDERS, PRODUCTS) and 1 intersection table (ITEMS) in this way:ORDERS -< ITEMS >- PRODUCTSThis should read:1 ORDER can have multiple ITEMS (ITEMS[itemOrder])1 PRODUCT can be in multiple ...

cboteros · 04-18-2022

Hello everyone,I hope someone can help me out. I have a table with a column which is a reference to the same table. In this way, there will be some "parent" record to one or some "child" records (and this can be recursive, so the "child" records can ...

cboteros · 12-16-2021

Hello everyone, I’m checking the new “Bots” function (what seems to be replacing the “Workflows”) and in the help article related to “Tasks” it says that it should be possible to “Change Data”: A task is a simple activity that runs quickly. For examp...

cboteros · 12-13-2021

Hello everyone, I have a question, is it possible to create a virtual column and use the Google Spreadsheet formula GOOGLEFINANCE() in that column? Anyone would know how to go about that?

cboteros · 05-22-2021

Good day everyone, I hope you can help me. I have a table TRANSACTIONS and I want to identify easily the “INCOMES” and the “EXPENSES”, so I have a column [transactionType] which is an enum with those two values. Then, I want to add 2 buttons “Add Inc...

cboteros · 09-01-2023

I've noticed that Appsheet very conveniently creates a "Related XYZ" row when you link between different tables, but it doesn't seem to do the same for recursive tables.In any case, I'm looking for an easier way to reference the "child" records. For ...

cboteros · 08-25-2023

SOLVED: Even my column was of type "Number", I had to use DECIMAL("") and it worked fine.

cboteros · 08-25-2023

Thank you @Marc_Dillon ,it worked like a charm!

cboteros · 08-25-2023

Maybe this used to work before or only works for Spreadsheet databases, because I'm trying now in 2023 while using an Appsheet database, and I'm always getting a "zero" instead of "blank".

cboteros · 05-23-2021

Thank you @Suvrutt_Gurjar as usual, your tips were very helpful! it worked like a charm!

My Stats

angeltba's Bio

Badges cboteros Earned

Recent Activity

Removing already used items from dropdown list of a reference column

"Is part of?" not working for deleting child records from same table?

How to use "Tasks" to Change Data?

Using the GOOGLEFINANCE() function in a virtual column?

How to pre-fill a column depending on the view

Re: Recursive relationship

Re: Action to set a Number field to be 'blank', instead of 0

Re: Removing already used items from dropdown list of a reference column

Re: Action to set a Number field to be 'blank', instead of 0

Re: How to pre-fill a column depending on the view

cboteros's Ideas (1)