About leinharte

leinharte

Hi.I would like to aggregate the values from the journal table into a trial balance table.The journal table has debit and credit columns. And the trial balance table has debitAmount, creditAmount, and endAmount.The debitAmount and creditAmount are ca...

leinharte

How can I add a value of type "Duration" to a value of type "DateTime" in 'Call a webhook'?As shown below, if you add the 'Duration' value to the 'DateTime' value in the column expression, you will get the desired result.However, the following code i...

leinharte · 11-25-2023

Hi.An error occurred at the "Valid if" in some of my apps. What was previously working well suddenly encountered an error.The symptoms are as shown in the picture below.The "Valid if" formula is as follows,The test result only shows a right parenthes...

leinharte · 08-23-2023

Hi.Does it not work that "Grouped: execute a sequence of actions" has two "Data: execute an action on a set of rows" with INPUT() function?I made the bot for a loop.There are two "Data: execute an action on a set of rows" actions. One is for setting ...

leinharte · 06-25-2023

Hi.My App logo well shows at the tab of Chrome browser, by the way not at Safari browser.Could you help me?

leinharte

@TeeSee1 Thank you very much.I solved the problem by writing 'debitAmount+creditAmount' in "App Formula".

leinharte

It works for me too. Here's what I discovered:1. It seems that the "Locale" in the Call a webhook code needs to match Google Sheet.2. Also, if we do not use the "eomonth()" function, it appears that it is possible to add the duration type value to t...

leinharte

Wow, I'll dig some more tomorrow.Thanks a lot.

leinharte

@Suvrutt_Gurjar I appreciate your kind reply.BTW, it does not work for me.When it comes to 'duration' or 'time' types, 'Call a webhook' is very tricky for me.Instead, I completed the app by only getting 'date' and 'duration' with 'Call a webhook' and...

leinharte

@Suvrutt_GurjarThe field type of "Duration" column is duration.

My Stats

leinharte's Bio

Badges leinharte Earned

Recent Activity

When calculating a value with "Call a webhook", how to apply the updated value?

Calculation of "DateTime" type and "Duration" type in 'Call a webhook'

Errors in “Data Validity” throughout the app

Does it not work that "Grouped: execute a sequence of actions" has two "Data: execute an action ..."

How to show my App logo at Safari's tab?

Re: When calculating a value with "Call a webhook", how to apply the updated value?

Re: Calculation of "DateTime" type and "Duration" type in 'Call a webhook'

Re: Calculation of "DateTime" type and "Duration" type in 'Call a webhook'

Re: Calculation of "DateTime" type and "Duration" type in 'Call a webhook'

Re: Calculation of "DateTime" type and "Duration" type in 'Call a webhook'