About Jens_Damen

Jens_Damen · 01-06-2022

Hi AppSheet Community I have an inspection app to flag issues we locate during our surveys. The app has 2 main tables (Survey as parent and Detection as it’s child) It happens that certain issues are still present in the next survey and for that I cr...

Jens_Damen · 08-06-2021

I’m trying to guide my bot to different templates based on the language the user selected in the usersettings menu. My first guess was the obvious : USERSETTINGS([Preffered Language])="Dutch" So this formula lives in the “condition to check” section ...

Jens_Damen · 08-06-2021

My report consists of multiple blocks summarizing the values that are connected to that section. But if one section has no records I would like to hide that entire section of text. I’m already utilizing loops in reports but can’t seem to figure out i...

Jens_Damen · 08-03-2021

My parent table has a column (Survey Status) to indicate the status of that record. At this point I ask my users to manually update the status of old records from Latest to Previous. But of course after only a few surveys I end up with multiple Lates...

Jens_Damen · 05-07-2021

Hi all I have 2 sheets Sheet 1 houses the records for 2 of my dropdowns (enum with valid if selection to that sheet) Sheet 2 will save all data belonging to records (2 columns are the dropdown above) Now I already figured out that I can use suggested...

Jens_Damen · 01-07-2022

Thanks Suvrutt and Cale! I managed to implement it and it’s working just as I imagined it.

Jens_Damen · 01-06-2022

Ok, I think it’s clear to me. I’ll do some testing to see if I can get it to work. Thanks a lot!

Jens_Damen · 01-06-2022

I want to copy everything except Date and Survey ID. Survey ID needs to be the one from the previous manual entry and not the one from the clone. So it will be “Survey ID”; [MostRecent] ?

Jens_Damen · 01-06-2022

This might indeed be what I need. To make sure I understand correctly, Do I have to fill in every single column I want to copy like below? LINKTOFORM(“Table2 Form”, “Name2”, [Name1], “Color2”, [Color1]) And for date I’d have to use “Now()”, [Date] an...

Jens_Damen · 01-06-2022

My bad there. For a second I thought it was a build in function of AppSheet but it’s just an action I utilize. I updated the main post with my clone button.

My Stats

AmanJain18's Bio

Badges Jens_Damen Earned

Recent Activity

Automatically update Now() formula when cloning a row

Usersettings in "condition to check" when using branching with bots

Hide blocks of text in report template based on a column value

Update previous rows column value when a new row is added

Add to dropdown will save record in 2 sheets

Re: Automatically update Now() formula when cloning a row

Re: Automatically update Now() formula when cloning a row

Re: Automatically update Now() formula when cloning a row

Re: Automatically update Now() formula when cloning a row

Re: Automatically update Now() formula when cloning a row