Please tell me how to do some basic programming techniques below in Bubble workflows: IF…Then Case … End case Do While (loop) to do some things of scan record by record in a table in Bubble database. make query to do some action as query in SQL database: Make the view to join some tables to view…

Use “Only When” [image] Just use multiple “only whens” to do the various tests. We don’t have this explicitly, but it is doable. This is “Schedule API Workflow” - so you run a “subroutine” on a list of records. Note that this is “a priori” in that you need to know the list of records in adva…

Thanks MigelG! It is very clear and helpfull with me, but how to do it In case primary key is two fields ? Regards, Long

In your search, test for the two fields existing.

Hi, No, I mean the primary key is a pair (not individual one by one), please see example below [image] Primary key in Contract_Device table is Contract_Number + Device_Model then it is foreign key in Device_Assign table, please tell me how to: Manage the primary key in a pair in Contract_table …

You manage it in “code” not in the database. [image] That is somewhat confusing, it is NOT anything to do with Primary and Foreign Keys. It is just what field shows up when you link two tables. In bubble, the way you link two tables is not via Keys. It is effectively via embedding the objects …

Thanks NigelG! I have tried Loop with “Schedule API Workflow” to loop from 1 to N then call API Workflow, can you tell me how to loop to scan a table each record from the first record to last record? Thanks and Regards, Long

Yes, “Schedule API workflow on a List”. And make that list the entire table.

Can you send me a example in Bubble, it is easy to me to understand how it works. Regards, Long

Hi NigelG, Can you send me a example, I need it for my app. Thanks! Long

Do IF... Then, Case, Do While, Loop in Bubble workflow

Need help Database

antonio.filgueira January 1, 2021, 12:20pm 11

HI Ihlong, I have the same problem that you explain. Do you have a solution how to solve this problem. Can you help-me please.
tks

1 Like

Topic		Replies	Views
How to setup two fields are primary key in same table Database	6	3015	October 25, 2022
Stop duplicate primary key in table Database	3	1919	March 14, 2018
How to query a value from bubble.io using a primary key Database	9	1132	July 5, 2023
Confused - How to create relationship between tables in database Database	8	2396	September 9, 2023
Primary Keys, Alternate Keys Clarification Database	4	2419	March 24, 2021

Do IF... Then, Case, Do While, Loop in Bubble workflow

Related topics