We have an internal Office Hours meeting more or less for anyone that is building an application. The objective is to share ideas and also to collaborate and align on approaches to problems so that we can develop best practices of building in Tulip as a team. Here’s something I learned in our last session:
The problem
I wanted the system to work so that every time I made a new quality event, it made a new entry in the table with a human readable ID that read something like QE-1, QE-2, QE-3…
Here’s how it works:
1/ Make a Table Query for all the records you want to count. In my case it is a Query for all entries where ID contains ‘QE’
2/ Make an aggregation. In my case the aggregation is COUNT()
3/ Add the query and aggregation to your app
4/ Add trigger logic that loads the Tulip Aggregation into a variable and creates a table records that increments the table aggregation by 1
I keep getting an error saying “Type integer is not valid in this context” when using LINK(), even though my aggregation (using mode) returns an integer. What am I doing wrong?
Hi @codygarcia. Just had a quick look, and what I believe you’re referencing is two ‘ characters, not a single “. What this does is convert the output to text format (rather than number/integer).
+’’ or +”” will be converted as the same thing. It will convert your result to a string.
You can also use TOTEXT( ) what will do the same thing here, however it behaves differently in some cases (e.g. on objects).
