About Michel_van_Ruij

Michel_van_Ruij · 07-14-2022

This formula is in suggested values : sort(select(Input[block],[company]=[_THISROW].[company])).This formula does not produce a dropdown list with only the blocks equal to [_thisrow].[company].It produces a dropdown list of all blocks from input[bloc...

Michel_van_Ruij · 11-25-2021

How to get only the previous data in an enum list. This formula in suggested values does not do it: sort(SELECT(remarks[your name], and(([company] = [_THISROW].[company]),[proces]=[_THISROW].[proces])))

Michel_van_Ruij · 11-07-2021

Uploading data from a phone into a database. My app users are most of the time offline when they enter data into the app. So sycronising will be when online again. This takes a lot of time ( scouting app) It seems that ever single data entry is syncr...

Michel_van_Ruij · 03-10-2021

The read out values of different meters are stored in a file in date rows. The difference of each individual meter between _thisrow [readout] and the previous read out value of that specific meter has to be calculted and presented in a virtual column...

Michel_van_Ruij · 11-26-2020

IN([Company], SELECT(company[company], [name] = USEREMAIL())) This fomula is in the security filter for a data table with company as a column, it works fine and does filter correct on Primary view and also for Form view for this table. This app has a...

Michel_van_Ruij · 07-19-2022

Im sorry this did not help. When I remove the auto-complete property it shows nothing to choose from at al, then I can only add new blocks. There is no list of blocks shown from column [block] where the company is _thisrow company.It shows nothing at...

Michel_van_Ruij · 12-31-2021

I moved my data from Excel to Google sheets. The sync time went from 2 minutes to 8 seconds.

Michel_van_Ruij · 12-01-2021

This formula is only allowed in a type " list" column. My column if of type enum. My form must produce a dropdown list of all names from same company and same proces. This does not.

Michel_van_Ruij · 11-26-2021

The tabel “remarks” has the column [your name]. That column has lines with names ( previous data) When entering new data in a form for a table called “remarks” I would like to see the previous entered names from remarks[your name] in alphabetical ord...

Michel_van_Ruij · 09-24-2021

By adding “snipe” to the drawing type, I mean : when working on a desktop being able to snipe an image of a window or part of a window on the desktop. This will be a much easyer way to upload image files. Now Image files, I use them in type drawing, ...

My Stats

Michel_van_Ruij's Bio

Badges Michel_van_Ruij Earned

Recent Activity

enum list suggested value

Suggested value depending on previous data

Fast uploading data

Calculate difference between values from individual meters

Security filter does not filter second table data

Re: enum list suggested value

Re: Fast uploading data

Re: Suggested value depending on previous data

Re: Suggested value depending on previous data

Re: Make screenshot, like the "snipe" of a part of the screen and save is as a "drawing"

Michel_van_Ruij's Ideas (3)