Not assigning relationship to user from secondary table

This is a lot more advanced and not possible without the aid of an API.

However, this is possible if you know how to use custom actions. Here’s documentation on that if you need help: https://help.adalo.com/integrations/custom-actions

@Abracadalo has an API called “String API” that you can use: https://docs.abracadalo.com/string-api#split Note: this does require having a FREE account with Abracadalo. Their string API is free to use, but some of the other APIs require the paid subscription. Just FYI.

Here’s how:
First, add a new text parameter to the user collection and call it “email domain” and add a text parameter to the company collection and call it “company domain”.

You don’t want to perform too many actions on 1 page, so let’s simplify the actions and make 2 screens.

The first screen will sign up the user. Email and password.

Add a custom action below the “Sign up” action using the string API with the “split” feature using the @ as the separator.

You can use the result of this API call to update the user’s “domain” parameter. So below the custom action, add an update logged-in user action to fill in the user domain.

Then, link to the next screen. Call the next screen “Loading” and delete all components. You can add a loading image or a lottie file animation for the user to see that actions are happening in the background.

Add 2 countdown timers to the screen and set them both to 3 seconds each.

Countdown timer 1, set the visibility to “Sometimes” if “Company > Count > is equal to > 0” with a custom filter where “company domain > is equal to > logged in user > domain”. Set the action to Create a company. Be sure to use logged-in user > domain to update the company domain parameter and then link to your preferred next screen.

Countdown timer 2, make a list from the countdown by clicking the settings button when the countdown is selected and click “Make a list”. Set the list to “Companies > All Companies”. Add a custom filter where “Company domain > is equal to > logged in user > domain”. Set the action to update company and add the logged-in user. Then link to your preferred next screen.

1 Like