About Peter_Bernsen

Peter_Bernsen · 07-12-2023

I have many bots that wait for minimum time, 5 minutes to be sure that for an order also the order details (child records) are in the G-sheet. This waiting prevent an order to be sent with not all the details. The problem is that 5 minutes is often 4...

Peter_Bernsen · 06-13-2023

I have an app in G-sheet that is getting very slow. Orders and order details.There ar too many records in the parent table (field [Archive]=true) and many child tables. What is the best way in transfering approximate 80% of the archive-records from t...

Peter_Bernsen · 03-16-2022

Dear all,I have a parent table with a ref to a child table.In the Ref-table there are in for example 10 values.Only one user is admin and is allowed to select on of the 10 values.Other Non-admin users only may choose from 6 specific values.I have a u...

Peter_Bernsen · 01-28-2021

With appsheet you can make good inspection - help desk apps. Client want to scan with a probe and update all network components into Appsheet. Like MAC/IP addresses, software installed, hardware components. With zoho-app with a probe it is done autom...

Peter_Bernsen · 10-10-2020

I have a table with a _ComputedKey. I have an action that needs to copy this virtual column _ComputedKey to an other table with some other fields. The action does not work with this Virtual Key Column. It runs, no warnings and no result. The same act...

Re: USER ID's for Security Filters · 03-13-2024

I know G-Forms, thought about it. Not all users have the same question. Works great when all questions are the same. Or I don't know how to do it of course :).Everey user have a different set of questions and it would be great if it is integrated in ...

Re: USER ID's for Security Filters · 03-13-2024

Hi @AleksiAlkio the app exists of just one table with four columns.Column A: TableIDColumn B: RelationIDColumn C: Questions per RelationIDColumn D : AnswerThe filter is the RelationIDThe masterAPP is linked to this table to make the connection with t...

Re: USER ID's for Security Filters · 03-13-2024

Is there a solution that different users through one login email address only see their records by entering an ID code (for example the uniqueID() that is generated and given to user).At each login they have to do this again so that one user does not...

Peter_Bernsen · 10-01-2023

Hi @SkrOYC I mail now with the product of Zenphi and works fine. It does not have a good HTML for the design but it mails with the Google workspace mailaddress and not noreply appsheet.

Peter_Bernsen · 09-26-2023

It is solved. The solution when I close a form was not workable because client needs a button to send the email when an order with the details is complete.The bug is resolved for waiting a period of time and now I can test it.

My Stats

Michelle's Bio

Badges Peter_Bernsen Earned

Recent Activity

Bot step waiting for a period inconsistant

Transfer parent and child archived records to other table

Role dependent select item, view selected item by all roles.

Synch data with a network probe to G-sheet

Action Copy row with a _ComputedKey does not copy this virtual key column

Re: USER ID's for Security Filters

Re: USER ID's for Security Filters

Re: USER ID's for Security Filters

Re: AppSheet email footer

Re: Bot step waiting for a period inconsistant