Lookup a lookup field

Bika.ai discussions
1

image
image861×849 56.9 KB

hello when will we be able to lookup a lookup field?

2

Hi @Kennypurnomo
Sorry, currently lookup fields do not support being looked up again. You can check the roadmap for the specific timeline. Thank you!
roadmap: Bika.ai - Automate Your Work with Intelligence

3

Okay. How about record_id() formula. I can’t retrieve it

4

Hi @Kennypurnomo
Sorry, currently the formula does not support the record_id() function to retrieve the record ID. However, you can use an alternative method to retrieve the record ID.

The steps are as follows:

  1. Create a field (e.g., “Record ID”) in the table (Table A) to store the record ID.
  2. Create an Automation node.
  3. Choose a trigger for the Automation based on your needs (e.g., scheduled, manual execution, or Record Created).
  4. In the Automation’s Action, add “Find Records” and “Update Record.”
  5. In the “Find Records” Action, select the table (Table A) that you just created.
  6. In the “Update Record” Action, choose the table (Table A) where the records need to be updated. In the “Record” input box, click the Setting button and choose the “Variable Component” option. Then, enter the variable to get the Record ID List. In the “Field” input box for “Record ID,” click the Setting button and choose the “Variable Component” option. Enter the variable to get the record ID and store the record ID in the table field.

Operation video：https://youtu.be/UufexsaG_Co

5

Do you have example for script using JS?