wynand
-
Array formula
let arr := [item(URL2.'1 - EV master file', 0)];for p in URL2.'1 - EV master file' doif p.UID_Key = 'Link 3 ID' thenarr := array(arr, [p])endend;if 'Link 3 ID' > "" thenarr := slice(arr, 1,…
-
Filter to show only one unique record if multiple same records in field
How should I state a filter to show only one instance of each record in the UID_key column. Thanks
-
Search and add a field from another record in same table to a record
let me := this;if LinkUrl1 thenfor i in select '1 - EV master file' where UID_Key = me.LinkUrl1 and Id != me.Id dolet myResult := (create URL);myResult.('1 - EV master file2' := me);myResult.…
-
Finding record in another table and returning a field
Hi, please help. I want to find the value entered in LinkUrl1 in the tabel EV strategy and then return WEV Brand Page from that table to URL1. thanks
-
Clearing Multiple Choise selections dynamicaly
Hi, I would like to clear the choices in the multiple-choice when the yes/no selection is false. How do I instruct a multiple choice to clear? Thanks stay safe
-
Extracting individual records from a sub-table to text field
I have a subtable with 32 records, only 6 of those qualify from further filter criteria. I want to create an individual text file showing the array of the ID codes of those six records.…
-
Syntax to use URL in function
case "Seats, BEV":"wattev2buy review & compare the " + 'No-Doors' + ", " + Seats + " seat " + 'Model Year' + " " + " " + "<strong><a href=" + html(WEV_brand_link) + ">" + html('Marque Brand') +…
-
Table within a record of other records in the table
Is it possible to create a table within a table showing other records from the main table that have the same field? So in Record with ID WEV0001216 I would like to have a table of all other records…
-
Multiple Choice in nested if formula
Help please - I have a multiple-choice and want to create text from it. When a region is selected it must form part of the text. But with the formula when the first selection is not chosen it does…
-
Cascade Fields
Hi, my table is getting huge, over 200 fields - is it possible to have cascaded views where I can only see the heading and click to open all fields of that section when need be?
-
Determine Multiple Choice baed on other field
Hi would like to set the value of a multiple-choice based on the value of another field, I have tried: if EU = 1 then EVG Sales Regions =: classification("Europe").…