This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi All,
I’m trying to create a new record in table A when a record appear in View of Table B.
It works the first time a record appears in the View, but no longer after that.
The objective is to generate orders (Table A) when product stock (Table B) f...
Hi,
When 2 tables are linked via a link record you have the ability to create a new record in the target table from the link column in the source table.
I would find very useful to be able to do the same when you want to delete a relation between the...
Hi,
I have two tables linked to each other by a 1 to n link.
Table 1 can have multiple linked records in Table 2.
In table Table 1 I have a lookup field from Table 2.
Of course when I have multiple records in Table 2 linked to one record in Table 1, ...
Hi,
Trying to add Minutes to a DateTime seems not to work when the minutes comes from another column.
Col1 : DateTime
Col2: Duration in Decimal (ie: 3.5 for 3h30m)
Col3: DateAdd(Col1,Col2*60,‘minutes’)
Result: Col3 = Col1
If instead of using Col2 in ...
Hi,
Great news to ear the last modified coming.
A side question is, will that update will make an “on update” trigger
available in zapier intégration ?
Cheers
Hi
The view solution only works once, the first tIme the record appears in the view.
After that if the same record shows up in the view the New record in view trigger doesnt fireup.
Cheers
Bernard
I also support that idea as it will be a good way to generate barcode and/or QR Code for printing and then scan with the new barcode field type.
Therefore a formula using image(URL) function (like in google spreadsheet) will best answer my needs as t...
Not sure that it’s you are looking for, but it sounds that the autonumber field type is exactly this, but it depends if you can afford holes in the sequence as deleting records keep the sequence to increment by one.
Just found a solution in my case.
My schema is:
Table 1 with the Date field.
Table 2 linked to table one and lookup the date from Table 1.
Table 3 linked to Table 2.
In Table 3 I need to lookup the Table 1 Date value, but through the Table 2 as I don...
